PQ72780: WAS upgraded from FP3 to FP4 - admin server is not starting; oracle repository throws an error ORA-01401 in WLMBOOTSRVRS_TABL

 Fixes are available

4.0.7: WebSphere Application Server Version 4.0 Fix Pack 7
PQ72780; Admin Server does not start after upgrading Fix Pack 3 to Fix Pack 4



APAR status
Closed as program error.

Error description
WAS upgraded from FP3 to FP4 - admin server is not starting;
oracle repository throws an error ORA-01401 in
WLMBOOTSRVRS_TABLE with IOR iserted value too large for column.

Customer follow each direction of step for new repository
implementation the admin server still did not get started and
it's was still indicating the same error. But they observer the
difference      between FP3 vs. FP4 upgrade is that IOR column
on FP3 was 516 character and when they upgraded to FP4 actual
column was 1024, but IOR character needed it 1044 value into the
column. Customer said after FP4 they increase the size on IOR
column to 2048 resolved the admin server startup issue after
FP4.

 [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 =
Local fix
?
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)

Current customer problem is resolved after upgrading the FP4 and
increasing IOR column to 2048 by manually. This trigger admin
server started successfully.
Problem summary
****************************************************************
* 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"             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
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.
Temporary fix Comments
APAR information
APAR number PQ72780
Reported component name WEBSPHERE AE NT
Reported component ID 5630A2201
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2003-04-02
Closed date 2003-07-09
Last modified date 2003-07-09

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
WLM          

SRLS

Fix information

Applicable component levels
R400 PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ72780
IBM Group: Software Group
Modified date: Jul 9, 2003