1438297 - WebI on SAP reports timeout, without completing, after 10 minutes.

SAP Knowledge Base Article - Public

1438297 - WebI on SAP reports timeout, without completing, after 10 minutes.

Symptom

  1. Timing out of Infoview WebI reports using SAP datasource
  2. Bottleneck between BObj and BW systems
  3. MDA.log Trace entries: << APIMODULE: ConnectionImpl: ConnectionImpl::close >> & << SAPMODULE: SAPConnection: SAPConnection::disconnect >> show that BW connection is closed after exactly 10 minutes, without allowing completion of the Fetch phase.

Environment

  • BusinessObjects Enterprise XI 3.1 SP2
  • Integration Kit for SAP Solutions XI 3.1 SP2
  • SAP BW BI 7.0.x DataWarehouse

Reproducing the Issue

  1. Modify OLAP Universe : Parameters > Definition > Connection > Configuration Parameters > Connection Pool Mode > "Keep connection active for" > Pool Timeout = (increase above) 10 minutes.
  2. Modify OLAP Universe : Parameters > Controls > Query Limits > Limit Size of Execution time to > (increase above) 10 minutes.
  3. Save & Export Universe.
  4. Test query parameters in a new Webi instance.

Cause

  • From MDA.log, Call wait time to /nSE37 Function 'BAPI_MDPROVIDER_GET_DIMENSIONS' is slow, & takes 40 seconds.
  • Parameter in the BW is prematurely closing the connection

Resolution

  • Increase the BW BASIS parameter : rdisp/max_wprun_time in TA: /nRZ11

Keywords

KBA , BI-RA-WBI , Web Intelligence , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008