Not able to Deploy SSRS report in Ax 2012 R2

(0) Share

Report

Posted on by Community Member Microsoft Employee

Dear All,

I have imported SSRS report from Ax2012 R3 to Ax2012 R2. When I deploy the report the Following error coming. Can anyone suggest How to deploy this SSRS reports from R3 to R2?

Message (10:08:41 pm)
Configuration ID: MSSQLSERVER
Description:
Default: True
Report server name: TESTSERVER
Report server folder name: DynamicsAX
Report server manager URL: http://testserver/Reports
Report server web service URL: http://testserver/ReportServer
Application Object Server name: 01@TESTSERVER
SharePoint integrated: False

An error occurred while deploying the report ContractInvoiceReport.
This might be because the SQL Server Reporting Services extensions have not been installed on the report server, or configuration information has not been entered in the Report Servers form in Microsoft Dynamics AX.
System.Web.Services.Protocols.SoapException: Error while loading code module: ‘ContractInvoiceReport.BusinessLogic, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly ContractInvoiceReport.BusinessLogic, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
Report name: ContractInvoiceReport
Design names: ContractInvoiceReport.Report
Deployment status for design names: Error

1856.error_2D00_1.JPG

*This post is locked for comments

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Not able to Deploy SSRS report in Ax 2012 R2

Hi Muhammad Zaid,

If possible, please tell me how you imported. can you tell me the steps?

Thanks

Suresh
Community Member Microsoft Employee on at

Like (0)

Report

RE: Not able to Deploy SSRS report in Ax 2012 R2

Hi Suresh,

I have restarted Ax Service and also SQL Reporting Service and cleared Report Server cache. Same issue there...!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Not able to Deploy SSRS report in Ax 2012 R2

Hi Muhammad Zaid,

Once restart sql server reporting service. and try again.

Thanks

Suresh
Community Member Microsoft Employee on at

Like (0)

Report

RE: Not able to Deploy SSRS report in Ax 2012 R2

Hi Suresh,

I tried what you said. But again I am facing same error msg. is there any steps to be followed when imported SSRS reports from Ax2012 R3 to Ax2012 R2..?

Hi Crispin,

I tried with incremental CIL after importing. But same issue exists. Reporting service extensions are missing - Other reports are working well.

I have imported 2 SSRS reports from Ax2012 R3 to Ax2012 R2. One is default report with same changes which is deployed and working well.

And another one is new Report which is throw error while deploying.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Not able to Deploy SSRS report in Ax 2012 R2

Hi Muhammad Zaid,

Delete your report in report server and try import your report again, clear the report server cache and deploy it. it may work.

Report server manager URL: http://testserver/Reports

Thanks

Suresh