SOA Database Adapter Insert/Update Fails with DB2 Identity Columns: A ROWID column cannot be specified as the target column of an INSERT or UPDATE (Doc ID 1199924.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

In SOA 11.1.1.3 attempt to do an insert to a DB2 table that has a ROWID type of column which is a Primary Key, the insert fails to execute. For example the table is defined as follows:

EntityType(
EntityTypeID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, NO CACHE),
EntityTypeName VARCHAR(30),
CreateTS TIMESTAMP,
UpdateBy VARCHAR(8),
UpdateTS TIMESTAMP,
CreateBy VARCHAR(8),
CONSTRAINT PK65 PRIMARY KEY (EntityTypeID));


This is the input to the BPEL composite client using SOAPUI to do the Insert:

<soapenv:Header/>
<soapenv:Body>
<ins:EntitytypeCollection>
<ins:Entitytype>
<ins:entitytypename>Location</ins:entitytypename>
<ins:createts></ins:createts>
<ins:updateby></ins:updateby>
<ins:updatets></ins:updatets>
<ins:createby></ins:createby>
</ins:Entitytype>
</ins:EntitytypeCollection>
</soapenv:Body>
</soapenv:Envelope>


Notice that in this input the ROWID column EntityTypeID is not included, but this is the attempt by SOA to do the insert anyway:

INSERT INTO
ENTITYTYPE(ENTITYTYPEID,ENTITYTYPENAME,CREATETS,UPDATEBY,UPDATETS,CREATE
BY) VALUES (?,?,?,?,?,?)


Since ENTITYTYPEID is included in the INSERT, DB2 does not allow this and fails with:

"A ROWID column cannot be specified as the target column of an INSERT or UPDATE.."


The full error stack when the insert fails is as follows in the server diagnostic logfile $MIDDLEWARE_HOME/user_projects/domains/<domain name>/servers/<soa server name>/logs/<SOA server name>-diagnostic.log:

[2010-07-28T13:23:03.537-05:00] [soa_server1] [NOTIFICATION] [] [oracle.j2ee.ws.common.audit.WebServicesAuditor] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0] [WEBSERVICE_PORT.name: insertOnlyProcess_pt] [APP: soa-infra] [J2EE_MODULE.name: fabric] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] [WEBSERVICE.name: insertonlyprocess_client_ep] [J2EE_APP.name: soa-infra] Registered auditor for componentType=WebServices auditor=oracle.security.jps.internal.audit.AuditServiceImpl$Auditor@1db2720
[2010-07-28T13:23:03.615-05:00] [soa_server1] [NOTIFICATION] [] [oracle.wsm.agent.WSMAgent] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0] [WEBSERVICE_PORT.name: insertOnlyProcess_pt] [APP: soa-infra] [J2EE_MODULE.name: fabric] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] [WEBSERVICE.name: insertonlyprocess_client_ep] [J2EE_APP.name: soa-infra] WSMAgent is initialized for category=security, function=agent.function.service, topologyNodePath=/soa_domain/soa_server1/soainfra/default/DB2Insert/1.0/soa_dee56993-fb8f-4699-a5c8-b1ca69c45256/SERVICEs/insertonlyprocess_client_ep/PORTs/insertOnlyProcess_pt/INTERCEPTORs/, isJ2EE=true
[2010-07-28T13:23:03.647-05:00] [soa_server1] [NOTIFICATION] [] [oracle.wsm.agent.WSMAgent] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0] [WEBSERVICE_PORT.name: insertOnlyProcess_pt] [APP: soa-infra] [J2EE_MODULE.name: fabric] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] [WEBSERVICE.name: insertonlyprocess_client_ep] [J2EE_APP.name: soa-infra] WSMAgent is initialized for category=management, function=agent.function.service, topologyNodePath=/soa_domain/soa_server1/soainfra/default/DB2Insert/1.0/soa_dee56993-fb8f-4699-a5c8-b1ca69c45256/SERVICEs/insertonlyprocess_client_ep/PORTs/insertOnlyProcess_pt/INTERCEPTORs/, isJ2EE=true
[2010-07-28T13:23:04.084-05:00] [soa_server1] [NOTIFICATION] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-3] [userId: anonymous] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [composite_name: DB2Insert] [component_name: insertOnlyProcess] [component_instance_id: 200003] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] Database Adapter FusionCenterProcess:insertOnlyEntityType [ insertOnlyEntityType_ptt::insert(EntitytypeCollection) ] <oracle.tip.adapter.db.DBAdapterConstants getUniqueProcessIdentifier> Unique process identifier will be DB2Insert_default_DB2Insert_1_0_soa_dee56993_fb8f_4699_a5c8_b1ca69c45256_insertOnlyEntityType[[

]]
[2010-07-28T13:23:04.100-05:00] [soa_server1] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-3] [userId: anonymous] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [composite_name: DB2Insert] [component_name: insertOnlyProcess] [component_instance_id: 200003] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] JCABinding=> DB2Insert:insertOnlyEntityType [ insertOnlyEntityType_ptt::insert(EntitytypeCollection) ] Could not invoke operation 'insert' against the 'Database Adapter' due to: [[
BINDING.JCA-11616
DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [insertOnlyEntityType.Entitytype].
Caused by weblogic.jdbc.db2base.ddc: [OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE..
Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "--798" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

]]
[2010-07-28T13:23:04.100-05:00] [soa_server1] [NOTIFICATION] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-3] [userId: anonymous] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [composite_name: DB2Insert] [component_name: insertOnlyProcess] [component_instance_id: 200003] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] JCABinding=> DB2Insert:insertOnlyEntityType [ insertOnlyEntityType_ptt::insert(EntitytypeCollection) ] Change logging level to TRACE:n to see full error stack
[2010-07-28T13:23:04.131-05:00] [soa_server1] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-3] [userId: anonymous] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [composite_name: DB2Insert] [component_name: insertOnlyProcess] [component_instance_id: 200003] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] JCABinding=> [default/DB2Insert!1.0*soa_dee56993-fb8f-4699-a5c8-b1ca69c45256.insertOnlyEntityType]:insert One-way operation insert() failed
[2010-07-28T13:23:04.131-05:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine.ws] [tid: orabpel.invoke.pool-4.thread-3] [userId: anonymous] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [composite_name: DB2Insert] [component_name: insertOnlyProcess] [component_instance_id: 200003] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] <WSInvocationManager::invoke> got FabricInvocationException[[
oracle.fabric.common.FabricInvocationException: BINDING.JCA-12563
Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [insertOnlyEntityType.Entitytype].
Caused by weblogic.jdbc.db2base.ddc: [OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE..
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.

at oracle.integration.platform.blocks.adapter.fw.jca.cci.EndpointInteractionException.getFabricInvocationException(EndpointInteractionException.java:75)
at oracle.integration.platform.blocks.adapter.AdapterReference.getFabricInvocationException(AdapterReference.java:298)
at oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:284)
at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:142)
at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:194)
at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:215)
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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:71)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy252.post(Unknown Source)
at oracle.fabric.CubeServiceEngine.postToMesh(CubeServiceEngine.java:779)
at com.collaxa.cube.ws.WSInvocationManager.invoke(WSInvocationManager.java:257)
at com.collaxa.cube.engine.ext.common.InvokeHandler.__invoke(InvokeHandler.java:1073)
at com.collaxa.cube.engine.ext.common.InvokeHandler.handleNormalInvoke(InvokeHandler.java:526)
at com.collaxa.cube.engine.ext.common.InvokeHandler.handle(InvokeHandler.java:127)
at com.collaxa.cube.engine.ext.bpel.common.wmp.BPELInvokeWMP.__executeStatements(BPELInvokeWMP.java:69)
at com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:162)
at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2465)
at com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1132)
at com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:73)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:219)
at com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:327)
at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4350)
at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4281)
at com.collaxa.cube.engine.CubeEngine._createAndInvoke(CubeEngine.java:713)
at com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:545)
at com.collaxa.cube.engine.delivery.DeliveryService.handleInvoke(DeliveryService.java:654)
at com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.handleInvoke(CubeDeliveryBean.java:355)
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 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.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:88)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:414)
at oracle.security.jps.wls.JpsWeblogicEjbInterceptor.runJaasMode(JpsWeblogicEjbInterceptor.java:61)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:106)
at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:106)
at sun.reflect.GeneratedMethodAccessor1209.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.jee.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:69)
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.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
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 $Proxy247.handleInvoke(Unknown Source)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.handleInvoke(BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.java:857)
at com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessageHandler.handle(InvokeInstanceMessageHandler.java:35)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:141)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:82)
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)
Caused by: BINDING.JCA-12563
Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [insertOnlyEntityType.Entitytype].
Caused by weblogic.jdbc.db2base.ddc: [OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE..
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.

at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:433)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:519)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeAsyncJcaReference(JCAInteractionInvoker.java:502)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAEndpointInteraction.performAsynchronousInteraction(JCAEndpointInteraction.java:491)
at oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:247)
... 74 more
Caused by: BINDING.JCA-11616
DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [insertOnlyEntityType.Entitytype].
Caused by weblogic.jdbc.db2base.ddc: [OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE..
Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "--798" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.

at oracle.tip.adapter.db.exceptions.DBResourceException.createNonRetriableException(DBResourceException.java:653)
at oracle.tip.adapter.db.exceptions.DBResourceException.createEISException(DBResourceException.java:619)
at oracle.tip.adapter.db.exceptions.DBResourceException.outboundWriteException(DBResourceException.java:667)
at oracle.tip.adapter.db.transaction.DBTransaction.commit(DBTransaction.java:236)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:316)
... 78 more
Caused by: weblogic.jdbc.db2base.ddc: [OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE.
at weblogic.jdbc.db2base.ddb9.executeBatch(Unknown Source)
at weblogic.jdbcx.db2base.ddr.executeBatch(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
at org.eclipse.persistence.platform.database.oracle.Oracle10Platform.executeBatch(Oracle10Platform.java:53)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:821)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:138)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1645)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.commitTransaction(DatabaseAccessor.java:403)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicCommitTransaction(AbstractSession.java:503)
at org.eclipse.persistence.sessions.server.ClientSession.basicCommitTransaction(ClientSession.java:155)
at org.eclipse.persistence.internal.sessions.AbstractSession.commitTransaction(AbstractSession.java:685)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransaction(UnitOfWorkImpl.java:1572)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1441)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1518)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitRootUnitOfWork(UnitOfWorkImpl.java:1321)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:1083)
at oracle.tip.adapter.db.transaction.DBTransaction.commit(DBTransaction.java:193)
... 79 more

]]
[2010-07-28T13:23:04.147-05:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine] [tid: orabpel.invoke.pool-4.thread-3] [userId: anonymous] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [composite_name: DB2Insert] [component_name: insertOnlyProcess] [component_instance_id: 200003] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] <CubeEngine::finalizeActivity> Unhandled exception for ComponentDN=default/DB2Insert!1.0*soa_dee56993-fb8f-4699-a5c8-b1ca69c45256/insertOnlyProcess CompositeInstanceId=190001 ComponentInstanceId=200003
[2010-07-28T13:23:04.147-05:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine] [tid: orabpel.invoke.pool-4.thread-3] [userId: anonymous] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [composite_name: DB2Insert] [component_name: insertOnlyProcess] [component_instance_id: 200003] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] <CubeEngine::handleWorkItem> This exception occurred because the fault thrown in the BPEL flow was not handled by any fault handlers and reached the top-level scope. Root cause : com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}bindingFault}[[
parts: {{
summary=<summary>Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [insertOnlyEntityType.Entitytype].
Caused by weblogic.jdbc.db2base.ddc: [OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE..
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
</summary>
,detail=<detail>[OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE.</detail>
,code=<code>-798</code>}

]]
[2010-07-28T13:23:04.209-05:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine.dispatch] [tid: orabpel.invoke.pool-4.thread-3] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] <DispatchHelper::handleMessage> failed to handle message[[
ORABPEL-02055

Fault not handled.
failure to handle a fault thrown from a scope, by any blocks in the scope chain.
This exception occurred because the fault thrown in the BPEL flow was not handled by any fault handlers and reached the top-level scope.
A top-level fault handler should be added to the flow to handle faults not caught from within the flow.

at com.collaxa.cube.engine.CubeEngine.finalizeActivity(CubeEngine.java:2842)
at com.collaxa.cube.engine.CubeEngine.checkBlockConditions(CubeEngine.java:3557)
at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2490)
at com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1132)
at com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:73)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:219)
at com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:327)
at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4350)
at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4281)
at com.collaxa.cube.engine.CubeEngine._createAndInvoke(CubeEngine.java:713)
at com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:545)
at com.collaxa.cube.engine.delivery.DeliveryService.handleInvoke(DeliveryService.java:654)
at com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.handleInvoke(CubeDeliveryBean.java:355)
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 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.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:88)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:414)
at oracle.security.jps.wls.JpsWeblogicEjbInterceptor.runJaasMode(JpsWeblogicEjbInterceptor.java:61)
at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:106)
at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:106)
at sun.reflect.GeneratedMethodAccessor1209.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.jee.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:69)
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.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
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 $Proxy247.handleInvoke(Unknown Source)
at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.handleInvoke(BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.java:857)
at com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessageHandler.handle(InvokeInstanceMessageHandler.java:35)
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:141)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:82)
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)
Caused by: com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}bindingFault}
parts: {{
summary=<summary>Exception occured when binding was invoked.
Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [insertOnlyEntityType.Entitytype].
Caused by weblogic.jdbc.db2base.ddc: [OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE..
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
</summary>
,detail=<detail>[OWLS][DB2 JDBC Driver][DB2]A ROWID column cannot be specified as the target column of an INSERT or UPDATE.</detail>
,code=<code>-798</code>}

at com.collaxa.cube.ws.WSInvocationManager.invoke(WSInvocation Manager.java:321)
at com.collaxa.cube.engine.ext.common.InvokeHandler.__invoke(InvokeHandler.java:1073)
at com.collaxa.cube.engine.ext.common.InvokeHandler.handleNormalInvoke(InvokeHandler.java:526)
at com.collaxa.cube.engine.ext.common.InvokeHandler.handle(InvokeHandler.java:127)
at com.collaxa.cube.engine.ext.bpel.common.wmp.BPELInvokeWMP.__executeStatements(BPELInvokeWMP.java:69)
at com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:162)
at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2465)
... 52 more

]]
[2010-07-28T13:23:04.209-05:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine.dispatch] [tid: orabpel.invoke.pool-4.thread-3] [ecid: 0000IcQIl^nApI15RvedMd1CK7Jl00000v,0:18:100000002] [APP: soa-infra] [dcid: 61120347efcdeb25:260f0b29:12a1a496873:-7ffd-00000000000017f0] <BaseDispatchTask::logHandleMessageError> Failed to handle dispatch message ... exception ORABPEL-05002[[

Message handle error.
error while attempting to process the message "com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessage"; the reported exception is: Fault not handled.
failure to handle a fault thrown from a scope, by any blocks in the scope chain.
This exception occurred because the fault thrown in the BPEL flow was not handled by any fault handlers and reached the top-level scope.
A top-level fault handler should be added to the flow to handle faults not caught from within the flow.

This error contained an exception thrown by the message handler.
Check the exception trace in the log (with logging level set to debug mode).
ORABPEL-05002

Message handle error.
error while attempting to process the message "com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessage"; the reported exception is: Fault not handled.
failure to handle a fault thrown from a scope, by any blocks in the scope chain.
This exception occurred because the fault thrown in the BPEL flow was not handled by any fault handlers and reached the top-level scope.
A top-level fault handler should be added to the flow to handle faults not caught from within the flow.

This error contained an exception thrown by the message handler.
Check the exception trace in the log (with logging level set to debug mode).

at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(DispatchHelper.java:206)
at com.collaxa.cube.engine.dispatch.BaseDispatchTask.run(BaseDispatchTask.java:82)
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