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.
 
URL LANGUAGE SIZE(Bytes)
Readme US English 3245
 
Download package
What is DD?
Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
PQ72780 6/27/2003 US English 1073699 FTP DD
 
Technical support
1-800-IBM-SERV (U.S. calls only)
 
Problems (APARS) fixed
PQ72780
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Administrative Console (all non-scripting)
Operating system(s): HP-UX
Software version: 4.0.4
Software edition:
Reference #: 4005093
IBM Group: Software Group
Modified date: Dec 13, 2005