Dynamics Community Forum Thread Details

rsErrorExecutingCommand

Receive the following error when attempting to run the Received Not Invoiced SSRS Report: "an error has occurred during report processing (rsProcessingAborted). Query execution failed for dataset 'dsGP10'. (rsErrorExcecutingCommand). Customer has upgraded to 2010.

Michael, thanks for using the forums! Do you know if the customer re-deployed their reports, on GP 2010. That's a necessary step, after upgrading the databases via Dynamics Utilities.

Either way, you can troubleshoot this more by looking in the "LogFiles" folder on the SSRS server It's probably under Program Files\Microsoft SQL Server\MSRS(something)\Reporting Services\LogFIles.

If you run the report, and then look at the end of the most recent log file, it should show you more details about the error. Is it possible the user doesn't have permission to the database? Do other reports work?

If you're still having problems, please specify what build of GP 2010 and which version of SQL/SSRS you have, so I can better assist you.

Thanks!

Grant Swenson [MSFT]

This posting is provided "AS IS" with no warranties, and confers no rights.

Quick Links

Leaderboard