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 NOVEMBER 05, 2016

Applies to:

Oracle Weblogic Server - Version: 10.3 and later   [Release: 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 ='-5505715342808860969/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 ='-5505715342808860969/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','-5505715342808860969/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','-5505715342808860969/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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms