Microsoft Dynamics AX (Archived)

Standard statistics report can't print with error "No such host is known"

(0) Share

Report

Posted on by Community Member

Hi, I am work on dynamics AX 2012. I have 3 statistics report cannot print with error "No such host is known"

Path 1: Account Payable> Reports> Statistics> Vendor> Purchases in the past periods

Path 2: Account Payable> Reports> Statistics> Vendor> Top vendors by YTD purchase

Path 3: Account Payable> Reports> Status> Total accounts payable in the past periods chart

Open preview from VS get the error:

Error 2 Error connecting to DynamicsAXOLAP : A connection cannot be made. Ensure that the server is running.. LedgerTotalAcctsPayablePastXPeriod.FullPage [Preview] 0 0

Open IE from report server get the error:

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'Company'. (rsErrorExecutingCommand) A connection cannot be made. Ensure that the server is running. No such host is known

I already redeploy all report, full gen CIL, service SSAS ald started, report server connection correct, all other report can print except this 3 reports.

No error record in event viewer.

Any idea?

Thanks in advance.

Regards

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report

Hi S,

Please validate the SSRS server setting, have you used Power shell to deploy the reports? Have you tried with other browsers.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Umesh Pandit,

This is the report in Dynamic AX 2012, I already tried Power shell run with administrator and deploy all report. still can't work. My other report all can work with the server setting.

Thank you for your reply.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Have you resolve problem? I am facing same error

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Vijay, those reports refer to data stored in the AX cubes. Have you deployed and processed them? Ludwig

Was this reply helpful? Yes No
Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report

try: https://technet.microsoft.com/en-us/library/gg731892.aspx

https://technet.microsoft.com/en-us/library/dd309683.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi.. Ludwig,

Thanks for your reply, I have deployed and processed via powershell and also checked to do reinstall and redeployed reports, but getting same problem.

Please Note:- I am getting this error only in Retails Reports rest AX Standard reports working fine

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi...Umesh

Thanks for your Reply, I am getting this error only in Retails Reports rest AX Standard reports working fine

Was this reply helpful? Yes No