My Oracle Support Banner

Managed Server Fails to Start after Migration: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint violated on JMS_STORE_OBJ (Doc ID 1317809.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

Oracle WebLogic Server - Version 10.3 and later
Information in this document applies to any platform.

Symptoms

After whole server migration, the migrated managed server fails to start. The managed server log shows:

<Apr 18, 2011 9:12:36 PM EDT> <Debug> <ServerMigration> <BEA-000000> <Query: UPDATE ACTIVE SET TIMEOUT = ( (SYSDATE + (30/86400))) WHERE SERVER IN ('wlsserver.javaMessagingServer2') AND INSTANCE ='xxxxx/javaMessagingServer2' AND DOMAINNAME='javaMessaging' AND CLUSTERNAME='javaMessagingCluster'>
<Apr 18, 2011 9:12:36 PM EDT> <Debug> <ServerMigration> <BEA-000000> <Query: UPDATE ACTIVE SET TIMEOUT = ( (SYSDATE + (30/86400))) WHERE SERVER IN ('wlsserver.javaMessagingServer2') AND INSTANCE ='xxxxx/javaMessagingServer2' AND DOMAINNAME='javaMessaging' AND CLUSTERNAME='javaMessagingCluster'>
<Apr 18, 2011 9:12:46 PM EDT> <Debug> <ServerMigration> <BEA-000000> <<Apr 18, 2011 9:12:46 PM EDT> <Debug> <ServerMigration> <BEA-000000> <Query: DELETE FROM ACTIVE WHERE (SYSDATE > TIMEOUT) AND SERVER = 'service.SINGLETON_MASTER' AND DOMAINNAME='javaMessaging' AND CLUSTERNAME='javaMessagingCluster'>
<Apr 18, 2011 9:12:46 PM EDT> <Debug> <ServerMigration> <BEA-000000> <Query: INSERT INTO ACTIVE VALUES ('service.SINGLETON_MASTER','xxxxx/javaMessagingServer2','javaMessaging','javaMessagingCluster', (SYSDATE + (30/86400)))>
<Apr 18, 2011 9:12:46 PM EDT> <Debug> <ServerMigration> <BEA-000000> <Attempted Query: INSERT INTO ACTIVE VALUES ('service.SINGLETON_MASTER','xxxxx/javaMessagingServer2','javaMessaging','javaMessagingCluster', (SYSDATE + (30/86400)))>
<Apr 18, 2011 9:12:46 PM EDT> <Debug> <ServerMigration> <BEA-000000> <Unexpected exception
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (JMS_STORE_OBJ.SYS_C00325154) violated

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.