Skip to Content
Technical Articles

Configuring the BI BW Relational Connection for Optimal Performance

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:

  1. Connection Errors
  2. Semi-join Errors
  3. 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

For the connection the first step is to check if the configuration is correct with a guided answer

Configuring the BI BW Relational Connection for Optimal Performance

Also, it can be accessed through the knowledge base article:

2697474 Configuring the BI BW Relational Connection for Optimal Performance

Be the first to leave a comment
You must be Logged on to comment or reply to a post.