BPMN Component is not created and there is an ORA-00001 error on the CUBE_INSTANCE table in the logs (Doc ID 2239664.1)

Last updated on MARCH 01, 2017

Applies to:

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

Symptoms

BPMN components are not showing up in the audit trail or not being created. In the logs we see the following exception:

#### <pe_soa_server1> <> <> Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PESOAS_SOAINFRA.CI_PK) violated

Error Code: 1
Call: INSERT INTO CUBE_INSTANCE (CIKEY, AG_MILESTONE_PATH, AG_ROOT_ID, AT_COUNT_ID, AT_DETAIL_ID, AT_EVENT_ID, CACHE_VERSION, CMPST_ID, CPST_INST_CREATED_TIME, COMPONENT_NAME, COMPONENTTYPE, COMPOSITE_LABEL, COMPOSITE_NAME, COMPOSITE_REVISION, CONVERSATION_ID, CREATE_CLUSTER_NODE_ID, CREATION_DATE, CREATOR, DOMAIN_NAME, ECID, EXT_INT1, EXT_STRING1, EXT_STRING2, LAST_CLUSTER_NODE_ID, METADATA, MODIFIER, MODIFY_DATE, OUTCOME, PARENT_ID, PARENT_REF_ID, PRIORITY, PROCESS_TYPE, ROOT_ID, SCOPE_CSIZE, SCOPE_REVISION, SCOPE_USIZE, STAGE, STATE, STATUS, TENANT_ID, TEST_CASE, TEST_RUN_ID, TEST_RUN_NAME, TEST_SUITE, TITLE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [45 parameters bound]
Query: InsertObjectQuery(Authorization-EDBCAuthorizationProcess-null-3597846)],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=60,XAServerResourceInfo[SOADataSource_pe_soa_domain6]=(ServerResourceInfo[SOADataSource_pe_soa_domain6]=(state=rolledback,assigned=pe_soa_server1),xar=SOADataSource,re-Registered = false),SCInfo[pe_soa_domain6+pe_soa_server1]=(state=rolledback),properties=({weblogic.transaction.name=[EJB oracle.bpm.bpmn.engine.ejb.impl.BPMNAuditTrailBean.storeCubeInstanceForAudit(com.collaxa.cube.persistence.dto.CubeInstance)]}),local properties=({weblogic.jdbc.jta.SOADataSource=[ No XAConnection is attached to this TxInfo ]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=pe_soa_server1+192.168.0.65:7003+pe_soa_domain6+t3+, XAResources={eis/tibjms/Queue, eis/activemq/Queue, WLStore_pe_soa_domain6__WLS_pe_soa_server1, WSATGatewayRM_pe_soa_server1_pe_soa_domain6, EDNDataSource_pe_soa_domain6, eis/fioranomq/Topic, eis/jbossmq/Queue, eis/Apps/Apps, WLStore_pe_soa_domain6_SOAJMSFileStore_auto_2, eis/webspheremq/Queue, eis/AQ/aqSample, eis/aqjms/Queue, eis/sunmq/Queue, eis/pramati/Queue, WLStore_pe_soa_domain6_AGJMSFileStore_auto_2, eis/tibjmsDirect/Queue, WLStore_pe_soa_domain6_UMSJMSFileStore_auto_2, eis/wls/Queue, eis/tibjmsDirect/Topic, WLStore_pe_soa_domain6_BPMJMSFileStore_auto_2, SOADataSource_pe_soa_domain6, eis/wls/Topic, eis/aqjms/Topic, eis/tibjms/Topic, WLStore_pe_soa_domain6_PS6SOAJMSFileStore_auto_2},NonXAResources={})],CoordinatorURL=pe_soa_server1+192.168.0.65:7003+pe_soa_domain6+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@2f33c73a

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PESOAS_SOAINFRA.CI_PK) violated

Error Code: 1
Call: INSERT INTO CUBE_INSTANCE (CIKEY, AG_MILESTONE_PATH, AG_ROOT_ID, AT_COUNT_ID, AT_DETAIL_ID, AT_EVENT_ID, CACHE_VERSION, CMPST_ID, CPST_INST_CREATED_TIME, COMPONENT_NAME, COMPONENTTYPE, COMPOSITE_LABEL, COMPOSITE_NAME, COMPOSITE_REVISION, CONVERSATION_ID, CREATE_CLUSTER_NODE_ID, CREATION_DATE, CREATOR, DOMAIN_NAME, ECID, EXT_INT1, EXT_STRING1, EXT_STRING2, LAST_CLUSTER_NODE_ID, METADATA, MODIFIER, MODIFY_DATE, OUTCOME, PARENT_ID, PARENT_REF_ID, PRIORITY, PROCESS_TYPE, ROOT_ID, SCOPE_CSIZE, SCOPE_REVISION, SCOPE_USIZE, STAGE, STATE, STATUS, TENANT_ID, TEST_CASE, TEST_RUN_ID, TEST_RUN_NAME, TEST_SUITE, TITLE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [45 parameters bound]
Query: InsertObjectQuery(Authorization-EDBCAuthorizationProcess-null-3597846)
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1884)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:376)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:267)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)
at oracle.bpm.bpmn.engine.ejb.impl.BPMNAuditTrailBean_r4sc5w_IBPMNAuditTrailLocalBeanImpl.storeCubeInstanceForAudit(Unknown Source)
at com.collaxa.cube.engine.audit.AuditService.storeCubeInstanceForAudit(AuditService.java:359)
at com.collaxa.cube.engine.dispatch.TransactionSynchronization.updateAuditData(TransactionSynchronization.java:201)
at com.collaxa.cube.engine.dispatch.TransactionSynchronization.afterCompletion(TransactionSynchronization.java:84)
at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1003)
at weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:2953)
at weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:2930)
at weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3172)
at weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:2920)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:267)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)
at oracle.bpm.bpmn.engine.ejb.impl.BPMNDeliveryBean_of8dk6_ICubeDeliveryLocalBeanImpl.handleInvoke(Unknown Source)
at com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessageHandler.handle(InvokeInstanceMessageHandler.java:30)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:141)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.process(BaseDispatchTask.java:89)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:66)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
at com.collaxa.cube.engine.dispatch.Dispatcher$ContextCapturingThreadFactory$2.run(Dispatcher.java:933)
at java.lang.Thread.run(Thread.java:662)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PESOAS_SOAINFRA.CI_PK) violated

Error Code: 1
Call: INSERT INTO CUBE_INSTANCE (CIKEY, AG_MILESTONE_PATH, AG_ROOT_ID, AT_COUNT_ID, AT_DETAIL_ID, AT_EVENT_ID, CACHE_VERSION, CMPST_ID, CPST_INST_CREATED_TIME, COMPONENT_NAME, COMPONENTTYPE, COMPOSITE_LABEL, COMPOSITE_NAME, COMPOSITE_REVISION, CONVERSATION_ID, CREATE_CLUSTER_NODE_ID, CREATION_DATE, CREATOR, DOMAIN_NAME, ECID, EXT_INT1, EXT_STRING1, EXT_STRING2, LAST_CLUSTER_NODE_ID, METADATA, MODIFIER, MODIFY_DATE, OUTCOME, PARENT_ID, PARENT_REF_ID, PRIORITY, PROCESS_TYPE, ROOT_ID, SCOPE_CSIZE, SCOPE_REVISION, SCOPE_USIZE, STAGE, STATE, STATUS, TENANT_ID, TEST_CASE, TEST_RUN_ID, TEST_RUN_NAME, TEST_SUITE, TITLE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [45 parameters bound]
Query: InsertObjectQuery(Authorization-EDBCAuthorizationProcess-null-3597846)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:840)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:123)
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1505)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3143)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:346)
at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157)
at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)
at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1244)
at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1219)
at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:121)
at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1355)
at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2172)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:300)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:267)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:622)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)
at oracle.bpm.bpmn.engine.ejb.impl.BPMNAuditTrailBean_r4sc5w_IBPMNAuditTrailLocalBeanImpl.storeCubeInstanceForAudit(Unknown Source)
at com.collaxa.cube.engine.audit.AuditService.storeCubeInstanceForAudit(AuditService.java:359)
at com.collaxa.cube.engine.dispatch.TransactionSynchronization.updateAuditData(TransactionSynchronization.java:201)
at com.collaxa.cube.engine.dispatch.TransactionSynchronization.afterCompletion(TransactionSynchronization.java:82)
at weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1053)
at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1003)
at weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:3074)
at weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:2953)
at weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:2929)
at weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3172)
at weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:2919)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:374)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:267)
at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:622)
at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:455)
at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:52)
at oracle.bpm.bpmn.engine.ejb.impl.BPMNDeliveryBean_of8dk6_ICubeDeliveryLocalBeanImpl.handleInvoke(Unknown Source)
at com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessageHandler.handle(InvokeInstanceMessageHandler.java:30)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:141)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.process(BaseDispatchTask.java:89)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:65)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
... 2 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PESOAS_SOAINFRA.CI_PK) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:831)
... 68 more
.>

 

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