SSRS report in production database taking over 1 hour to run and rowcount is over 3,000,000. Same report in the tran database takes less then 1 minute and rowcount is 147

Epicor ERP 10
,
1

I have a production database and a train database which is a copy of the production database. I run the sales order acknowledgement report for the same order using the same data and report in both databases. Below are the statistics. Please help!!!
Thanks,
Richard
|InstanceName|UserName|Format|TimeStart|TimeEnd|TimeDataRetrieval|TimeProcessing|TimeRendering|Source|Status|ByteCount|RowCount|
|SQL01\MSSQLSERVER|EpicorAdmin|PDF|2022-05-22 18:28:36.930|2022-05-2219:41:07.450|61325|4283491|3615|1|rsSuccess|195269|3007443|
|SQL01\MSSQLSERVER|EpicorAdmin|PDF|2022-05-22 17:03:24.243|2022-05-2217:03:27.227|123|645|1967|1|rsSuccess|194295|147|

2

If this is an Epicor BAQ Report, make a backup copy of the Report Data Definition and do some testing there.

Are you using the Standard SSRS report? There is an Epicor Fix you can get to restore the standard reports and data definitions (Seed Reports) - or redeploy the instance.

3

Do you know the problem/case/fix number?

4

Found it it’s KB0043739