Auto-Print BPM

So I’ve spent days trying to figure this out and need some help. I have several auto-print bpm’s that are not working. They are all very simple.

Any ideas?

Program Ice.Services.Lib.RunTask when executing task 695068 raised an unexpected exception with the following message: RunTask:
Ice.Core.SsrsReportService.ReportExecutionSoapException: Exception of type 'Ice.Core.SsrsReportService.ReportExecutionSoapException' was thrown.
SOAP Fault: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'OrderHed'. ---> System.Data.SqlClient.SqlException: Invalid object name 'OrderHed_8db9bbb7ddeb47cdadc556db793ef69a'.)
Detail: <ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsProcessingAborted</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error has occurred during report processing.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">https://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&amp;EvtID=rsProcessingAborted&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=15.0.1102.1140</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.1140</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</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="rsProcessingAborted" msrs:HelpLink="https://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&amp;EvtID=rsProcessingAborted&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=15.0.1102.1140" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error has occurred during report processing.</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsErrorExecutingCommand" msrs:HelpLink="https://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&amp;EvtID=rsErrorExecutingCommand&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=15.0.1102.1140" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Query execution failed for dataset 'OrderHed'.</Message><MoreInformation><Source>.Net SqlClient Data Provider</Source><Message>Invalid object name 'OrderHed_8db9bbb7ddeb47cdadc556db793ef69a'.</Message></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />)
   at Ice.Core.SsrsReportService.ReportExecutionService.SetExecutionParameters(ParameterValue[] parameters, String parameterLanguage) in C:\_releases\ICE\ICE4.2.300.22\Source\Shared\Lib\ReportingServices\ReportExecutionService.cs:line 189
   at Ice.Core.SsrsReporting.SsrsRendererBase_WebRequest.ConfigureReportServerForReport(String reportPath, ParameterValue[] parameters) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase_WebRequest.cs:line 171
   at Ice.Core.SsrsReporting.SsrsSingleDocumentRenderer_WebRequest.<>c__DisplayClass1_0.<RenderDocument>b__0() in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsSingleDocumentRenderer_WebRequest.cs:line 51
   at Ice.Core.SsrsReporting.SsrsRendererBase_WebRequest.TraceReportRendered(String printProgram, String ssrsRenderFormat, Func`1 timedAction) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase_WebRequest.cs:line 0
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReport(String ssrsRenderFormat, String printProgram, Boolean ignorePageSettings) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 265
   at Ice.Core.SsrsReporting.ReportProcessorBase.RenderReportForRouted(RenderedSsrsReport renderedReport) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 473
   at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReportPart(String reportLocation) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 168
   at Ice.Core.SsrsReporting.StandardReportProcessor.ProcessReportParts() in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\StandardReportProcessor.cs:line 34
   at Ice.Core.SsrsReporting.ReportProcessorBase.ProcessReport(ReportDatabaseBuilder reportDatabaseBuilder, ReportInstanceInformation reportInstanceInformation) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 79
   at Epicor.Utilities.Memoizer.<>c__DisplayClass0_0`2.<Memoize>b__0(TArgument argument) in C:\_releases\ICE\ICE4.2.300.22\Source\Shared\Framework\Epicor.ServiceModel\Utilities\Memoizer.cs:line 38
   at Ice.Core.RoutingAndBreaking.AddReportAsAttachmentAction.AttachReportsFromReportRequests(RetryChildNodeSettings retrySettings) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\AddReportAsAttachmentAction.cs:line 247
   at Ice.Core.RoutingAndBreaking.AddReportAsAttachmentAction.HandleProcess(Object sender, ProcessEventArgs e) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\AddReportAsAttachmentAction.cs:line 125
   at Ice.Core.RoutingAndBreaking.Workflow.Run(ReportInstanceInformation reportInstance) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\Workflow.cs:line 283
   at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RouteAndBreakReport(Func`2 executeCommand, Func`2 executeReader, SqlObjectsCreated sqlObjectsCreated) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 395
   at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 93
   at Ice.Core.RptTaskBase`1.XMLClose() in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 260
   at Erp.Internal.OM.SalesOrderAck.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP11.2.300.0\Source\Server\Internal\OM\SalesOrderAck\SalesOrderAck.cs:line 647
   at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 68
   at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE4.2.300.22\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 64
   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 63
   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

My first guess might be to check the data source in the SSRS Report. If you copied from a test environment, maybe using the wrong one.

Appears that the OrderHed dataset is either not being sent/returned from the RDD or maybe you left in a default parameter value during testing using an older temporary archived dataset? (I do do this occasionally when tweaking reports just keep using the same datasets until the report output looks like I want it)

3 Likes

That’s what it looks like to me.

1 Like

Unfortunately, nope.

After that BPM fires have you validated the dataset exists: OrderHed_{guid}? It should exist for a breif period of time on the server.

I don’t believe it is creating the dataset.
This only happens when a bpm triggers a report to execute. Any report.

2 Likes

How is the BPM supposed to access a dataset if it is not created? You need to find out how/why the dataset is not being created/there? Without insight or more details on the BPM and the needed dataset it will be difficult to assist further.

Can you run the report manually?

Have you tried reconfiguring the widget?

2 Likes

The report does run manually.

1 Like

Set your Auto-Print BPM to “Queued” - does that work?

2 Likes

Wow…Well, it worked for one of them…
I’m testing out in the others to see.

Why? Just why would it work with immediate for months, then suddenly stop working?

1 Like

Queued sends the report to your AppServer that handles submitted Tasks and Reports.
Direct / immediate processes your Report on the AppServer the BPM is running - typically a Transactional AppServer.

There are SSRS report settings at the AppServer level - based on it working when Queued, that indicates you have a mismatch in SSRS settings between the Transactional and Task / Reporting AppServers.

3 Likes

Is that the same process as RunDirect / SubmitToAgent ?

Yes.

1 Like

Thank you to everyone for the help!!!

1 Like