Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Not able to Deploy SSRS report in Ax 2012 R2

Posted on by 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans