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