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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.