Constraint errors on BPM_MEASUREMENT_ACTIONS table and BPM cluster and coherence configuration (Doc ID 1343964.1)

Last updated on AUGUST 01, 2017

Applies to:

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

Symptoms


In a BPM Cluster configuration, the following error is seen in the SOA server logs:

Exception occurred during commit of transaction Name=[EJB oracle.bpm.analytics.action.persistence.impl.ActionPersistenceServiceBean.createMeasurementAction(java.lang.String,java.lang.Long,java.sql.
 Timestamp,java.lang.String,java.lang.String,java.sql.Timestamp)],Xid=BEA1-1F299F3FE4BC61CA16D5(213000414),Status=Rolled back.
[Reason=Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TST1_SOAINFRA.BPM_MEASUREMENT_ACTIONS_U1) violated

Error Code: 1
Call: INSERT INTO BPM_MEASUREMENT_ACTIONS (ACTION_INVOCATION_ID, COMPONENT_INSTANCE_ID, COMPOSITE_INSTANCE_ID, CI_PARTITION_DATE, AUDIT_QUERY_TIME,
ACTION_NAME, QUERY_ID) VALUES (?, ?, ?, ?, ?, ?, ?)

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TST1_SOAINFRA.BPM_MEASUREMENT_ACTIONS_U1) violated

Error Code: 1
Call: INSERT INTO BPM_MEASUREMENT_ACTIONS (ACTION_INVOCATION_ID, COMPONENT_INSTANCE_ID, COMPOSITE_INSTANCE_ID, CI_PARTITION_DATE, AUDIT_QUERY_TIME,
ACTION_NAME, QUERY_ID) VALUES (?, ?, ?, ?, ?, ?, ?)
bind => [1961, 360050, 250171, 2011-06-06 11:50:04.145, 2011-06-06 11:50:05.735, CubeCommand, 879000]
Query: InsertObjectQuery(oracle.bpm.analytics.action.persistence.model.BpmMeasurementActions@2f08c94e)
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1881)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:345)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:239)
at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:625)
at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:49)
at weblogic.ejb.container.internal.BaseRemoteObject.__WL_postInvokeTxRetry(BaseRemoteObject.java:444)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:53)
at oracle.bpm.analytics.action.persistence.impl.ActionPersistenceServiceBean_rdl0eg_ActionPersistenceServiceImpl.createMeasurementAction(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
at $Proxy158.createMeasurementAction(Unknown Source)
at oracle.bpm.analytics.action.persistence.ActionUtil.markProcessing(ActionUtil.java:62)
at oracle.bpm.analytics.action.AbstractActionInvoker.processAuditInstance(AbstractActionInvoker.java:194)
at oracle.bpm.analytics.action.AbstractActionInvoker.processMessage(AbstractActionInvoker.java:127)
at oracle.bpm.analytics.cube.action.CubeActionMDB.onMessage(CubeActionMDB.java:53)
at sun.reflect.GeneratedMethodAccessor1533.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy402.onMessage(Unknown Source)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:519)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:424)
at weblogic.ejb.container.internal.JMSMessagePoller.processOneMessage(JMSMessagePoller.java:273)
at weblogic.ejb.container.internal.JMSMessagePoller.pollContinuously(JMSMessagePoller.java:334)
at weblogic.ejb.container.internal.JMSMessagePoller.pollForParent(JMSMessagePoller.java:460)
at weblogic.ejb.container.internal.JMSMessagePoller.run(JMSMessagePoller.java:476)
at java.lang.Thread.run(Thread.java:619)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint
  (TST1_SOAINFRA.BPM_MEASUREMENT_ACTIONS_U1) violated

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