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

19.0.0.8: WebSphere Application Server Liberty 19.0.0.8
19.0.0.9: WebSphere Application Server Liberty 19.0.0.9
19.0.0.10: WebSphere Application Server Liberty 19.0.0.10
19.0.0.11: WebSphere Application Server Liberty 19.0.0.11
19.0.0.12: WebSphere Application Server Liberty 19.0.0.12
20.0.0.1: WebSphere Application Server Liberty 20.0.0.1
20.0.0.2: WebSphere Application Server Liberty 20.0.0.2
20.0.0.3: WebSphere Application Server Liberty 20.0.0.3
20.0.0.4: WebSphere Application Server Liberty 20.0.0.4
20.0.0.5: WebSphere Application Server Liberty 20.0.0.5

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 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