Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

SSRS fetchxml report fails (sometimes)

Posted on by 415

Hi,

we have this invoice report that we use to send to our customers. It's become rather a complicated one, but in 99,9% that's no problem at all.

One of my users came to me, because a particular invoice didn't render and gave a nasty error (rdProcessingAborted). I can run this report without any problems, only a few users can't. I've copied their privilages to my user to see if that would help, but no cigar.

Report server gives:

processing!ReportServer_0-39!1f44!02/05/2021-15:25:27:: e ERROR: An exception has occurred in data set 'Invoice'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the dataset Invoice. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:

Microsoft.Crm.CrmException: An unexpected error occurred.

System.ServiceModel.CommunicationException: The maximum message size quota for incoming messages (128974848) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

System.ServiceModel.QuotaExceededException: The maximum message size quota for incoming messages (128974848) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The maximum message size quota for incoming messages (128974848) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The maximum message size quota for incoming messages (128974848) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

   --- End of inner exception stack trace ---

Diagnostic tracing gives:

System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #448907BA: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.Crm.CrmReportingException: An error occurred during report rendering. ReportId:{0} ---> Microsoft.Reporting.WebForms.ReportServerException: An error has occurred during report processing. (rsProcessingAborted) ---> Microsoft.Reporting.WebForms.ReportServerException: Cannot read the next data row for the dataset Invoice. (rsErrorReadingNextDataRow) ---> Microsoft.Reporting.WebForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors

I don't really know what I could do to prevent this? Where do I increase the MaxReceivedMessageSize? (and why should that help if not everybody is experiencing this issue on this particular report/record?)

Thanks for thinking along with me.
Regards,

Jeroen

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at
    RE: SSRS fetchxml report fails (sometimes)

    Mostly because that particular user might have access to more data, example user might be on root business unit level full access or Sys admin.

    *******************************************************************************************

    If this suggestion resolved the issue, mark it as complete to close this thread.

  • Jeroen J Profile Picture
    Jeroen J 415 on at
    RE: SSRS fetchxml report fails (sometimes)

    Hi Syed,

    Thanks a million for getting back to me!

    I'm willing to try anything, but how could we explain why 1 user always gets the error while the other always gets a correctly rendered report?

  • Suggested answer
    Syed Ibrahim Profile Picture
    Syed Ibrahim 6,257 on at
    RE: SSRS fetchxml report fails (sometimes)

    It is due to the timeout issue when handling huge data on fetch. Increase  your CRM client session timeout as well as Follow the below suggestions to fix it.

    docs.microsoft.com/.../how-to-addressing-ssrs-session-timeouts

    Hope this helps.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans