SAP Knowledge Base Article - Public

1604714 - Cannot Access External Data message in an Xcelsius Dashboard

Symptom

  • Receive the following error in an Xcelsius Dashboard:  Cannot Access External Data Connection failed. 
  • The server has reached the maximum number of simultaneous connections. (Error: RWO 00239)

Note: At the bottom of popup shows a number such as 1/7 and an OK button

JohnsError.PNG

Environment

  • Xcelsius 2008
  • QAAWS - XI3.1 SP3

Reproducing the Issue

Refresh an Xcelsius object that is based on a QAAWS datasource - whether that be manually or on an automated schedule.

Cause

The Web Intelligence Report server has run out of connections.  The message is indicating that there are no available WebIntelligence Report Servers to process the request.

Resolution

In the CMC, under the WebIntelligence properties, you can set a property - maximum connections.  This in effect controls how many jobs a WebIntelligence server will take on.  You can check how many are being used in the metrics section of the WebIntelligence Report Server. 

  1. One option is to increase maximum connections number to allow additional connections which will allow the objects to run as long as there are some connections available. 
  2. Another option is to add additional WebIntelligence Report Server.

WARNING: This change must be done with care as a WebIntelligence report server has a finite amount of memory and processor resources so in many cases it may be required to add another WebIntelligence report server altogether (whether that be on the same machine if there are still resources available there or perhaps another host).

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008