I’ve browsed through the forums, but I’m not finding what I’m looking for. We are upgrading from .400 to .700 and running into a custom SSRS issue. Our ARForm throws the error “Query execution failed for dataset ‘CashTransaction’”. I tried deleting the dataset in the report, but saving errors and me…

In the end, I re-uploaded the SSRS manually through the web gui, no go. I deleted and re-imported the RDD, compared with our current .400 version, nothing. @ckrusen helped me rethink the issue. Years ago Epicor installed a custom view on our reporting db because of some customization that they coul…

You need to check the SSRS Report Server logs on the server to get the “full” error. Do you have access to the server where the report server is?

Do you have both environments so you can compare the report data definition in 400 vs 700?

I do have access to the SQL server, but I’m not sure where the log is located.

FWIW - it’s odd that the query expression doesn’t refer to a GUID parameter.

This was the post I was aware of speaking to similar issues. In my case, I was able to upload the reports from local files and that fixed the issue. [image] Report issues with upgrade from 10.1.500 to 10.2.700 ERP 10 Hello, we are in the process of upgrading form 10.1.500…

This was helpful and also caught my eye, but your post caused me to ask why… ended up being a customization that Epicor put into our system years ago (a view created on the reports db) and I didn’t copy that view to the new db.

Troubleshoot SSRS "Query execution failed for dataset 'CashTransaction'

Epicor ERP 10

jkane (John Kane) April 14, 2021, 3:46pm 5

probably C:Program Files/Microsoft SQL Server/MSRS11.MSSQLSERVER/Reporting Services/Log Files

ARForm suddenly stops in SSRS, other reports run

Topic		Replies	Views
ARForm report broken after upgrade from 10.1.600 to 10.2.400 Epicor ERP 10 e10	28	2492	July 21, 2021
Run custom ARForm Error - Query execution failed Epicor ERP 10 e10	14	1536	October 20, 2021
Upgrading from 10.1.400.0 to 10.1.600.0 - Custom Reports Fail due to data sets being invalid Epicor ERP 10	11	1184	December 11, 2017
Dataset error on copied form Epicor ERP 10 ssrs	3	412	February 27, 2020
SSRS Form Execution Error Epicor ERP 10	2	1199	March 8, 2018

Troubleshoot SSRS "Query execution failed for dataset 'CashTransaction'

Related topics