2 Replies Latest reply on Feb 26, 2015 5:58 AM by WASIL

    Transaction deadlock

    kuopching Level 1

      Hi, we're experience deadlocks on our production server(log below). Basically we have jsf application to serve Long-lived process running on alc and from time to time these deadlocks occur. Can you give me some advice how to prevent/remove these errors? Has anyone similar experiences with such behavior?

      Please ASAP. Thank You

       

      Configuration:

       

      Adobe livecycle ES3(Version: 10.0.2) Service Pack Version: SP2

       

      JDK/JRE 1.6.0_26

       

      Jboss 5.1

       

      MSSQL server 11.0.3000

       

      <pre>

       

      09:02:31,852 ERROR LogInterceptor:419 - TransactionRolledbackLocalException in method: public abstract com.adobe.pof.omapi.POFObjectSet com.adobe.pof.omapi.POFObjectManagerLocal.retrieveObjectSet(com.adobe.pof.omapi.POFQuery, int,int,com.adobe.idp.Context) throws com.adobe.pof.POFException, causedBy:

       

      com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 102) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

       

         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException. java:197)

       

         at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.ja va:4762)

       

         at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1 682)

       

         at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:955)

       

         at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1196)

       

         at com.adobe.pof.adapter.sqlserver.SQLServer7Adapter.retrieveObjectSet(SQLServer7Adapter.jav a:629)

       

         at com.adobe.pof.omapi.POFObjectManagerImpl.retrieveObjectSet(POFObjectManagerImpl.java:154)

       

         at com.adobe.pof.omapi.POFObjectManagerRemoteBean.retrieveObjectSet(POFObjectManagerRemoteBe an.java:228)

       

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

       

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

       

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

       

         at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

       

         at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionConta iner.java:233)

       

         at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionI nterceptor.java:156)

       

         at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstance Interceptor.java:173)

       

         at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

       

         at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

       

         at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

       

         at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

       

         at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)

       

         at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

       

         at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java :97)

       

         at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java: 81)

       

         at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

       

         at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor. java:138)

       

         at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

       

         at org.jboss.ejb.Container.invoke(Container.java:1092)

       

         at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

       

         at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

       

         at $Proxy688.retrieveObjectSet(Unknown Source)

       

         at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet(POFObjectManagerLoc alEJBAdapter.java:115)

       

         at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet(POFObjectManagerAbs tractAdapter.java:481)

       

         at com.adobe.idp.taskmanager.dsc.util.UnmodifiableObjectManager.retrieveObjectSet(Unmodifiab leObjectManager.java:370)

       

         at com.adobe.idp.taskmanager.dsc.service.TaskManagerServiceImpl.getUsersWithAccess(TaskManag erServiceImpl.java:2596)

       

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

       

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

       

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

       

         at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:118)

       

         at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(InvocationInterceptor. java:140)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.intercept(DocumentPassi vationInterceptor.java:53)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.doInTransaction(Transa ctionInterceptor.java:74)

       

         at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.execute(EjbTr ansactionCMTAdapterBean.java:357)

       

         at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.doRequiresNew (EjbTransactionCMTAdapterBean.java:299)

       

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

       

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

       

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

       

         at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

       

         at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionConta iner.java:233)

       

         at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionI nterceptor.java:156)

       

         at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstance Interceptor.java:173)

       

         at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

       

         at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

       

         at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:404)

       

         at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

       

         at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)

       

         at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

       

         at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java :97)

       

         at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java: 81)

       

         at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

       

         at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor. java:138)

       

         at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

       

         at org.jboss.ejb.Container.invoke(Container.java:1092)

       

         at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

       

         at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

       

         at $Proxy632.doRequiresNew(Unknown Source)

       

         at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute(EjbTransactionProvi der.java:143)

       

         at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.intercept(TransactionInt erceptor.java:72)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.intercept(InvocationStra tegyInterceptor.java:55)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept(InvalidStateIntercep tor.java:37)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept(AuthorizationInterc eptor.java:165)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterceptor.java:48)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineImpl.java:121)

       

         at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:131)

       

         at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMessage(AbstractMessage Receiver.java:93)

       

         at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:22 5)

       

         at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(AbstractMessageDispat cher.java:66)

       

         at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:208)

       

         at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerService.invokeWithRetry2(TypedTaskMa nagerService.java:186)

       

         at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerService.invokeWithRetry(TypedTaskMan agerService.java:174)

       

         at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerService.getUsersWithAccessToTask(Typ edTaskManagerService.java:1357)

       

         at com.adobe.livecycle.processmanagement.events.TaskEvent$UsersWithAccessHolder.invoke(TaskE vent.java:364)

       

         at com.adobe.livecycle.processmanagement.events.TaskEvent$UsersWithAccessHolder.invoke(TaskE vent.java:339)

       

         at com.adobe.livecycle.processmanagement.events.TaskEvent.handleUpdateEvent(TaskEvent.java:1 23)

       

         at com.adobe.livecycle.processmanagement.events.TaskFormDataSaved.handleEvent(TaskFormDataSa ved.java:27)

       

         at com.adobe.livecycle.processmanagement.events.ProcessManagementEventProcessor.start(Proces sManagementEventProcessor.java:78)

       

         at com.adobe.livecycle.processmanagement.services.ProcessManagementEventService.onAsynchrono usEvent(ProcessManagementEventService.java:96)

       

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

       

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

       

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

       

         at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:118)

       

         at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(InvocationInterceptor. java:140)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.intercept(DocumentPassi vationInterceptor.java:53)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.doInTransaction(Transa ctionInterceptor.java:74)

       

         at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.execute(EjbTr ansactionCMTAdapterBean.java:357)

       

         at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.doSupports(Ej bTransactionCMTAdapterBean.java:227)

       

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

       

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

       

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

       

         at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

       

         at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionConta iner.java:233)

       

         at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionI nterceptor.java:156)

       

         at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstance Interceptor.java:173)

       

         at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

       

         at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

       

         at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:378)

       

         at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

       

         at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)

       

         at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

       

         at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java :97)

       

         at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java: 81)

       

         at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

       

         at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor. java:138)

       

         at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

       

         at org.jboss.ejb.Container.invoke(Container.java:1092)

       

         at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

       

         at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

       

         at $Proxy632.doSupports(Unknown Source)

       

         at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute(EjbTransactionProvi der.java:104)

       

         at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.intercept(TransactionInt erceptor.java:72)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.intercept(InvocationStra tegyInterceptor.java:55)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept(InvalidStateIntercep tor.java:37)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept(AuthorizationInterc eptor.java:165)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterceptor.java:48)

       

         at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

       

         at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineImpl.java:121)

       

         at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:131)

       

         at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMessage(AbstractMessage Receiver.java:93)

       

         at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:19 8)

       

         at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(AbstractMessageDispat cher.java:66)

       

         at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:208)

       

         at com.adobe.idp.dsc.workmanager.DefaultInvocableServiceUnit.execute(DefaultInvocableService Unit.java:75)

       

         at com.adobe.idp.dsc.workmanager.adapter.ManagedAsynchronousWorkAdapter.run(ManagedAsynchron ousWorkAdapter.java:70)

       

         at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205)

       

         at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)

       

         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:662)

       

      </pre>

        • 1. Re: Transaction deadlock
          kuopching Level 1

          Well, I feel one week is enough time for someone competent to comment on this error. Maybe I'm naive, but I would have expected from companies such as Adobe, that it will behave with due respect to their most well paying customer... shame

          Anyway,from my last comment, another exceptions appeared:

           

           

          08:01:38,153 ERROR LogInterceptor:419 - RuntimeException in method: public abstract com.adobe.pof.omapi.POFObjectSet com.adobe.pof.omapi.POFObjectManagerLocal.retrieveObjectSet(com.adobe.pof.omapi.POFQuery, int,int,com.adobe.idp.Context) throws com.adobe.pof.POFException:

          com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 92) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

             at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException. java:197)

             at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.ja va:4762)

             at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1 682)

             at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:955)

             at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1196)

             at com.adobe.pof.adapter.sqlserver.SQLServer7Adapter.retrieveObjectSet(SQLServer7Adapter.jav a:629)

             at com.adobe.pof.omapi.POFObjectManagerImpl.retrieveObjectSet(POFObjectManagerImpl.java:154)

             at com.adobe.pof.omapi.POFObjectManagerRemoteBean.retrieveObjectSet(POFObjectManagerRemoteBe an.java:228)

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

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

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

             at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

             at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionConta iner.java:233)

             at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionI nterceptor.java:156)

             at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstance Interceptor.java:173)

             at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

             at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

             at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

             at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

             at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)

             at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

             at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java :97)

             at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java: 81)

             at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

             at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor. java:138)

             at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

             at org.jboss.ejb.Container.invoke(Container.java:1092)

             at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

             at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

             at $Proxy688.retrieveObjectSet(Unknown Source)

             at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet(POFObjectManagerLoc alEJBAdapter.java:115)

             at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet(POFObjectManagerAbs tractAdapter.java:481)

             at com.adobe.idp.taskmanager.dsc.util.UnmodifiableObjectManager.retrieveObjectSet(Unmodifiab leObjectManager.java:370)

             at com.adobe.idp.taskmanager.dsc.queryservice.TaskManagerQueryServiceImpl.taskSearch(TaskMan agerQueryServiceImpl.java:759)

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

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

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

             at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:118)

             at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(InvocationInterceptor. java:140)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.intercept(DocumentPassi vationInterceptor.java:53)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.doInTransaction(Transa ctionInterceptor.java:74)

             at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.execute(EjbTr ansactionCMTAdapterBean.java:357)

             at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.doSupports(Ej bTransactionCMTAdapterBean.java:227)

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

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

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

             at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

             at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionConta iner.java:233)

             at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionI nterceptor.java:156)

             at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstance Interceptor.java:173)

             at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

             at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

             at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:378)

             at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

             at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)

             at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

             at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java :97)

             at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java: 81)

             at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

             at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor. java:138)

             at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

             at org.jboss.ejb.Container.invoke(Container.java:1092)

             at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

             at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

             at $Proxy632.doSupports(Unknown Source)

             at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute(EjbTransactionProvi der.java:104)

             at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.intercept(TransactionInt erceptor.java:72)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.intercept(InvocationStra tegyInterceptor.java:55)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept(InvalidStateIntercep tor.java:37)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept(AuthorizationInterc eptor.java:165)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterceptor.java:48)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineImpl.java:121)

             at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:131)

             at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMessage(AbstractMessage Receiver.java:93)

             at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:22 5)

             at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(AbstractMessageDispat cher.java:66)

             at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:208)

             at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.invokeWithRetry(TypedTa skManagerQueryService.java:106)

             at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.taskSearch(TypedTaskMan agerQueryService.java:292)

             at com.adobe.livecycle.processmanagement.events.TaskEvent.getTaskRow(TaskEvent.java:277)

             at com.adobe.livecycle.processmanagement.events.TaskEvent.handleUpdateEvent(TaskEvent.java:1 28)

             at com.adobe.livecycle.processmanagement.events.TaskFormDataSaved.handleEvent(TaskFormDataSa ved.java:27)

             at com.adobe.livecycle.processmanagement.events.ProcessManagementEventProcessor.start(Proces sManagementEventProcessor.java:78)

             at com.adobe.livecycle.processmanagement.services.ProcessManagementEventService.onAsynchrono usEvent(ProcessManagementEventService.java:96)

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

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

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

             at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:118)

             at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(InvocationInterceptor. java:140)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.intercept(DocumentPassi vationInterceptor.java:53)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.doInTransaction(Transa ctionInterceptor.java:74)

             at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.execute(EjbTr ansactionCMTAdapterBean.java:357)

             at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.doSupports(Ej bTransactionCMTAdapterBean.java:227)

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

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

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

             at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

             at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionConta iner.java:233)

             at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionI nterceptor.java:156)

             at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstance Interceptor.java:173)

             at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

             at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

             at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:378)

             at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

             at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)

             at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

             at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java :97)

             at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java: 81)

             at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

             at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor. java:138)

             at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

             at org.jboss.ejb.Container.invoke(Container.java:1092)

             at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

             at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

             at $Proxy632.doSupports(Unknown Source)

             at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute(EjbTransactionProvi der.java:104)

             at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.intercept(TransactionInt erceptor.java:72)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.intercept(InvocationStra tegyInterceptor.java:55)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept(InvalidStateIntercep tor.java:37)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept(AuthorizationInterc eptor.java:165)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterceptor.java:48)

             at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)

             at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineImpl.java:121)

             at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:131)

             at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMessage(AbstractMessage Receiver.java:93)

             at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:19 8)

             at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(AbstractMessageDispat cher.java:66)

             at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:208)

             at com.adobe.idp.dsc.workmanager.DefaultInvocableServiceUnit.execute(DefaultInvocableService Unit.java:75)

             at com.adobe.idp.dsc.workmanager.adapter.ManagedAsynchronousWorkAdapter.run(ManagedAsynchron ousWorkAdapter.java:70)

             at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205)

             at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)

             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:662)

          • 2. Re: Transaction deadlock
            WASIL Adobe Employee

            You need to make sure that you have set correct transaction isolation level on the SQL Server. This is already there in the installation document : http://help.adobe.com/en_US/livecycle/11.0/PrepareInstallCluster/WS624e3cba99b79e12-38fb9c 7e12eea97fd78-7fb5.2.html#WS624e3cba99b79e125803425a12eea97f5c7-7fe3.2

             

            -Wasil