web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SSRS Deployment Run Issue

Microsoft Dynamics GP (Archived)

SSRS Deployment Run Issue

(0) Share

Report

Report

Posted on by Richard Wheeler

75,850 Moderator

Whenever a non -admin user tries to run any of the GP SSRS deployed reports, they receive this error message. Where can I go to find a log telling me what the real issue is?
An error has occurred during report processing. (rsProcessingAborted)
- Query execution failed for dataset 'RMTransactions'. (rsErrorExecutingCommand)
  - For more information about this error navigate to the report server on the
  - local server machine, or enable remote errors

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Mike Smith 6,840 on at

Like (0)

Report

Try: C:\Program Files\Microsoft SQL Server\MSRS10_50...\Reporting Services\LogFiles.

I'm guessing this is likely a security related issue. How is your SSRS security currently deployed?

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

I turned on Enable Remote Errors and discovered it was a permissions error on the stored procedures used to create the reports. Running GRANT.SQL took care of this issue. Thanks for the tip.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans