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

(0) Share

Report

Posted on by Gao Lu Wang

180

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)

All responses (12)

Answers (0)

nisthar 15 on at

Like (0)

Report

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

Your report modification should not overlap any existing objects. The new modification insertion objects are to created in new row or column. then deploy.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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

If you have been doing a version upgrade, you follow the code upgrade checklist without errors? There is a point for upgrading SSRS reports that does something in the backend (cannot recall on the top of my head), maybe that is the step you have missed.

Also I have noticed that sometimes a report cannot be deployed if it is already there on your reporting instance. Try to delete it first on your reporting URL in the DynamicsAX folder, then attempt to deploy it again.

Was this reply helpful? Yes No
Gao Lu Wang 180 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Gao Lu Wang 180 on at

Like (0)

Report

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

Thanks Vilmos,

Can we know which reports use SSAS datasources?

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Gao Lu Wang 180 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Gao Lu Wang 180 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Gao Lu Wang 180 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No