Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

Cannot generate SSRS reports in Dynamics CRM v8.2

Posted on by 50
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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans