Error The following system error occurred: No connection could be made because the target machine actively refused it.

Hosted clients are unable to access OLAP reports due to a connection error. This is usualy followed by a prompt for server connection details or further connection errors.
The OLAP Reports and OLAP Explorer run off the Data Warehouse OLAP cube. Customers using Blackbaud Hosting cannot make connections to the cube nor any other databases in the Hosted environment. Based on the technologies connection methods explored at the time of development; Security will not allow the required direct connections through the firewall to hosted databases. See this Help Guide reference: https://www.blackbaud.com/files/support/howto/coveo/crm/DATAHTTPDataSourceURL.html.
 
Further exploration to use this feature for hosting was stopped and more secure methods were developed. This is what led to the development of the oData Data Warehouse feature released in Blackbaud CRM Version 4.0 Service Pack 13.
 
As of Blackbaud CRM Version 4.0 Service Pack 13, there’s an Odata Web API feature in place with the specific purpose of allowing Blackbaud Hosted customers to report off of the BBDW database using the third-party reporting tool of their choice (Excel, Power BI, Tableau, etc.).
 
You can read about Service Pack 13 New Features here: https://www.blackbaud.com/files/support/guides/enterprise/400/bbcrm40.pdf
There is a section on each Service Pack, which you can find in the chapters list.
 
You can find more information pertaining to the Odata Web API feature here: http://enterprise.docs.blackbaudhosting.com/teams/data-warehouse/OData/
 

Steps to Duplicate

  1. Go to analysis > OLAP excel reports
  2. Select any excel report and select create workbook
  3. In excel select enable editing then enable content on the yellow warning bar
  4. Error The following system error occurred: No connection could be made because the target machine actively refused it.

Environment

 Blackbaud CRM
 4.0

Was this article helpful?