Hi All, Can anyone explain this one to me? I am getting this on CustomReports only with Base Reports working fine. I copied these from live server to a development server and got this error. Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Syste…

Yes, it was the SharedDataSource connection string was deleted when transferring the database from live to dev. You might want to look there first, I will post my string tomorrow for you.

Are those from the SSRS Report Server log or a different log?

Did you set the Data Source when you copied over from the other environment?

ERP10: An error occurred trying to run task ID 1292657 for agent SystemTaskAgent on the application server (User: EDR, Task Description: Sales Order Acknowledgment). Error Detail: Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services…

Does running the report with the output destination of “Generate Only” succeed? Do the RDL’s datasets in Dev and Prod match? If someone pressed the Sync button, the RDL may have changed in a way that no longer works with the RDD. FWIW - I’ve never seen a reference like “dbo.udf_...” in a report …

I’ve never seen this before… I’m currently copying the ReportServer database and catalog… The RDL files aren’t stored in the place I thought. I can’t seem to find the RDL files… Looked in SQL Program Files inetpub/ERP10/Server/Reports/CustomReports - Blank just BAQReport. Decided to copy whole …

[image] aarong: The RDL files aren’t stored in the place I thought. I can’t seem to find the RDL files… Looked in SQL Program Files inetpub/ERP10/Server/Reports/CustomReports - Blank just BAQReport. RDL files are stored in blobs in the SSRS database and not as files anywhere.

[image] aarong: Decided to copy whole report database over :grimacing: The RDL’s aren’t stored as files. They are stored in the DB in a table.

Thought as much… Hopefully this will do the trick.

From what I recall… there are three DB’s related to reporting in Epicor RPT_PRD_102300 (the actual name comes from the value in the EAC setting) - This holds the info generated by the reports RDD (or BAQ). Table names like dbo.Company_<GUID> are in here. [image] (Report Settings tab in EAC) …

SSRS CustomReports

Epicor ERP 10

Adam (Adam Szymanski) February 3, 2021, 9:22pm 14

That was it!

Topic		Replies	Views
Customized SSRS report error Epicor ERP 10 e10	7	1523	April 3, 2019
Why would a report data set fail to load in 10.2.200.12 coming from 10.1.500.35 Epicor ERP 10 e10	14	1834	August 4, 2020
SSRS Report Error Epicor ERP 10	9	8054	June 26, 2017
E10 SSRS Reporting Error Yahoo Archive	1	1759	July 15, 2015
One report change, now an error... works on Pilot, not on Live Epicor ERP 10 ssrs	23	2285	November 2, 2018

SSRS CustomReports

Related topics