When trying to run an SSRS report the following message was returned:
Failed to load expression host assembly. Details: Could not load file or assembly ‘expression_host_1c6a722005524f70be7333e2c928f09a, Version=12.2.3000.0, Culture=neutral, PublicKeyToken=null’ or one of its dependencies. Failed to grant permission to execute. (Exception from HRESULT: 0x80131418) (rsErrorLoadingExprHostAssembly)
When running a report in DAX2012 you might get the following message:
The DefaultValue expression for the report parameter ‘AX_CompanyName’ contains an error: Request for the permission of type ‘System.Security.Permissions.EnvironmentPermission, mscorlib, Version=220.127.116.11, Culture=neutral, PublicKeyToken=b77a5c561934e089’ failed. (rsRuntimeErrorInExpression)
The error seems to occur mostly with Reporting Services that have been configured to use a Microsoft Dynamics AX configuration file, Microsoft.Dynamics.AX.ReportConfiguration.axc.
When testing report it is useful to switch on the remote debugging so the error messages are displayed on your local system.
This can be done by running a SQL script against the reporting server database:
SET Value = ‘TRUE’
WHERE Name = ‘EnableRemoteErrors’
Remember to restart your reporting service after you make this change.
Trying to do an install of SSRS with AX2012 R2 and came across another endpoint issue. Looking at the AIF inbound ports found none of the services would start. Each one would report the following type error:
Object Server 01: System.OperationCanceledException: AIF service group not activated. Service group: BIService. Error: HTTP could not register URL http://+:8101/DynamicsAx/Services/ BIService /. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details.
When installing SSRS server I have recently experienced a problem with the AX SSRS extensions not installing and resulting in an installation rolling back. The error message received was:
Unable to find appropriate service endpoint information in the configuration object.