2106882 - Receive error message "The repository session cannot be closed because it is still in use" When attempting to close a session in IDT

SAP Knowledge Base Article - Public

2106882 - Receive error message "The repository session cannot be closed because it is still in use" When attempting to close a session in IDT

Symptom

  • Issue was reproduced with both an SSO connection to BICS and a predefined connection
  • Issue seems to only occur for the 1st session created in IDT, subsequent connections can be released by following the steps in the resolution or patching

Environment

  • Issue was reproduced on SAP BusinessObjects Business Intelligence Platform 4.1 Support Pack 4 Patch 3 Information Design Tool
  • Issue could not be reproduced on BI 4.1 SP4 Patch 2 or BI 4.1 SP5 

Reproducing the Issue

The suspected bug can be reproduced by the following

  1. restart the SIA or verify that no existing BW session exist from IDT in the CMC > sessions 
  2. Open IDT and login with SAP (creating the 1st session that can be verified as above)
  3. Create an OLAP connection with SAP BICS client to BW
  4. Select use Single sign on or use predefined for the connection (entering SAP user and password)
  5. Test the connection (creates a connection window in IDT)
  6. Attempts at closing the session, even after closing the connection window will not prevent the error "The repository session cannot be closed because it is still in use"

Cause

There seems to be a bug in BI 4.1 SP4 patch 3, but a minor one that also seems to have been fixed in SP5. More details may be released as they are found. The bug causes the 1st session to hang in IDT and it cannot be closed. Subsequent sessions can be closed. 

Resolution

If using BI 4.1 SP4  patch 3, the work around is to close IDT, subsequesn sessions should follow the solutions below

All other patches of BI 4.1 perform the following

  1. close your connection window in IDT after testing
  2. If the connection window is not open then double click on the connection to open it, and close it
  3. Once the connection window is closed you should be able to close your connection (which will end your session in the CMC)

Since the issue only seemed to affect on patch of BI (4.1 SP4 patch 3) and only affected 1 session it has not been rasied for a fix. If it should prove there are further complications or with any business case this issue may be reopened. 

Keywords

zie  , KBA , BI-BIP-SL , Semantic Layer , Problem

Product

SAP BusinessObjects Dashboards 4.0