Running a Report in Pilot

Kinetic ERP
1

I am having an error when running a custom BAQ Report in either Kinetic browser or Classic. I had to open classic pilot to upload the report style, but it didn’t resolve this error. I get the same error in Kinetic browser, and in Classic. The report runs without issue in Live.

Program Ice.Services.Lib.RunTask when executing task 1041468 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:
The item '/SaaS512PilotSSRS_00000/reports/CustomReports/Tenants/00000/JobSnapshotPric' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/SaaS512PilotSSRS_00000/reports/CustomReports/Tenants/00000/JobSnapshotPric' cannot be found.
   at Ice.Core.SsrsReporting.SsrsCaller.SoapCaller.Call[TContent,TResponse,TSoapHeader](String actionName, TContent content, TSoapHeader soapHeader) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsCaller\SoapCaller.cs:line 47
   at Ice.Core.SsrsReporting.SsrsCaller.SoapCaller.Call[TContent,TResponse](String actionName, TContent content) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsCaller\SoapCaller.cs:line 27
   at Ice.Core.SsrsReporting.SsrsCaller.ReportExecutionService.LoadReport(String report, String historyId) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsCaller\ReportExecutionService.cs:line 49
   at Ice.Core.SsrsReporting.SsrsRendererBase.ConfigureReportServerForReport(String reportPath, ParameterValue[] parameters) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 164
   at Ice.Core.SsrsReporting.SsrsRendererBase.InitializeRendering(SsrsRenderInformationBase renderInformation, String reportPath, ParameterValue[] parameters) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 131
   at Ice.Core.SsrsReporting.SsrsSingleDocumentRenderer.<>c__DisplayClass1_0.<RenderDocument>b__0() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsSingleDocumentRenderer.cs:line 47
   at Ice.Core.SsrsReporting.SsrsRendererBase.TraceReportRendered(String printProgram, String ssrsRenderFormat, Func`1 timedAction) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 81
   at Ice.Core.SsrsReporting.SsrsSingleDocumentRenderer.RenderDocument(SsrsRenderInformationBase renderInformation, String reportPath, ParameterValue[] parameters) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsSingleDocumentRenderer.cs:line 42
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport_HttpClient(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 349
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 243
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReportForPreviewOrGenerate(RenderedSsrsReport renderedReport) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 655
   at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReportPart(String reportLocation) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 159
   at Ice.Core.SsrsReporting.StandardReportProcessor.ProcessReportParts() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\StandardReportProcessor.cs:line 31
   at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReport(ReportDatabaseBuilder reportDatabaseBuilder, ReportInstanceInformation reportInstanceInformation) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 88
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.<>c__DisplayClass18_0.<RenderUnroutedSsrsReport>b__0(ReportInstanceInformation instance) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 357
   at Ice.Core.RoutingAndBreaking.ReportPersister.Persist(ReportInstanceInformation reportInstance, Func`2 reportsRenderer, Action`1 fillSysRptLstRow, Action`2 processReport, Func`3 filterTableAttachmentsFunc) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\ReportPersister.cs:line 57
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RenderUnroutedSsrsReport() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 355
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RunSsrsReportIfEnabled() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 238
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.ProcessUnroutedReport() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 231
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.ProcessReportWithDataInPlace(Func`2 executeCommand, Func`2 executeReader, SqlObjectsCreated sqlObjectsCreated) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 116
   at Ice.Core.RptBase.ReportDatabaseBuilder.ProcessReportWithDataInPlace(SqlConnection connection) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 130
   at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 91
   at Ice.Core.RptTaskBase`1.XMLClose() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 225
   at Ice.Internal.XA.DataBuilders.DatabaseReportDataBuilder.RunReport(ReportDatabaseConnectionHelper reportDatabaseConnectionHelper) in C:\_releases\ICE\ICE5.1.100.0\Source\Server\Internal\XA\XABaqRpt\DataBuilders\DatabaseReportDataBuilder.cs:line 94
   at Ice.Internal.XA.DataBuilders.DatabaseReportDataBuilder.RunReportWithErrorHandling(ReportDatabaseConnectionHelper reportDatabaseConnectionHelper) in C:\_releases\ICE\ICE5.1.100.0\Source\Server\Internal\XA\XABaqRpt\DataBuilders\DatabaseReportDataBuilder.cs:line 56
   at Ice.Internal.XA.DataBuilders.DatabaseReportDataBuilder.WriteData() in C:\_releases\ICE\ICE5.1.100.0\Source\Server\Internal\XA\XABaqRpt\DataBuilders\DatabaseReportDataBuilder.cs:line 44
   at Ice.Internal.XA.BAQReport.DetermineOutputLocationAndWriteTables(String outputFileName, DataSet baqResultData) in C:\_releases\ICE\ICE5.1.100.0\Source\Server\Internal\XA\XABaqRpt\BAQReport.cs:line 102
   at Ice.Internal.XA.BAQReport.WriteTables(String outputFileName, DataSet baqResultData) in C:\_releases\ICE\ICE5.1.100.0\Source\Server\Internal\XA\XABaqRpt\BAQReport.cs:line 95
   at Ice.Internal.XA.BAQReport.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ICE\ICE5.1.100.0\Source\Server\Internal\XA\XABaqRpt\BAQReport.cs:line 44
   at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 53
   at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 114
   at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 62
   at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:\_releases\ICE\ICE5.1.100.5\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 42
   at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass19_2.<InnerRunTask>b__1() in C:\_releases\ICE\ICE5.1.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 352
   at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:\_releases\ICE\ICE5.1.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\ICE5.1.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 349

Normally just reuploading the report style would be enough to get rid of this. But it still gives the same error. Note I replaced our site ID with 00000. Am I missing something?

1 Like
2

Did to confirm Valid checkbox was ticked on ReportStyle Company?

3

Confirmed Valid is checked for the company.

2 Likes
4

We had something similar to this (forget if it was exact same error) that we had to install the latest update of SSRS from Microsoft to fix.

5

Is that the same path as what’s in Report Style? I swear ours for SaaS would be ‘reports/CustomReports/JobSnapshotPric’

6

I think that’s what it should be. We never use that tenant directory. I assume that is something that happens in the cloud once we upload the report style.

1 Like
7

Perhaps try downloading the report from Report Style and see what folder structure it comes down with.

8

I went to classic, and I was able to upload the report style as usual. I guess the style upload doesn’t work in Kinetic, or it needs some other format (it asks for a zip file). I’ll have to dig into that later. For now, thank goodness classic still works!

9

Nope that’s been broke for a bit. :neutral_face:

1 Like