Dynamics Community Forum Thread Details

Cannot generate SSRS reports in Dynamics CRM v8.2

Hello,

We are getting an error when we try to generate reports from custom SSRS report in Dynamics CRM v8.2. Please check below image for reference:

There are also instances wherein we cannot set the Parameters because they are greyed out (disabled).

Here's a snapshot of the logs from Event Viewer when trying above action:

Exception information:
Exception type: CrmReportingException
Exception message: Unable to add entry to ReportExecutionIdCache for ExecutionId: jnu4yk3bnajs33ekmtmrlnbg
at Microsoft.Crm.Caching.ReportExecutionIdCacheLoader.LoadCacheData(String executionId, ExecutionContext context)
at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)
at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.CreateEntry(TKey key, IOrganizationContext context)
at Microsoft.Crm.Caching.CrmMultiOrgCacheBase`2.LookupEntry(TKey key, IOrganizationContext context)
at Microsoft.Crm.Web.Reporting.ReportViewerValidationHandler.ValidateReportSessionId(HttpContext context)

We have already checked:

Timeout session settings of the reporting server (SSRS)
CRM PROD was already set to sticky session and the cookies was stored on every front-end servers when established the session.

In addition, this issue only occurs in our Production environment and cannot be reproduced in our test environments (Production and lower environments have separate servers). Same issue occurs on all reports as well.

This has been an ongoing issue for a month already. Does anyone have any idea on what to check or how to resolve this issue? Thank you!

Quick Links

Subscribe to this forum!