Skip to content Skip to main navigation Skip to footer

SQL Server Replication and SSRS

If you are using SQL Server database replica for reporting, please allow time for the SQL Server database replication to occur. Depending on your environment, this task will generally be completed within 24 hours.

If you are unsure whether or not SQL Server database replica is being used, a general indication of it being in place can be determined if the following conditions are met:

  • The setup log file shows no issues creating the stored procedures.
  • You receive a similar error message to the ones below.
Error Message 1
An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘PC’. (rsErrorExecutingCommand) Could not find stored procedure ‘ES_RBA_PCNameFilter_RV’.  
Error Message 2
An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘Coll’. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors  

Error Message 2 indicates that remote errors have not been enabled in your environment. In this instance, you will need to enable remote errors in order to see the actual reason behind this error message. The steps to enable remote errors can be found within the Enable Remote Errors troubleshooting section.