My Oracle Support Banner

Error ORA-00001 after Configuring Migratable Persistent Stores, ' unique constraint (TST1_SOAINFRA.BPM_MEASUREMENT_ACTIONS_U1) violated' (Doc ID 1407715.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Business Process Management Suite - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms


After configuring a migratable persistent store in the WebLogic Console (http://docs.oracle.com/cd/E23943_01/web.1111/e13709/service_migration.htm#CLUST286) you may see the following error:

<Jan 26, 2012 3:36:12 PM CST> <Error> <JMX> <BEA-149500> <An exception occurred while registering the MBean null.
java.lang.IllegalArgumentException: Registered more than one instance with the same objectName : com.bea:ServerRuntime=soa_server1,Name=PeopleQueryMDB_BPMJMSModule!BPMJMSServer_auto_2@dist_PeopleQueryTopic_auto,ApplicationRuntime=soa-infra,Type=MessageDrivenEJBRuntime,EJBComponentRuntime=oracle.bpm.bpm-services.ejb.jar new:weblogic.ejb.container.monitoring.MessageDrivenEJBRuntimeMBeanImpl@170a29e3 existing weblogic.ejb.container.monitoring.MessageDrivenEJBRuntimeMBeanImpl@695615b8
at weblogic.management.jmx.ObjectNameManagerBase.registerObject(ObjectNameManagerBase.java:168)
at weblogic.management.mbeanservers.internal.WLSObjectNameManager.lookupObjectName(WLSObjectNameManager.java:131)
at weblogic.management.jmx.modelmbean.WLSModelMBeanFactory.registerWLSModelMBean(WLSModelMBeanFactory.java:87)
at weblogic.management.mbeanservers.internal.RuntimeMBeanAgent$1.registered(RuntimeMBeanAgent.java:104)
at weblogic.management.provider.core.RegistrationManagerBase.invokeRegistrationHandlers(RegistrationManagerBase.java:180)
Truncated. see log file for complete stacktrace
>




You may also see:


Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (TST1_SOAINFRA.BPM_MEASUREMENT_ACTIONS_U1) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1079)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3887)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1508)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:788)
... 74 more

Changes

Recently configured migratable persistent stores for your JMS servers.

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
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.