04 January 2012

Deploy Dynamics AX 2012 default SSRS reports

If you get the following error message while trying to open a standard report in Dynamics AX 2012:

Error while setting server report parameters. Error message: Das /DynamicsAX/StaticReports/en-US/SalesInvoice.Report-Element wurde nicht gefunden. (rsItemNotFound)


The first thing to check are the reportServer Settings in AX: System administration -> Setup -> Business Inteligence -> Reporting Services -> Report Server


Click Validate Settings to find out if the parameters are set correctly. If this succeeds Ax is set up correct and you'll only have to deploy the AX Reports to the SSRS Server. Therefor you need to open an instance of the Microsoft Dynamics AX 2012 Management Shell (run as Administrator).  
In the PowerShell window you can use the following command:

Publish-AXReport -ReportName * 

or to publish just one Report

Publish-AXReport -ReportName NameOfTheReport 
when having problems with user permissions one solution could be the parameter -skipReportServerAdminCheck.
Microsoft said: Actually the code inside axutil is trying to make a check for the user’s permissions – and it is the check itself that needs higher permissions (it’s looking into Active Directory). So the problem is that the user does not have enough rights to make the check in Active Directory, but they would have enough to actually deploy reports
Publish-AXReport -ReportName NameOfTheReport -skipReportServerAdminCheck

If you want to deploy Reports from the AOT it's recommended to start the AX as an Administrator

3 comments:

Anonymous said...

how do you deploy the reports from the command line?

TWI said...

The PowerShell command is the following:
Publish-AXReport -ReportName CustTransList –servicesAOSname NameOfTheAOS –servicesAOSWSDLPort WSDLPortOfTheAOS

AML said...

Hi,

When deploying AX 2012 reports, I got this following error message.

"The security group Administrators contains a member that is causing the following error : An error (1332) occured while enumerating the group membership. The member's SID could not be resolved."

"The deployment was aborted. You do not have priviledges to deploy to server: appserver. For deployment, you must have
administrative rights to the SQL Server Reporting Services (SSRS) server. Contact your administrator to deploy."


What does this mean?

Looking forward to hear from you very soon.


Regards,
AML