PQ69994: AFTER UPGRADING WAS (WEBSPHERE APPLICATION SERVER) PTF 4, EAR DEPLOYMENT FAILS WITH DUPLICATEKEYEXCEPTIONS. | |||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||
![]() 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 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 #: PQ69994
IBM Group: Software Group
Modified date: Feb 25, 2003
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.