PQ69994: AFTER UPGRADING WAS (WEBSPHERE APPLICATION SERVER) PTF 4, EAR DEPLOYMENT FAILS WITH DUPLICATEKEYEXCEPTIONS.

 Fixes are available

4.0.6: WebSphere Application Server Version 4.0 Fix Pack 6
System Management Component Cumulative Fix for 4.0.2/4.0.3/4.0.4 /4.0.5



APAR status
Closed as program error.

Error description
Installing EAR file via GUI deployment caught duplicate key
exception.
.
Exception:
com.ibm.websphere.csi.CSITransactionRolledbackException: null;
nested
exception is: com.ibm.ejs.cm.portability.DuplicateKeyException:
[IBM][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY
constraint 'PK__OBJECT_TABLE__47DBAE45'. Cannot insert
duplicate key in object 'OBJECT_TABLE'.
Local fix
Developer provided a test fix PMR01052a.jar, which should be
placed in the $WAS_ROOT/classes directory. It contains a single
class, com.ibm.ejs.sm.beans.RepositoryObjectImpl.class, which is
built for from the 4.0.4 code base.
Problem summary
****************************************************************
* USERS AFFECTED: For WebSphere Application Server 4.0 users   *
****************************************************************
* PROBLEM DESCRIPTION: Installing EAR file via GUI             *
*                      deployment caught duplicate key         *
*                      exception.                              *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Caught duplicate key exception when installing an ear file via
admin GUI:

com.ibm.websphere.csi.CSITransactionRolledbackException:
null:nested
exception is: com.ibm.ejs.cm.portability.DuplicateKeyException:
IBM SQLServer JDBC Driver SQLServer violation of primary key
constraint "PK_OBJECT_TABLE_47DBAE45' Cannot insert duplicate
key in object "OBJECT_TABLE'
Problem conclusion
The function "initializeInstanceId" on
RepositoryObjectImpl.java was not correctly implemented to
catch the DuplicateKeyException.  The value
duplicateKeySQLState should not be used in the
initializeInstanceId function. The proper way is to catch
DuplicateKeyException instead of checking SQLState.
Temporary fix Comments
APAR information
APAR number PQ69994
Reported component name WEBSPHERE AE NT
Reported component ID 5630A2201
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2003-01-17
Closed date 2003-02-25
Last modified date 2003-02-25

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
ADMINSVR          

SRLS

Fix information
Fixed component name WEBSPHERE AE NT
Fixed component ID 5630A2201

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 #: PQ69994
IBM Group: Software Group
Modified date: Feb 25, 2003