8 Replies Latest reply: Apr 10, 2012 5:43 AM by RK.. RSS

    SOA 11.1.1.5 Error on insert to table

    user618218
      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-Oracle
          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
            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-Oracle
              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
                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
                  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-Oracle
                    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
                      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..
                        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