IBM Support

PH13932: "USING COLLECTION QEJBASSN FOR SESSION PERSISTANCE." IS ALWAYS OUTPUT WITH STARTUP OF LIBERTY SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If using the DB2 for i as session db, the following error
    always
    occurs with server startup.
    <message.log>
    ----
    [19/06/11 8:58:38:410 JST] 00000038
    com.ibm.ws.session.WASSession
    W
    ?????: was.install.library not set.  Using collection
    
    QEJBASSN for session persistance.
    ...
    [19/06/11 8:58:39:011 JST] 00000038
    com.ibm.ws.session.WASSession
    E
    ??:
    
    com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException:
    [SQL0601]
    QEJBASSN????*FILE?SEDIWASSES??????????
    bZa&#226;
    at
    com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDEr
    ror.
    java:891)
    at
    com.ibm.as400.access.JDError.throwSQLException(JDError.java:
    692)
    at
    com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400J
    DBCS
    tatement.java:1640)
    at
    com.ibm.as400.access.AS400JDBCStatement.executeUpdate(AS400J
    DBCS
    tatement.java:2523)
    at
    com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJd
    bcSt
    atement.java:608)
    at
    com.ibm.ws.session.store.db.DatabaseHashMap.createTable(Data
    base
    HashMap.java:567)
    at
    com.ibm.ws.session.store.db.DatabaseHashMap.initDBSettings(D
    atab
    aseHashMap.java:427)
    at
    com.ibm.ws.session.store.db.DatabaseHashMap.<init>(DatabaseH
    ashM
    ap.java:243)
    at
    com.ibm.ws.session.store.db.DatabaseStore.<init>(DatabaseSto
    re.j
    ava:55)
    at
    com.ibm.ws.session.store.db.DatabaseStore.<init>(DatabaseSto
    re.j
    ava:60)
    at
    com.ibm.ws.session.store.db.DatabaseStoreService.createStore
    (Dat
    abaseStoreService.java:100)
    at
    com.ibm.ws.session.SessionContext.createStore(SessionContext
    .jav
    a:337)
    at
    com.ibm.ws.session.SessionContext.createCoreSessionManager(S
    essi
    onContext.java:254)
    at
    com.ibm.ws.session.SessionContext.<init>(SessionContext.java
    :157
    )
    ----
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server Using DB2 for iSeries                *
    ****************************************************************
    * PROBLEM DESCRIPTION: Support is needed for custom schema and *
    *                      table names in DB2 for iSeries/AS400    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When using a custom schema in DB2 for iSeries, the server
    startup may give an error:
    "was.install.library not set. Using collection QEJBASSN for
    session persistance."
    and throw:
    com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException
    Custom schema and table names are not supported in DB2 for
    iSeries/AS400 because the schema (collection) and table name are
    always default to QEJBASSN and SESSIONS.
    

Problem conclusion

  • The code was updated to recognize the schema (collection) name
    and table names from user input based on the format of
    "schema_name.table_name".
    
    The fix for this APAR is currently targeted for inclusion in fix
    pack 19.0.0.8.  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

    PH13932

  • Reported component name

    LIBERTY PROFILE

  • Reported component ID

    5724J0814

  • Reported release

    855

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-06-30

  • Closed date

    2019-09-04

  • Last modified date

    2019-09-04

  • 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

    LIBERTY PROFILE

  • Fixed component ID

    5724J0814

Applicable component levels

  • R855 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":"855","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
17 October 2021