Standard Report cannot be printed:The SSRS server returned the status code 500 (InternalServerError)

Kinetic ERP
1

When printing standard reports, some reports would show error.

Program Ice.Services.Lib.RunTask when executing task 121 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:
System.Web.Services.Protocols.SoapException: The item ‘/GJ_K23_2_CRP03/reports/InventoryMovement/MassIssue’ cannot be found. —> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/GJ_K23_2_CRP03/reports/InventoryMovement/MassIssue’ cannot be found.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo3& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
at Ice.Core.SsrsReporting.SsrsCaller.SoapCaller.Call[TContent,TResponse,TSoapHeader](String actionName, TContent content, TSoapHeader soapHeader) in C:_releases\ICE\ICE4.3.100.8\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsCaller\SoapCaller.cs:line 47
at Ice.Core.SsrsReporting.SsrsRendererBase.TraceReportRendered(String printProgram, String ssrsRenderFormat, Func1 timedAction) in C:\_releases\ICE\ICE4.3.100.8\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.100.8\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 384 at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE4.3.100.8\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 277 at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReportPart(String reportLocation) in C:\_releases\ICE\ICE4.3.100.8\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 165 at Ice.Core.RoutingAndBreaking.ReportPersister.Persist(ReportInstanceInformation reportInstance, Func2 reportsRenderer, Action1 fillSysRptLstRow, Action2 processReport, Func3 filterTableAttachmentsFunc) in C:\_releases\ICE\ICE4.3.100.8\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\ReportPersister.cs:line 58 at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RenderUnroutedSsrsReport() in C:\_releases\ICE\ICE4.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 360 at Ice.Core.RptTaskBase1.XMLClose() in C:_releases\ICE\ICE4.3.100.8\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 224
at Erp.Internal.IM.PrintMovement.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ERP\ERP11.3.100.0\Source\Server\Internal\IM\PrintMovement\PrintMovement.cs:line 255
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.3.100.8\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 70
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE4.3.100.8\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.100.0\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.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 457

2

Welcome to the forum!

The quoted part of the error above seems to point that the reporting service can’t find the report itself. This is pretty odd if it is a base/standard report.

Since you’re OnPrem, can you check to verify the “MassIssue” report is installed in the called out location?

1 Like
3

Agreed. Looks like either a pathing or permissions problem. That path is either wrong, or the account trying to access it can’t.

2 Likes
4

Might be the issue one runs across when uploading a modified report. When asked where the report is on your own machine, it I tempting to browse to where the RDL is.

But the upload is actually looking for the location of the “reports” folder on your local machine. It will take care the subfolders.