Intermitent TFS project reporting services error: Cannot create a connection to data source 'TfsOlapReportDS'

Question

Reporting Services occasionally stops responding with the error below.  Although we can resolve the issue by restarting our DB server, this is happening often enough that I would like to resolve the issue.  The error is:

• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
• Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection) Get Online Help
• For more information about this error navigate to the report server on the local server machine, or enable remote errors

It appears the issue is with the DB itself.  I have confirmed the DB is running, and the other TFS DB on the Database server respond normally.  I have viewed the reports on application server (http://<TfsServer>/reports).  Although the reports are listed, the same message appears when the report is displayed.  The DataSources are listed and are set up correctly.  I don't see any relevant exceptions in event viewer.  We have tried resolving the issue by restarting the related services on the on the box without success.  This may work if the services are restarted in the right order, but so far this has not worked.  

BTW, this is a different instance of Sql Server (dbServerName/EtlStaging).  

Any suggestions?  Thanks in advance. 

Answer 1

Bump.  This is happening again, any advice?  Anyone?  Thanks

Answer 2

• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
  • Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection) Get Online Help
    • For more information about this error navigate to the report server on the local server machine, or enable remote errors

 

Is it possible for you to run the same report from the TFS App Tier machine and post the error you get?  We can get additional information (replacing the bold line above) if you are on the local server when you view the report.  This is usually the real error message.

- Steve

---

Development Process Consultant - Notion Solutions - http://sstjean.blogspot.com

Answer 3

Sorry, it has been a while since I last posted: this issue is intermitent. 

Steve StJean, thanks.  On the App Tier, I am getting the following:

• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
  • Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection) Get Online Help
    • The 'ETLStaging' instance was not found on the 'DataTierServer' server.

the 'ETLStaging' is an instance on the DataTierServer.  There are two instances on this server: the default and the 'ETLStaging' instance.

---