2 Replies Latest reply: Jan 17, 2013 2:10 PM by 985576 RSS

    BPELEngineBean.syncCreateAndInvoke throws Exception occurred during commit

    766117
      We have a SOA Suite 11g composite deployed on a cluster with 4 managed server.
      Version of SOA suite is 11.1.1.1.0
      This composite gets called only once a day.

      Following errror is thrown by the composite only sometimes
      :
      ###<Apr 12, 2010 8:03:51 AM EDT> <Error> <EJB> <ulolaaspa06> <lolasoa-9711-Managed2> <[ACTIVE] ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'> <webserviceuser> <> <> <1271073831333> <BEA-010026> <Exception occurred during commit of transaction Name=[EJB com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean.syncCreateAndInvoke(oracle.soa.management.ComponentDN,java.lang.String,oracle.fabric.common.NormalizedMessage)],Xid=BEA1-353533481A0F8887627C(308589051),Status=Rolled back. [Reason=oracle.jdbc.xa.OracleXAException],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=214,seconds left=60,XAServerResourceInfo[lolaDS_lolasoa]=(ServerResourceInfo[lolaDS_lolasoa]=(state=rolledback,assigned=lolasoa-9711-Managed2),xar=lolaDS,re-Registered = false),XAServerResourceInfo[SOADataSource_lolasoa]=(ServerResourceInfo[SOADataSource_lolasoa]=(state=rolledback,assigned=lolasoa-9711-Managed2),xar=SOADataSource,re-Registered = false),SCInfo[lolasoa+lolasoa-9711-Managed2]=(state=rolledback),SCInfo[lola+lola-9631-Managed2]=(state=rolledback),properties=({weblogic.transaction.name=[EJB com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean.syncCreateAndInvoke(oracle.soa.management.ComponentDN,java.lang.String,oracle.fabric.common.NormalizedMessage)]}),local properties=({weblogic.jdbc.jta.SOADataSource=[ No XAConnection is attached to this TxInfo ], weblogic.jdbc.jta.lolaDS=[ No XAConnection is attached to this TxInfo ]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=lolasoa-9711-Managed2+ulolaaspa06.cuc.com:9711+lolasoa+t3+, XAResources={eis/tibjms/Queue, eis/activemq/Queue, WSATGatewayRM_lolasoa-9711-Managed2_lolasoa, eis/fioranomq/Topic, eis/DB/SOADemo, eis/Apps/Apps, eis/webspheremq/Queue, eis/AQ/aqSample, lolaDS_lolasoa, eis/tibjmsDirect/Queue, eis/aqjms/Queue, eis/sunmq/Queue, eis/pramati/Queue, eis/tibjms/Topic, WLStore_lolasoa__WLS_lolasoa-9711-Managed2, eis/jbossmq/Queue, eis/wls/Queue, oracle.tip.adapter.jms.JmsXAResource, eis/tibjmsDirect/Topic, WLStore_lolasoa_SOAJMSFileStore_auto_2, eis/wls/Topic, EDNDataSource_lolasoa, eis/aqjms/Topic, WLStore_lolasoa_filestore_lolasoa_9711_2, WLStore_lolasoa_UMSJMSFileStore_auto_2, SOADataSource_lolasoa},NonXAResources={})],CoordinatorURL=lolasoa-9711-Managed2+ulolaaspa06.cuc.com:9711+lolasoa+t3+): weblogic.transaction.RollbackException: Could not prepare resource 'lolaDS_lolasoa
           at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1834)
           at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:339)
           at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:233)
           at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:591)
           at weblogic.ejb.container.internal.BaseLocalObject.postInvokeTxRetry(BaseLocalObject.java:424)
           at com.collaxa.cube.engine.ejb.impl.bpel.BPELEngineBean_51369e_ICubeEngineLocalBeanImpl.syncCreateAndInvoke(BPELEngineBean_51369e_ICubeEngineLocalBeanImpl.java:676)
           at com.collaxa.cube.engine.delivery.DeliveryHandler.initialRequestAnyType(DeliveryHandler.java:528)
           at com.collaxa.cube.engine.delivery.DeliveryHandler.initialRequest(DeliveryHandler.java:482)
           at com.collaxa.cube.engine.delivery.DeliveryHandler.request(DeliveryHandler.java:156)
           at com.collaxa.cube.engine.ejb.impl.CubeDeliveryBean.request(CubeDeliveryBean.java:600)
           at sun.reflect.GeneratedMethodAccessor836.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.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 $Proxy188.request(Unknown Source)
           at com.collaxa.cube.engine.ejb.impl.bpel.BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.request(BPELDeliveryBean_5k948i_ICubeDeliveryLocalBeanImpl.java:745)
           at oracle.fabric.CubeServiceEngine.request(CubeServiceEngine.java:290)
           at oracle.integration.platform.blocks.mesh.SynchronousMessageHandler.doRequest(SynchronousMessageHandler.java:139)
           at oracle.integration.platform.blocks.mesh.MessageRouter.request(MessageRouter.java:179)
           at oracle.integration.platform.blocks.mesh.MeshImpl$2.run(MeshImpl.java:167)
           at javax.security.auth.Subject.doAs(Subject.java:396)
           at oracle.integration.platform.blocks.mesh.MeshImpl.doRequestAsSubject(MeshImpl.java:165)
           at oracle.integration.platform.blocks.mesh.MeshImpl.request(MeshImpl.java:141)
           at sun.reflect.GeneratedMethodAccessor830.invoke(Unknown Source)
           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:296)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
           at oracle.integration.platform.metrics.PhaseEventAspect.invoke(PhaseEventAspect.java:59)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
           at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
           at $Proxy202.request(Unknown Source)
           at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.doMessageProcessing(WebServiceEntryBindingComponent.java:1155)
           at oracle.integration.platform.blocks.soap.WebServiceEntryBindingComponent.processIncomingMessage(WebServiceEntryBindingComponent.java:767)
           at oracle.integration.platform.blocks.soap.FabricProvider.processMessage(FabricProvider.java:113)
           at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:1119)
           at oracle.j2ee.ws.server.WebServiceProcessor$1.run(WebServiceProcessor.java:881)
           at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
           at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:47)
           at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:79)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
           at weblogic.security.Security.runAs(Security.java:61)
           at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:48)
           at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:52)
           at oracle.security.jps.wls.jaas.WlsSubjectSecurity.executeAs(WlsSubjectSecurity.java:145)
           at oracle.j2ee.ws.server.provider.GenericProviderPlatform.runAs(GenericProviderPlatform.java:293)
           at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:888)
           at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:553)
           at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:202)
           at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:166)
           at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:384)
           at oracle.integration.platform.blocks.soap.FabricProviderServlet.doPost(FabricProviderServlet.java:444)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:202)
           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3588)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2200)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      Caused by: oracle.jdbc.xa.OracleXAException
           at oracle.jdbc.xa.client.OracleXAResource.prepare(OracleXAResource.java:673)
           at weblogic.jdbc.wrapper.VendorXAResource.prepare(VendorXAResource.java:70)
           at weblogic.jdbc.jta.DataSource.prepare(DataSource.java:887)
           at weblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:1278)
           at weblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerResourceInfo.java:500)
           at weblogic.transaction.internal.ServerSCInfo.startPrepare(ServerSCInfo.java:380)
           at weblogic.transaction.internal.ServerTransactionImpl.localPrepare(ServerTransactionImpl.java:2589)
           at weblogic.transaction.internal.ServerTransactionImpl.globalPrepare(ServerTransactionImpl.java:2236)
           at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:273)
           ... 84 more
      .>

      lolaDS is our XA datasource pointing to application database.
      We can not consistently recreate this error. It happens only sometimes.

      It looks when appllication is redeployed or when it goes through reintialization (of application singletons) we have seen this error happen more. We have some application config properties and lolaDS datasource stored in a singleton.