SSRS Report error – Assemble expression_host

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)

Continue reading

Advertisements

SSRS Report Error – AX_CompanyName

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=2.0.0.0, 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.

Continue reading

Report debugging – error messages

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:

UPDATE    ConfigurationInfo
SET        Value = ‘TRUE’
WHERE    Name = ‘EnableRemoteErrors’

Remember to restart your reporting service after you make this change.

AX 2012 R2 SSRS Installation Service Endpoint Error (part 2)

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.

Continue reading