Symptom
- Timing out of Infoview WebI reports using SAP datasource
- Bottleneck between BObj and BW systems
- 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
- Modify OLAP Universe : Parameters > Definition > Connection > Configuration Parameters > Connection Pool Mode > "Keep connection active for" > Pool Timeout = (increase above) 10 minutes.
- Modify OLAP Universe : Parameters > Controls > Query Limits > Limit Size of Execution time to > (increase above) 10 minutes.
- Save & Export Universe.
- 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