SSRS report issue when printing more than 10 Sales Order

Kinetic ERP
, ,
1

I’m currently working on resolving an issue with report generation. When printing fewer than 7 sales orders at a time, the report generates the PDF files correctly. However, when I attempt to include more orders, an error occurs.

Does anyone have any idea what might be causing this?

Program Ice.Services.Lib.RunTask when executing task 962337 raised an unexpected exception with the following message: RunTask:
Ice.Core.SsrsReporting.SsrsCaller.SsrsException: The SSRS server returned the status code 500 (InternalServerError) with the following error text:
An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the dataset 'OrderHed'. ---> Microsoft.Data.SqlClient.SqlException: Cannot create a row of size 14928 which is greater than the allowable maximum row size of 8060.
   at Ice.Core.SsrsReporting.SsrsCaller.SoapCaller.Call[TContent,TResponse,TSoapHeader](String actionName, TContent content, TSoapHeader soapHeader) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsCaller\SoapCaller.cs:line 47
   at Ice.Core.SsrsReporting.SsrsRendererBase.TraceReportRendered(String printProgram, String ssrsRenderFormat, Func`1 timedAction) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 81
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport_HttpClient(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 385
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 278
   at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReportPart(String reportLocation) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 166
   at Ice.Core.SsrsReporting.StandardReportProcessor.ProcessReportParts() in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\SsrsReporting\StandardReportProcessor.cs:line 31
   at Ice.Core.RoutingAndBreaking.ReportPersister.Persist(ReportInstanceInformation reportInstance, Func`2 reportsRenderer, Action`1 fillSysRptLstRow, Action`2 processReport, Func`3 filterTableAttachmentsFunc)
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RenderUnroutedSsrsReport() in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 360
   at Ice.Core.RptTaskBase`1.XMLClose() in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 224
   at Erp.Internal.OM.SalesOrderAck.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP11.3.200.0\Source\Server\Internal\OM\SalesOrderAck\SalesOrderAck.cs:line 656
   at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 70
   at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 61
   at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 57
   at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:\_releases\ICE\ICE4.3.200.12\Source\Server\Services\Lib\RunTask\RunTask.cs:line 462
2

Looks like a max row size setting in your ssrs server. Curious, how many lines are on these sales orders?

3

This is a redesigned report from the default, it has less row. I am wondering if the report still wants to render all the lines, since I did not modify the RDD.

4

Is it possible there’s a comment field(s) with a lot of data in it?

1 Like
5

I would think row size to be the rows or data in the DB for the report not necessarily the multi-line comment field.

6

Check this post: SSRS allowable maximum row size of 8060 - #2 by hkeric.wci

7

The Comment box that is there, it has less than 50 characters. If I print 7 orders they come through but if I add more, it generates the error.

8

This is an SSRS server limitation. Please see the post above for more information.

2 Likes
9

clue

1 Like