ORABPEL-30278 Error Is Thrown While Inserting A Task (Doc ID 1450994.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle Business Process Management Suite - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.
***Checked for relevance on 17-October-2013***

Symptoms

Randomly, when executing a process instance, some or all of the following errors could be thrown, the instance goes to Fault state and is no longer visible in Workspace.

####<Oct 12, 2011 11:17:27 AM COT> <Notice> <Stdout> <server_name>
<SOA_server> <orabpel.engine.pool-9.thread-20> <<WLS Kernel>> <>
<24a24a75e0ddc3e7:6dab4b51:132f45a9302:-8000-000000000001ca09>
<1318436247316> <BEA-000000> <<Oct 12, 2011 11:17:27 AM COT> <Error>
<oracle.soa.services.workflow.persistency> <BEA-000000> <<.> Error while inserting task .
Error while inserting task {0} .
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.

ORABPEL-30278

Error while inserting task .
Error while inserting task {0} .
Check the underlying exception and the database connection information. If
the error persists, contact Oracle Support Services.
at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.insertTaskIntoDatabase(OracleWFTask.java:319)
at oracle.bpel.services.workflow.repos.driver.WFTask.insertWFTask(WFTask.java:2326)
at oracle.bpel.services.workflow.repos.driver.PersistencyService.insertWFTask(PersistencyService.java:493)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:6355)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:6146)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7388)
at oracle.bpel.services.workflow.task.impl.TaskService.localHandleRoutingSlipInterpretationResult(TaskService.java:3453)
at oracle.bpel.services.workflow.task.impl.TaskService.handleRoutingSlipInterpretationResult(TaskService.java:3548)
at oracle.bpel.services.workflow.task.impl.TaskService.initiateTask(TaskService.java:1545)
at oracle.bpel.services.workflow.task.impl.TaskService.initiateTask(TaskService.java:632)
at oracle.bpel.services.workflow.task.impl.TaskService.initiateTask(TaskService.java:580)
at sun.reflect.GeneratedMethodAccessor6867.invoke(Unknown Source)
...
Caused By: java.sql.SQLException: ORA-20003: Error while inserting task
ORA-06512: at "DEV1_SOAINFRA.WFTASKPKG_111140", line 1371
ORA-12899: value too large for column
"DEV1_SOAINFRA"."WFTASK"."PARENTCOMPONENTINSTREFID" (actual: 222, maximum: 200)
ORA-06512: at line 1

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.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
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.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:9323)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1508)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.insertTaskIntoDatabase(OracleWFTask.java:308)
...



[2011-11-07T21:23:13.021-03:00] [AdminServer] [ERROR] [] [oracle.soa.services.workflow.persistency] [tid: orabpel.invoke.pool-8.thread-5] [userId: <anonymous>] [ecid: 5ddf50df5d3acfc2:-663959d0:1337fa72abc:-8000-0000000000004dce,0:1:100000009] [APP: soa-infra] [composite_name: Some_name] [component_name: Some_name] [component_instance_id: 201293] [composite_instance_id: 160003] <.> Error while inserting task .[[
Error while inserting task {0} .
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.
 ORABPEL-30278

Error while inserting task .
Error while inserting task {0} .
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.

    at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.insertTaskIntoDatabase(OracleWFTask.java:316)
    at oracle.bpel.services.workflow.repos.driver.WFTask.insertWFTask(WFTask.java:2321)
    at oracle.bpel.services.workflow.repos.driver.PersistencyService.insertWFTask(PersistencyService.java:493)
    at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:6299)
    at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:6098)
    at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7323)
    at oracle.bpel.services.workflow.task.impl.TaskService.localHandleRoutingSlipInterpretationResult(TaskService.java:3430)
    at oracle.bpel.services.workflow.task.impl.TaskService.handleRoutingSlipInterpretationResult(TaskService.java:3525)
    at oracle.bpel.services.workflow.task.impl.TaskService.initiateTask(TaskService.java:1532)
    at oracle.bpel.services.workflow.task.impl.TaskService.initiateTask(TaskService.java:619)
    at oracle.bpel.services.workflow.task.impl.TaskService.initiateTask(TaskService.java:567)
    ...
Caused by: java.sql.SQLException: ORA-20003: Error while inserting task
ORA-06512: at "DEV1_SOAINFRA.WFTASKPKG_111140", line 1371
ORA-12899: value too large for column "DEV1_SOAINFRA"."WFTASKHISTORY"."PARENTCOMPONENTINSTREFID" (actual: 221, maximum: 200)
ORA-06512: at line 1

    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.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
    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.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:9323)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1508)
    at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.insertTaskIntoDatabase(OracleWFTask.java:305)
    ... 142 more 

   
    

[2011-11-07T21:57:52.868-03:00] [AdminServer] [ERROR] [] [oracle.soa.bpel.engine.dispatch] [tid: orabpel.invoke.pool-8.thread-6] [userId: <anonymous>] [ecid: 5ddf50df5d3acfc2:-663959d0:1337fa72abc:-8000-00000000000056c5,0:1:100000011] [APP: soa-infra] failed to handle message[[
java.sql.SQLException: ORA-12899: value too large for column "DEV1_SOAINFRA"."DLV_SUBSCRIPTION"."SUBSCRIBER_ID" (actual: 325, maximum: 256)

    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)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:863)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:341)
    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:465)
    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:290)
    at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
    at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
    at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:643)
    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:2908)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1233)
    at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)
    at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:191)
    at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:136)
    at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3348)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1422)
    at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:610)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1527)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3181)
    at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:332)
    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:1239)
    at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1214)
    at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:116)
    at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1316)
    at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2132)
    at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:272)
    at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:239)
    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:35)
    at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:140)
    at com.collaxa.cube.engine.dispatch.BaseDispatchTask.process(BaseDispatchTask.java:88)
    at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:64)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:619)


       

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