PQ72780; Admin Server does not start after upgrading
Fix Pack 3 to Fix Pack 4
Downloadable files
Abstract
WebSphere Application Server upgraded from Fix Pack 3 to
Fix Pack 4 - admin server is not starting Oracle repository throws an
error ORA-01401
Download Description
USERS AFFECTED:
WebSphere Application Server users in a multi-server/server group
environment.
PROBLEM DESCRIPTION:
The admin server is not starting because of a error simular to
"WLMBOOTSRVRS_TABLE with IOR inserted value too large for column"
There is a defect in the com.ibm.ws.wlm.bootstrap.WLMBootstrapImpl code.
When creating the WLMBOOTSRVRS_TABLE the code is using "BigString" for the
IOR column. However, later when updating the same table, the code uses
"HugeString" for the IOR column. Thus, the table gets created with a
smaller column size than potentially required. It looks like this problem
has existed since the initial GA for Advanced Server (4.0.1) but has not
been discovered until now. The problem would only be seen when the IOR
size becomes larger than "BigString".
There may be an exception simular to this in the log file:
[12/12/02 13:20:19:516 EST] 17dc5e67 DBMgr W SMTL0027W: An exception
occurred during database update: update EJSADMIN.WLMBOOTSRVRS_TABLE set
SERVER_INSTANCE = ? , SERVER_STATE = ? , SERVER_ID = ? , IOR = ? where
GROUP_NAME = ? and SERVER_NAME = ? java.sql.SQLException: ORA-01401:
inserted value too large for column .
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
PROBLEM CONCLUSION:
The code was changed to use the same size column for the column creation
as well as the updates.
Prerequisites
None
Installation Instructions
Please review the readme.txt for detailed installation
instructions.