I am getting the following error after copying over our SSRS database to our 10.2.200 environment. The report dataset and report style are both in there as well. I am not sure where to go with this, can anyone help me?
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: 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 ‘dsRMA’. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
Stack Trace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.SetExecutionParameters(ParameterValue Parameters, String ParameterLanguage) in C:_Releases\ICE\ICE3.2.200.12\Source\Server\Internal\Lib\TaskLib\Web References\SsrsReportService\Reference.cs:line 497
Have you checked to make sure that the fields used are named the same in both places? We had a similar issue when they changed the MfgJobType field on OrderDtl.
aidacra
(Nathan your friendly neighborhood Support Engineer)
6
Do standard reports work fine and only custom reports are impacted?
It looks like you are working with the RMA report. Have you confirmed that the data source for this report is pointing to the correct shared data source? It should be in the reports subfolder of the root folder specified when the SSRS reports were deployed from the Epicor Administration Console.
Thank you for jumping in, all of the other custom reports work fine. I checked out the data source for the report and it is pointing to the same data source that all the rest of the custom reports are pointing to, the only shared report data source we have set up, the one in the subfolder of the root folder. I have confirmed that the shared datasource itself is pointing to the correct dataset DB.
It is a custom report data definition with several other tables joined to the tables from the base definition. I tried to re-do the relationships, but that didn’t work. I am out of ideas.
@aidacra When I get this error, does it mean that the query failed to execute in the Report? OR does it mean that the data didn’t even generate?
Does the data get insterted into the SSRS Reporting Database no matter what?
In other words, what is truly failing? Is it Epicor failing to execute the report data definition and create the tables in the SSRS reporting database or is there something wrong with the .rdl dataset query?
I would be able to answer this question myself if i knew the GUID from the system monitor, but I don’t because it just errors out…
