This discussion is archived
8 Replies Latest reply: Apr 10, 2012 3:43 AM by RK.. RSS

SOA 11.1.1.5 Error on insert to table

user618218 Newbie
Currently Being Moderated
Hi

Need hlep!!

We are getting the following error in the SOA composite when we try to insert to table

<fault>
<bpelFault>
<faultType>0</faultType>
<remoteFault>
<part name="summary">
<summary>oracle.fabric.common.FabricInvocationException: java.lang.AbstractMethodError: persistencegetId</summary> </part> <part name="detail"> <detail>persistencegetId</detail>
</part>
<part name="code">
<code>null</code>
</part>
</remoteFault>
</bpelFault>
</fault>


This is what i found in soa_server2-diagnostic.log

[2012-02-27T20:08:05.691-06:00] [soa_server2] [NOTIFICATION] [] [oracle.integration.platform.blocks.deploy.coordinator] [tid: ReplicatedCache:ecp_soa_domain_soa_cluster_1CacheService:EventDispatcher] [userId: <anonymous>] [ecid: 848b73030dd6a2e6:2285f79f:135c0708420:-8000-0000000000000002,1:17962] [APP: soa-infra] New deployment: {id=e33b1440-6e0b-45ac-8b97-cf04f1be2321, status=startPhaseTwo, command=serverReadyCheck} [2012-02-27T20:08:05.694-06:00] [soa_server2] [NOTIFICATION] [] [oracle.integration.platform.blocks.deploy.coordinator] [tid: ReplicatedCache:ecp_soa_domain_soa_cluster_1CacheService:EventDispatcher] [userId: <anonymous>] [ecid: 848b73030dd6a2e6:2285f79f:135c0708420:-8000-0000000000000002,1:17962] [APP: soa-infra] Deployment updated: {id=e33b1440-6e0b-45ac-8b97-cf04f1be2321, status=complete} [2012-02-27T20:08:05.695-06:00] [soa_server2] [NOTIFICATION] [] [oracle.integration.platform.blocks.deploy.coordinator] [tid: ReplicatedCache:ecp_soa_domain_soa_cluster_1CacheService:EventDispatcher] [userId: <anonymous>] [ecid: 848b73030dd6a2e6:2285f79f:135c0708420:-8000-0000000000000002,1:17962] [APP: soa-infra] Removing command lock for e33b1440-6e0b-45ac-8b97-cf04f1be2321


This started happening after we apply Doc ID 1390200.1


thank you
  • 1. Re: SOA 11.1.1.5 Error on insert to table
    Anuj Dwivedi Guru
    Currently Being Moderated
    Ideally a B2B patch won't affect the adapter's functionality. Still, what patch number have you downloaded from metalink and applied? Did you already had any patch applied earlier? The log which you have pasted does not give much information.

    Try to restart all the servers and see if it works. Still if you face the issue, log a SR with support as it seems like a classpath issue.

    Regards,
    Anuj
  • 2. Re: SOA 11.1.1.5 Error on insert to table
    user618218 Newbie
    Currently Being Moderated
    We applied the patch from Doc ID 1390200.1. Ive tried restarting managed services. It did not work do you suggest that i restart the admin abd node manager too ? Or should we bounce the box as well?

    I have logged a tar . They suggest to roll back the patch.

    Thank you
  • 3. Re: SOA 11.1.1.5 Error on insert to table
    Anuj Dwivedi Guru
    Currently Being Moderated
    It did not work do you suggest that i restart the admin abd node manager too ?
    It is always suggested to bounce the entire domain (including admin server) after applying any patch. So you may like to bounce the admin server however I am not really sure whether this will help.
    I have logged a tar . They suggest to roll back the patch.
    Have they suggested it as part of investigation or they already know that issue is because of the patch? Can you provide the SR number?

    Regards,
    Anuj
  • 4. Re: SOA 11.1.1.5 Error on insert to table
    user618218 Newbie
    Currently Being Moderated
    I bounce everthing but issue still persist

    This is the SR is SR 3-5379774061: SOA 11.1.1.5 Error on insert to table using DB Adapter

    They suggest roll back as parrt of investigation.


    thank you for your help
  • 5. Re: SOA 11.1.1.5 Error on insert to table
    user618218 Newbie
    Currently Being Moderated
    I checked the log again and this is the error i am getting

    [2012-02-28T22:32:58.818-06:00] [soa_server2] [ERROR] [] [oracle.soa.adapter] [tid: orabpel.invoke.pool-4.thread-15] [userId: <anonymous>] [ecid: C0A85CB6135C761CDF400000108FC624,0:1:100000029] [APP: soa-infra] [composite_name: FORX_SOA_POS_PROCESS] [component_name: FORX_SOA_POS_PROCESS] [component_instance_id: 970015] [URI: /soa-infra/services/default/FORX_MEDIATOR_POS_PROCESS!1.0*soa_7c9153e8-1e93-431b-8e79-22027645b1a4/FORX_BPEL_SYNNEX_POS%23FORX_MEDIATOR_POS_PROCESS/FORX_BPEL_SYNNEX_POS] JCABinding=> [default/FORX_SOA_POS_PROCESS!1.0*soa_65ad0699-2d1c-4c54-8b51-8a2cc6871374.INSERT_FORX_VENDOR_STATUS_HEADER]:insert One-way operation insert() failed
    [2012-02-28T22:32:58.823-06:00] [soa_server2] [ERROR] [] [oracle.soa.bpel.engine.ws] [tid: orabpel.invoke.pool-4.thread-15] [userId: <anonymous>] [ecid: C0A85CB6135C761CDF400000108FC624,0:1:100000029] [APP: soa-infra] [composite_name: FORX_SOA_POS_PROCESS] [component_name: FORX_SOA_POS_PROCESS] [component_instance_id: 970015] [URI: /soa-infra/services/default/FORX_MEDIATOR_POS_PROCESS!1.0*soa_7c9153e8-1e93-431b-8e79-22027645b1a4/FORX_BPEL_SYNNEX_POS%23FORX_MEDIATOR_POS_PROCESS/FORX_BPEL_SYNNEX_POS] got FabricInvocationException[[
    java.lang.AbstractMethodError: persistencegetId
         at org.eclipse.persistence.internal.descriptors.ObjectBuilder.extractPrimaryKeyFromObject(ObjectBuilder.java:2114)
         at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNewObjectInIdentityMap(UnitOfWorkImpl.java:4302)
         at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNewObjectClone(UnitOfWorkImpl.java:4276)
         at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNewObject(UnitOfWorkImpl.java:4114)
         at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.registerNewObject(UnitOfWorkImpl.java:4060)
         at oracle.tip.adapter.db.DBInteraction.executeOutboundWrite(DBInteraction.java:832)
         at oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:241)
         at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:311)
         at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:525)
         at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeAsyncJcaReference(JCAInteractionInvoker.java:508)
         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)
         at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:142)
         at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:197)
         at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:214)
         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 $Proxy301.post(Unknown Source)
         at oracle.fabric.CubeServiceEngine.postToMesh(CubeServiceEngine.java:806)
         at com.collaxa.cube.ws.WSInvocationManager.invoke(WSInvocationManager.java:258)
         at com.collaxa.cube.engine.ext.common.InvokeHandler.__invoke(InvokeHandler.java:1059)
         at com.collaxa.cube.engine.ext.common.InvokeHandler.handleNormalInvoke(InvokeHandler.java:586)
         at com.collaxa.cube.engine.ext.common.InvokeHandler.handle(InvokeHandler.java:130)
         at com.collaxa.cube.engine.ext.bpel.common.wmp.BPELInvokeWMP.__executeStatements(BPELInvokeWMP.java:74)
         at com.collaxa.cube.engine.ext.bpel.common.wmp.BaseBPELActivityWMP.perform(BaseBPELActivityWMP.java:158)
         at com.collaxa.cube.engine.CubeEngine.performActivity(CubeEngine.java:2543)
         at com.collaxa.cube.engine.CubeEngine._handleWorkItem(CubeEngine.java:1165)
         at com.collaxa.cube.engine.CubeEngine.handleWorkItem(CubeEngine.java:1071)
         at com.collaxa.cube.engine.dispatch.message.instance.PerformMessageHandler.handleLocal(PerformMessageHandler.java:73)
         at com.collaxa.cube.engine.dispatch.DispatchHelper.handleLocalMessage(DispatchHelper.java:220)
         at com.collaxa.cube.engine.dispatch.DispatchHelper.sendMemory(DispatchHelper.java:328)
         at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4430)
         at com.collaxa.cube.engine.CubeEngine.endRequest(CubeEngine.java:4361)
         at com.collaxa.cube.engine.CubeEngine._createAndInvoke(CubeEngine.java:698)
         at com.collaxa.cube.engine.CubeEngine.createAndInvoke(CubeEngine.java:555)
         at com.collaxa.cube.engine.delivery.DeliveryService.handleInvoke(DeliveryService.java:673)
         at com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.handleInvoke(CubeDeliveryBean.java:293)
         at sun.reflect.GeneratedMethodAccessor1765.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.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
         at oracle.security.jps.ee.ejb.JpsAbsInterceptor$1.run(JpsAbsInterceptor.java:94)
         at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
         at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
         at oracle.security.jps.ee.ejb.JpsAbsInterceptor.runJaasMode(JpsAbsInterceptor.java:81)
         at oracle.security.jps.ee.ejb.JpsAbsInterceptor.intercept(JpsAbsInterceptor.java:112)
         at oracle.security.jps.ee.ejb.JpsInterceptor.intercept(JpsInterceptor.java:105)
         at sun.reflect.GeneratedMethodAccessor1442.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 $Proxy284.handleInvoke(Unknown Source)
         at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.__WL_invoke(Unknown Source)
         at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)
         at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_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)

    ]]

    thank you
  • 6. Re: SOA 11.1.1.5 Error on insert to table
    Anuj Dwivedi Guru
    Currently Being Moderated
    I checked your SR and it seems you have recently upgraded your system and this issue is specific to one system only. Most probably something has gone wrong during upgrade and few old jars are still being referenced. Support may help you to figure out the root cause.

    Regards,
    Anuj
  • 7. Re: SOA 11.1.1.5 Error on insert to table
    user618218 Newbie
    Currently Being Moderated
    They still do not know how to fix it

    we are trying one thing now

    thank you
  • 8. Re: SOA 11.1.1.5 Error on insert to table
    RK.. Newbie
    Currently Being Moderated
    Hi

    Is the issue resolved for you. We are also facing the same issue in 11.1.1.4. also is the connections are reaching the maximum level??

    Edited by: Prasanth on Apr 10, 2012 3:43 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points