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

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

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans