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,848 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

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: SSRS Deployment Run Issue

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.
Mike Smith 6,840 on at

Like (0)

Report

Re: SSRS Deployment Run Issue

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?

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans