My Oracle Support Banner

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 MAY 15, 2023

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:

#### <soa_server1> <> <> Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_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_soa_domain]=(ServerResourceInfo[SOADataSource_soa_domain]=(state=rolledback,assigned=soa_server1),xar=SOADataSource,re-Registered = false),SCInfo[soa_domain+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=soa_server1+<host-ip>:<port>+soa_domain+t3+, XAResources={eis/tibjms/Queue, eis/activemq/Queue, WLStore_soa_domain__WLS_soa_server1, WSATGatewayRM_soa_server1_soa_domain, EDNDataSource_soa_domain, eis/fioranomq/Topic, eis/jbossmq/Queue, eis/Apps/Apps, WLStore_soa_domain_SOAJMSFileStore_auto_2, eis/webspheremq/Queue, eis/AQ/aqSample, eis/aqjms/Queue, eis/sunmq/Queue, eis/pramati/Queue, WLStore_soa_domain_AGJMSFileStore_auto_2, eis/tibjmsDirect/Queue, WLStore_soa_domain_UMSJMSFileStore_auto_2, eis/wls/Queue, eis/tibjmsDirect/Topic, WLStore_soa_domain_BPMJMSFileStore_auto_2, SOADataSource_soa_domain, eis/wls/Topic, eis/aqjms/Topic, eis/tibjms/Topic, WLStore_soa_domain_PS6SOAJMSFileStore_auto_2},NonXAResources={})],CoordinatorURL=soa_server1+<host-ip>:<port>+soa_domain+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@2f33c73a

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_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
.>

 

Changes

 

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


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