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
*This post is locked for comments
Hi Muhammad Zaid,
If possible, please tell me how you imported. can you tell me the steps?
Thanks
Suresh
Hi Suresh,
I have restarted Ax Service and also SQL Reporting Service and cleared Report Server cache. Same issue there...!
Hi Muhammad Zaid,
Once restart sql server reporting service. and try again.
Thanks
Suresh
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156