Configuring the BI BW Relational Connection for Optimal Performance

Follow RSS feed Like

0 Likes 713 Views 0 Comments

Setting up the relational connection from SAP BusinessObjects BI (BI) to the AP Netweaver Business Warehouse (BW) is a complex configuration. Many errors are encountered, from the initial error attempting a connection from the Information Design Tool to performance or timeout errors in Web Intelligence. This connection method is not recommended. You can read about this Here.

To assist in a remedy of these issues I have created a step through guidance to check if your configuration was accurately created and configured on both the BI platform and the BW backend.

I will be adding additional troubleshooting links to this page for the most seen issues for connectivity.

I issues fall into three groups:

Connection Errors
Semi-join Errors
Query Errors

Some issues that have been encountered for Connection Errors:

Gateway Refused
Host Not found
Error Registration of top <program ID> not allowed.
JCO_ERROR_ILLEGAL_STATE: Current server state dead.
Could not retrieve InfoProvider tables from data source. An error occurred while trying to ping the server
The SAP BW server reported an RFC error: Error during RFC callback:Function RSDRI_DF_RECEIVER not found.
Webi Report on BW UNX has poor performance.
Webi Report on BW UNX Error.
An error occurred while trying to ping the server: SAP NetWeaver BW has reported an RFC error: Error during RFC callback: Error when opening an RFC connection (CPIC-CALL: ‘ ThSAPOCMINIT’ : cmRc=2 thRc=67.
Error registration of DF_JCO_Servername from host ??? not Allowed.
Error com.sap.connectivity.cs.java.drivers.DBDError: [Data Federator Driver] [Server] [Connector ‘testSourceConnection1234567890’] Timeout expired while testing the connection. Please check the configuration parameters.
AdaptiveProcessingServer crashes or Restarts from Multisource BW Reports