web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error when deploying S...
Microsoft Dynamics AX (Archived)
Suggested Answer

Error when deploying SSRS reports "The report definition is not valid."

(0) ShareShare
ReportReport
Posted on by Gao Lu Wang 182

Hi everyone,

I deploy the SSRS reports in AOT after install AX 2012 R3 CU11,I always find some of the standard reports without any customization can not be deployed .

The full error information is like the following(AgreementConfirmation is just an example, there are several reports can not be deployed)

"An error occurred while deploying the report AgreementConfirmation.
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."

"The report definition is not valid.  Details: The report definition has an invalid target namespace 'schemas.microsoft.com/.../reportdefinition' which cannot be upgraded."

The environment is as follows:

AX 2012 version : AX 2012 R3 CU11  

SQL server version: SQL Server 2008 SP3 CU17

Is the error caused because the SQL server version too old? Can this SQL Sever version support AX 2012 R3 CU11?  

And the current Visual Studio is still 2010,I know it can not support AX 2012 R3 CU11,is there any relationship to the deploy issue?

Any help will be appreciated.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Gaolu,

    Have you successfully deployed the reports? Is this your first deployment of reports? Make sure that report extension is installed by using ax wizard on its first deployment of reports then you can install another reporting extensions using powershell.

    Thanks,

    Raph

  • Gao Lu Wang Profile Picture
    Gao Lu Wang 182 on at

    Hi Raph,

    I already installed the extensions. Then I deployed all reports in powershell, most reports can be deployed, but some reports such as AgreementConfirmation can not be deployed. Then I try to deploy it in AOT, it still brings out the sames error.

  • Gao Lu Wang Profile Picture
    Gao Lu Wang 182 on at

    Does anyone had similar experience? Is it because of the SQL version issue?

  • Gao Lu Wang Profile Picture
    Gao Lu Wang 182 on at

    If no one answers this question,I will wait to upgrade to SQL Server 2012 to see whether it can be deployed.

  • Community Member Profile Picture
    Community Member on at

    Hi GaoLu,

    Have you done an upgrade of an existing AX 2012 installation to CU11 and have you reused the SSRS report server?

    Then it might be worth trying to deploy a new SSRS instance and then try to deploy the reports to the new instance instead.

  • Gao Lu Wang Profile Picture
    Gao Lu Wang 182 on at

    Hi Johan,

    Thanks for your response.

    Yes, I have upgraded the existing AX 2012 installation to CU11 .

    I uninstall the component "Reporting service extensions" from AX environment.

    Then I re-install this component again with CU11 update and I still have this issue after that.

    So I think it will not work if I just deploy a new SSRS instance.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    The reports which you cannot deploy are most likely using datasources from SQL Server Analysis Services cubes. Have you deployed SSAS cubes in AX? Try report deployment after that. If you do not want to use those OLAP cubes, then you will not be able to use the associated SSRS reports as well.

  • Gao Lu Wang Profile Picture
    Gao Lu Wang 182 on at

    Thanks Vilmos,

    Can we know which reports use SSAS datasources?

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    I wrote a job that ignores reports with errors (including the ones with SSAS datasource) and deploys the rest that it can.

    www.daxrunbase.com/.../deploy-ssrs-reports-ignoring-errors

    I do not remember the exact output, but it will probably tell you that which reports have failed. If not, you could try to extract the report name from the object in the catch code block, to have a list of reports.

  • Gao Lu Wang Profile Picture
    Gao Lu Wang 182 on at

    Hi Vilmos,

    I don't think that the reports which can not be deployed are with SSAS datasource.

    I use the query  to get the list of reports which has SSAS CUBES from this post.https://community.dynamics.com/ax/b/ftdynamicsax/archive/2015/06/05/ax2012-listing-reports-which-run-against-ax-ssas-cubes.           

    For example, the report AccountantInvestmentAnalysis is on the list, but I can deploy it successfully.

    And the report AgreementConfrimation is not on the list, but I can not deploy it. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans