SSRS Report using Stored Procedure works fine in BIDS but do not run on the Report Server
Thank You both!
Yes, I know that the error message is not much useful :(. And I do not have permissions to make EnableRemoteErrors true on the ReportServer Database.
I think what Olaf helper has suggested must be causing the issue. I would work with the DBA to check the permissions for the Datasource account on the stored procedures and update the results here.Bharkavi
March 11th, 2011 7:18pm
Dear Bharkavi, nothing at all; always a pleasure to help as far as I can.Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich tglich
Blog
Xing
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 9:34pm
Special Thanks To Olaf helper again! Bharkavi
March 11th, 2011 9:59pm
I have created a report in SSRS with four datasets and three of the datasets use stored procedures. I have executed and tested the stored procedures both on DB server and from the SSRS datasets. They work fine as expected. And I used the data to create
the layout and I was able to successfully build and run the Report in BIDS and the report works as expected. When I uploaded the Report on the Report server and established data source connections and tried to view the report I am able to do the parameter
selections but when I click on the View Report button, I get the following message. My ID has content Manager permissions on the Report Server and also I am an administrator on it:
An error has occurred during report processing.
Query execution failed for data set '<datasetname>'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Bharkavi
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 10:01pm
Hello Bharkavi,
The error message isn't any useful. I guess the credential of the datasource don't have the permission to execute the stored procedure; you may check this first.Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich tglich
Blog
Xing
March 11th, 2011 10:17pm
Did you check the three datasets are configured in Report Manager and also check after deployment whether all the datasoources are deployed into Report Manager. I presume that one out four datasets datasource is not deployed if they all different.
Otherwise to get complete error info select * from dbo.ConfigurationInfo in ReportServer database and make true for EnableRemoteErrors.Nanda
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2011 10:41pm