Hi
I am using SSRS 2012 and have set up multiple reports. One report appears to have originally used a shared dataset that was using a datasource on a different machine (development pc). This became apparent when the developement machine was decommisioned and the report threw an error.
Interestingly, after pointing the report to the new location of the shared dataset, the report runs fine. However, when the report is run via a subscription (email or file share delivery) it fails. The log shows a ServerConfigurationErrorException and the SSRS log points back to the shared dataset. Renaming or deleting/recreating the shared dataset has no effect. Also restarting SSRS has no effect. It seems the old dataset with an incorrect datasource is being cached somewhere.
Here is the stack trace from the SSRS log file:
library!WindowsService_0!1b24!02/19/2014-18:07:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 110, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
processing!WindowsService_0!1b24!02/19/2014-18:07:00:: e ERROR: An exception has occurred in data set 'MySharedDataset'. Details: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
processing!WindowsService_0!1b24!02/19/2014-18:07:00:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!WindowsService_0!1b24!02/19/2014-18:07:00:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
--- End of inner exception stack trace ---;
processing!WindowsService_0!1b24!02/19/2014-18:07:00:: w WARN: Data source ' Data source for shared dataset': Report processing has been aborted.
processing!WindowsService_0!1b24!02/19/2014-18:07:00:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
--- End of inner exception stack trace ---;
library!WindowsService_0!1b24!02/19/2014-18:07:00:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
notification!WindowsService_0!1b24!02/19/2014-18:07:00:: e ERROR: Error occurred processing subscription 41f9811b-0fb2-4717-b4b3-c7bb6f1eaecc: An error has occurred during report processing.
So far the only solution that seems to work has been to embed the offending datasets in the report. Does anyone have any ideas on how to fix this? Perhaps there's a way to flush SSRS and remove redundant shared datasets?
Thanks in advance,
Blair
- Edited by BSDZ 24 minutes ago