Error Running Base Reports in Dynamics AX

Error Running Base Reports in Dynamics AX

Error Running Base Reports in Dynamics AX

When running base reports it is possible to get this error:

Error Running Base Reports in Dynamics AX 2012

 

This typically occurs after removing/enabling licenses in AX or when EDT relations are changed.  It usually corresponds to one of the table relations setup on the EDT being incorrect.  However it can be very difficult to determine when report temp tables are large with fields across tons of base tables.

To resolve connect to the server where SSRS is hosted.
Open up ‘Event Viewer’
Then look for errors under Windows logs > application

Error Running Base Reports in AX

 

Then if you go to the EDT for the problem EDT:

Error Running Base Reports in AX

 

From here need to re-establish the relation (in the example it would be to the WAXInventStatusTable.WAXInventStatusId).  Then with the relation built the report should now run successfully.

 

 

 

 

Share on Google+Tweet about this on TwitterShare on LinkedInShare on FacebookEmail this to someone