APAR status
Closed as program error.
Error description
HTTPSessions table is not created when session table was created
under different user.
WebSphere Application Server might not create the session table
under the following conditions.
1) HTTPSessions is configured to persist data to a database.
2) The database contains a session table created under a user
other than the user configured to access the session table.
3) The HTTPSessions and datasources are configured correctly.
If the session data is configured to be persisted in a database
but the table was not created you might receive SystemOut.log
messages such as the following:
SessionContex E SESN0016E: DatabaseSessionContext:
performInvalidation detected an error. The database invalidation
of timed out sessions has encountered an error.If a SQLException
has occurred then refer to the appropriate database
documentation for your environment. Also, ensure that you have
properly configured a datasource for Session Manager.
.
SessionContex E Exception is: COM.ibm.db2.jdbc.DB2Exception:
[IBM][CLI Driver][DB2/NT] SQL0204N "RUMLEY.SESSIONS" is an
undefined name. SQLSTATE=42704
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException
(SQLExceptionGenerator.java:267)
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException
(SQLExceptionGenerator.java(Inlined Compiled Code))
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code
(SQLExceptionGenerator.java(Compiled Code))
COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2
(DB2PreparedStatement.java:2119)
COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery
(DB2PreparedStatement.java:1605)
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery
(WSJdbcPreparedStatement.java:508)
com.ibm.ws.webcontainer.httpsession.BackedHashtable.
performInvalidation(BackedHashtable.java:3006)
com.ibm.ws.webcontainer.httpsession.DatabaseSessionContext.
performInvalidation(DatabaseSessionContext.java:376)
com.ibm.ws.webcontainer.httpsession.SessionContext.
pollInvalidations(SessionContext.java:852)
com.ibm.ws.webcontainer.httpsession.SessionAlarmListener.alarm
(SessionAlarmListener.java(Compiled Code))
com.ibm.ejs.util.am._Alarm.run(_Alarm.java(Compiled Code))
com.ibm.ws.util.ThreadPool$Worker.run
(ThreadPool.java(Compiled Code))
If the above condition exist you will also observe that the
Application Server does not issue SQL to create a session table.
This can be observed by turning on a CLI/JDBC trace if using
DB2.
Local fix
To workaround this problem drop the session's database tables
named "sessions".
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server session users *
****************************************************************
* PROBLEM DESCRIPTION: Session data can not be stored into the *
* database. In the session trace, it *
* showed that no session tables were *
* created. Moreover, all database *
* insertion failed. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
When session manager got initialized when app server started
up, it only checked to see if a session table existed. The
right way to do it was to see if a session table existed under
the database that the user connected to it.
Problem conclusion
The code is fixed so that session tables can be created under
the right schema (database user).
Temporary fix
Fix sent to L2.
Comments
APAR information |
APAR number |
PQ81615 |
Reported component name |
WAS NETWRK DEPL |
Reported component ID |
5630A3601 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2003-12-02 |
Closed date |
2004-05-14 |
Last modified date |
2004-05-14 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R103 PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|