1 2 Previous Next 16 Replies Latest reply: Jul 2, 2014 3:46 AM by 946548 RSS

    RollbackException JBO-26030: Failed to lock the record, another user holds the lock.

    946548

      Hi,

       

      I have encountered one strange issue which popup error like "JBO-26030: Failed to lock the record, another user holds the lock."

      But I am sure about which is not oracle.jbo.AlreadyLockedException, is weblogic.transaction.RollbackException.

      And I also following the previously solutions, like "set AM Lock Mode as optimistic", my AM has already set optimistic of Lock Mode.

      I should be transaction issue.

      Following is log message.

       

      Failed to lock the record, another user holds the lock.

      <Jun 19, 2014 12:26:15 AM PDT> <Warning> <Security> <BEA-090784> <While Trying to find the groups that PER_EMPLOYEE_ABSTRACT belongs to,A Duplicate member OBIA_BUSINESS_INTELLIGENCE_APPLICATIONS_WORKER was detected.>

      <Jun 19, 2014 12:26:15 AM PDT> <Warning> <Security> <BEA-090784> <While Trying to find the groups that PER_EMPLOYEE_ABSTRACT belongs to,A Duplicate member OBIA_BUSINESS_INTELLIGENCE_APPLICATIONS_WORKER was detected.>

      <Jun 19, 2014 12:26:16 AM PDT> <Error> <EJB> <BEA-010026> <Exception occurred during commit of transaction Name=[EJB oracle.apps.hcm.compensation.watchlistService.model.applicationModule.server.CompensationWatchlistServiceImpl.refreshWatchlistCategoryAsync(java.lang.String)],Xid=BEA1-00AD4249971BBB1335F6(338633234),Status=Rolled back. [Reason=oracle.jbo.service.errors.ServiceException: JBO-26030: Failed to lock the record, another user holds the lock.],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=60,XAServerResourceInfo[ApplicationServiceDB_HCMDomain]=(ServerResourceInfo[ApplicationServiceDB_HCMDomain]=(state=rolledback,assigned=CompensationServer_1),xar=weblogic.jdbc.wrapper.JTSEmulateXAResourceImpl@14301680,re-Registered = false),SCInfo[HCMDomain+CompensationServer_1]=(state=rolledback),properties=({weblogic.transaction.name=[EJB oracle.apps.hcm.compensation.watchlistService.model.applicationModule.server.CompensationWatchlistServiceImpl.refreshWatchlistCategoryAsync(java.lang.String)], weblogic.jdbc.remote.ApplicationServiceDB=t3://slcad670.us.oracle.com:9408}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=CompensationServer_1+slcad670.us.oracle.com:9408+HCMDomain+t3+, XAResources={WSATGatewayRM_CompensationServer_1_HCMDomain, ApplicationServiceDB_HCMDomain, EDNSource_HCMDomain, EssXADS_HCMDomain},NonXAResources={})],CoordinatorURL=CompensationServer_1+slcad670.us.oracle.com:9408+HCMDomain+t3+): weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=oracle.jbo.server.svc.ServiceJTATxnHandlerImpl@143013bd

       

       

      JBO-26030: Failed to lock the record, another user holds the lock.

        at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:1884)

        at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:376)

        at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:268)

        at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:627)

        at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:49)

        at weblogic.ejb.container.internal.BaseRemoteObject.__WL_postInvokeTxRetry(BaseRemoteObject.java:444)

        at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:53)

        at oracle.apps.hcm.compensation.watchlistService.model.applicationModule.server.CompensationWatchlistServiceImpl_rkivyt_CompensationWatchlistServiceImpl.refreshWatchlistCategoryAsync(Unknown Source)

        at sun.reflect.GeneratedMethodAccessor7451.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)

        at com.sun.proxy.$Proxy164.refreshWatchlistCategoryAsync(Unknown Source)

        at sun.reflect.GeneratedMethodAccessor7450.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:371)

        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:203)

        at oracle.j2ee.ws.server.jaxws.AsyncRequestProcessor.getResponse(AsyncRequestProcessor.java:187)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.processMessage(AsyncMessageProcessor.java:306)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.access$100(AsyncMessageProcessor.java:80)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor$1.run(AsyncMessageProcessor.java:237)

        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

        at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74)

        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:242)

        at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83)

        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)

        at weblogic.security.Security.runAs(Security.java:61)

        at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:51)

        at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:56)

        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:242)

        at oracle.j2ee.ws.server.provider.GenericProviderPlatform.runAs(GenericProviderPlatform.java:426)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.onMessage(AsyncMessageProcessor.java:255)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.onMessage(AsyncMessageProcessor.java:185)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.onMessage(AsyncMessageProcessor.java:164)

        at oracle.j2ee.ws.server.jaxws.AsyncRequestProcessorMDB.onMessage(AsyncRequestProcessorMDB.java:125)

        at sun.reflect.GeneratedMethodAccessor4004.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.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)

        at oracle.jbo.server.svc.ServiceContextInterceptor.removeCurrentADFContext(ServiceContextInterceptor.java:136)

        at sun.reflect.GeneratedMethodAccessor2443.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.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)

        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 com.sun.proxy.$Proxy213.onMessage(Unknown Source)

        at weblogic.ejb.container.internal.NewJMSMessagePoller.run(NewJMSMessagePoller.java:120)

        at weblogic.ejb.container.internal.NewJMSMessagePoller.timerExpired(NewJMSMessagePoller.java:236)

        at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:272)

        at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)

        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

      Caused by: oracle.jbo.service.errors.ServiceException: JBO-26030: Failed to lock the record, another user holds the lock.

        at oracle.jbo.service.errors.ServiceExceptionHelper.extractServiceException(ServiceExceptionHelper.java:613)

        at oracle.jbo.server.svc.ServiceJTATxnHandlerImpl.beforeCompletion(ServiceJTATxnHandlerImpl.java:199)

        at sun.reflect.GeneratedMethodAccessor4167.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at oracle.jbo.server.svc.WLSContextCrossAppProxy$WLSCrossAppProxy$ServiceJTAAction.run(WLSContextCrossAppProxy.java:125)

        at javax.security.auth.Subject.doAsPrivileged(Subject.java:452)

        at oracle.jbo.server.svc.WLSContextCrossAppProxy$WLSCrossAppProxy.invoke(WLSContextCrossAppProxy.java:85)

        at com.sun.proxy.$Proxy217.beforeCompletion(Unknown Source)

        at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1244)

        at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1219)

        at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:121)

        at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1355)

        at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2172)

        at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:300)

        at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:267)

        at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:625)

        at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:49)

        at weblogic.ejb.container.internal.BaseRemoteObject.__WL_postInvokeTxRetry(BaseRemoteObject.java:444)

        at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:53)

        at oracle.apps.hcm.compensation.watchlistService.model.applicationModule.server.CompensationWatchlistServiceImpl_rkivyt_CompensationWatchlistServiceImpl.refreshWatchlistCategoryAsync(Unknown Source)

        at sun.reflect.GeneratedMethodAccessor7451.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)

        at com.sun.proxy.$Proxy164.refreshWatchlistCategoryAsync(Unknown Source)

        at sun.reflect.GeneratedMethodAccessor7450.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:371)

        at oracle.j2ee.ws.server.jaxws.ServiceEndpointRuntime.processMessage(ServiceEndpointRuntime.java:203)

        at oracle.j2ee.ws.server.jaxws.AsyncRequestProcessor.getResponse(AsyncRequestProcessor.java:187)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.processMessage(AsyncMessageProcessor.java:306)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.access$100(AsyncMessageProcessor.java:80)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor$1.run(AsyncMessageProcessor.java:236)

        at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

        at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74)

        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:242)

        at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83)

        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)

        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)

        at weblogic.security.Security.runAs(Security.java:61)

        at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:51)

        at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:56)

        at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:242)

        at oracle.j2ee.ws.server.provider.GenericProviderPlatform.runAs(GenericProviderPlatform.java:426)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.onMessage(AsyncMessageProcessor.java:255)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.onMessage(AsyncMessageProcessor.java:184)

        at oracle.j2ee.ws.server.jaxws.AsyncMessageProcessor.onMessage(AsyncMessageProcessor.java:164)

        at oracle.j2ee.ws.server.jaxws.AsyncRequestProcessorMDB.onMessage(AsyncRequestProcessorMDB.java:125)

        at sun.reflect.GeneratedMethodAccessor4004.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.oracle.pitchfork.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:103)

        at oracle.jbo.server.svc.ServiceContextInterceptor.removeCurrentADFContext(ServiceContextInterceptor.java:136)

        at sun.reflect.GeneratedMethodAccessor2443.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.oracle.pitchfork.intercept.JeeInterceptorInterceptor.invoke(JeeInterceptorInterceptor.java:68)

        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 com.sun.proxy.$Proxy213.onMessage(Unknown Source)

        at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583)

        at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486)

        at weblogic.ejb.container.internal.NewJMSMessagePoller.processOneMessage(NewJMSMessagePoller.java:282)

        at weblogic.ejb.container.internal.NewJMSMessagePoller.run(NewJMSMessagePoller.java:120)

        at weblogic.ejb.container.internal.NewJMSMessagePoller.timerExpired(NewJMSMessagePoller.java:235)

        ... 4 more

       

       

      PS: And this issue could only reproduce on ENV(with SOA), can not reproduce on Local Env(Without SOA)

       

      Any one can provide the suggestions of this issue?

      Many thanks.

      Orvin

        1 2 Previous Next