web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

SSRS fetchxml report fails (sometimes)

(0) ShareShare
ReportReport
Posted on by 12

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

I have the same question (0)
  • Suggested answer
    Syed Ibrahim Profile Picture
    6,257 on at

    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.

  • Jeroen J Profile Picture
    12 on at

    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
    6,257 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 81 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans