IBM Support

PH17942: SOME SESSION ATTRIBUTES ARE NOT STORED WITH SESSIONDB OF ORACLE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Some session attributes are not written to the session database
    of Oracle.
    In v8.5.5, two threads were using the same session ID almost
    simultaneously, and ORA-00001 error occurred.
    
    ```
    [19/08/30 12:36:25:084 JST] 000000f9 WSJdbcStateme 3   Check for
    Connection Error
    
    SQL STATE:  23000
    ERROR CODE: 1
    java.sql.BatchUpdateException: ORA-00001:
    ????(APUSR_SN13_SB41.SESS_INDEX)                            €€€€
    
     at
    oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePr
    eparedStatement.java:10345)
     at
    oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleSta
    tementWrapper.java:230)
     at
    com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteBatc
    h(WSJdbcPreparedStatement.java:1145)
     at
    com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcSta
    tement.java:855)
     at
    com.ibm.ws.session.store.db.DatabaseHashMapMR.handlePropertyHits
    (DatabaseHashMapMR.java:495)
     at
    com.ibm.ws.session.store.db.DatabaseHashMap.persistSession(Datab
    aseHashMap.java:2146)
     at
    com.ibm.ws.session.store.common.BackedHashMap.updateSession(Back
    edHashMap.java:552)
     at
    com.ibm.ws.session.store.common.BackedHashMap.put(BackedHashMap.
    java:626)
     at
    com.ibm.ws.session.store.common.BackedSession.flush(BackedSessio
    n.java:239)
     at
    com.ibm.ws.session.store.common.BackedSession.flush(BackedSessio
    n.java:224)
     at
    com.ibm.ws.session.EOSSessionStorer.storeSession(EOSSessionStore
    r.java:50)
    ```
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server using multi-row configuration        *
    *                  for database session persistence            *
    ****************************************************************
    * PROBLEM DESCRIPTION: The session manager may fail to use     *
    *                      Oracle database for session             *
    *                      persistence with multi-row              *
    *                      configuration.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When using a multi-row configuration on Oracle Database,
    the session manager may not store all the affected attributes.
    This is because Oracle jdbc driver returns
    SUCCESS_NO_INFO which is different from the other JDBC drivers.
    

Problem conclusion

  • Changes were made to the session manager code to use JDBC
    executeUpdate() method instead of executeBatch() method for
    the behavior of the Oracle JDBC driver.
    The fix for this APAR is currently targeted for inclusion in
    fix pack 8.5.5.17 and 9.0.5.3.  Please refer to the Recommended
    Updates
    page for delivery information:
    http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH17942

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-11

  • Closed date

    2019-12-12

  • Last modified date

    2019-12-12

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R850 PSY

       UP

  • R900 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
17 October 2021