Job Traveler SSRS Error after Kinetic 2023.1 Upgrade

TrevorLenten · October 23, 2023, 3:00pm

We are testing kinetic 2023.1, upgrading from 10.2.700

When we try to run our custom report styles for the job traveler I am greeted with the following error. Has anyone seen this? I have a case open with Epicor but I’m getting crickets.

Other custom reports with custom styles work fine. Look to be using windows auth in the report builder.

It outputs to Excel ok just not PDF.

Program Ice.Services.Lib.RunTask when executing task 647748 raised an unexpected exception with the following message: RunTask:
Ice.Core.SsrsReportService.ReportExecutionSoapException: Exception of type 'Ice.Core.SsrsReportService.ReportExecutionSoapException' was thrown.
SOAP Fault: System.Web.Services.Protocols.SoapException: One or more data source credentials required to run the report have not been specified. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: One or more data source credentials required to run the report have not been specified.
   at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
   at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
   at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds))
Detail: <ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCredentialsNotSpecified</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">One or more data source credentials required to run the report have not been specified.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">https://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&amp;EvtID=rsCredentialsNotSpecified&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=15.0.1102.1002</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">15.0.1102.1002</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsCredentialsNotSpecified" msrs:HelpLink="https://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&amp;EvtID=rsCredentialsNotSpecified&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=15.0.1102.1002" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">One or more data source credentials required to run the report have not been specified.</Message></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />)
   at Ice.Core.SsrsReportService.ReportExecutionService.Render(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, Warning[]& warnings, String[]& streamIds) in C:\_releases\ICE\ICE4.2.300.11\Source\Shared\Lib\ReportingServices\ReportExecutionService.cs:line 150
   at Ice.Core.SsrsReporting.SsrsRendererBase_WebRequest.Render(SsrsRenderInformationBase renderInformation) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase_WebRequest.cs:line 150
   at Ice.Core.SsrsReporting.SsrsSingleDocumentRenderer_WebRequest.<>c__DisplayClass1_0.<RenderDocument>b__0() in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsSingleDocumentRenderer_WebRequest.cs:line 53
   at Ice.Core.SsrsReporting.SsrsRendererBase_WebRequest.TraceReportRendered(String printProgram, String ssrsRenderFormat, Func`1 timedAction) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase_WebRequest.cs:line 90
   at Ice.Core.SsrsReporting.SsrsSingleDocumentRenderer_WebRequest.RenderDocument(SsrsRenderInformationBase renderInformation, String reportPath, ParameterValue[] parameters) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsSingleDocumentRenderer_WebRequest.cs:line 46
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport_WebRequest(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 374
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 265
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReportForPreviewOrGenerate(RenderedSsrsReport renderedReport) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 480
   at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReportPart(String reportLocation) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 153
   at Ice.Core.SsrsReporting.StandardReportProcessor.ProcessReportParts() in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\StandardReportProcessor.cs:line 31
   at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReport(ReportDatabaseBuilder reportDatabaseBuilder, ReportInstanceInformation reportInstanceInformation) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 82
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.<>c__DisplayClass18_0.<RenderUnroutedSsrsReport>b__0(ReportInstanceInformation instance) in C:\_releases\ICE\ICE4.2.300.11\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\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\ReportPersister.cs:line 58
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RenderUnroutedSsrsReport() in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 355
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RunSsrsReportIfEnabled() in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 238
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.ProcessUnroutedReport() in C:\_releases\ICE\ICE4.2.300.11\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\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 116
   at Ice.Core.RptBase.ReportDatabaseBuilder.ProcessReportWithDataInPlace(SqlConnection connection) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 130
   at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 91
   at Ice.Core.RptTaskBase`1.XMLClose() in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 225
   at Erp.Internal.JC.JobTrav.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP11.2.300.0\Source\Server\Internal\JC\JobTrav\JobTrav.cs:line 579
   at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 81
   at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 68
   at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 59
   at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:\_releases\ICE\ICE4.2.300.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 39
   at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass30_2.<InnerRunTask>b__1() in C:\_releases\ICE\ICE4.2.300.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 453
   at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:\_releases\ICE\ICE4.2.300.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.2.300.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 450

jtownsend · October 23, 2023, 3:07pm

It mentions the data source. Double check that the report is pointed at the right one?

TrevorLenten · October 23, 2023, 3:12pm

Test connection to dsTraveler succeeds.

gpayne · October 23, 2023, 3:55pm

I searched EpicCare for credentials required to run the report have not been specified and got several hits. This one seems promising.

https://epiccare.epicor.com/epiccare?id=epiccare_kb_article&sys_id=f53ec5e9dba9f744e325a334ca9619d9

TrevorLenten · October 23, 2023, 4:10pm

Thank you for the link, it was all new info for me. I followed the video with no change in result.

gpayne · October 23, 2023, 4:19pm

Did you also check the links at the bottom of the page or look thru all of the results for the error. There are a lot of scenarios for this kind of an SSRS authentication.

You may also want to go back thru the install guide to make sure you hit all of the details for roles and features. When I have something like this is it usually a detail I missed in the guide.

TrevorLenten · October 23, 2023, 5:47pm

Yes I checked those links. I will mention this to the sysadmin that performed the server install and db conversion.