PQ72780: WAS upgraded from FP3 to FP4 - admin server is not starting; oracle repository throws an error ORA-01401 in WLMBOOTSRVRS_TABL | |||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||
![]() 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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
SRLS
|
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
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.