0 Replies Latest reply on Nov 6, 2017 3:42 PM by nagendragupta

    ISPN000136: Execution error: java.lang.IllegalStateException: Transaction TransactionImple < ac, BasicAction: 0:ffffac1d71c8:472497a4:59ea3bdb:5b996 status: ActionStatus.ABORT_ONLY

    nagendragupta
    nagendragupta Nov 6, 2017 3:42 PM

      I am facing issue exactly when i am trying to hit a "Cacheable Named query".  Below is the complete stack trace

       

       

      2017-10-26 16:32:19 ERROR [org.infinispan.interceptors.InvocationContextInterceptor] (default-threads - 26) ISPN000136: Execution error: java.lang.IllegalStateException: Transaction TransactionImple < ac, BasicAction: 0:ffffac1d71c8:472497a4:59ea3bdb:5bab7 status: ActionStatus.ABORT_ONLY > is not in a valid state to be invoking cache operations on.

      at org.infinispan.interceptors.TxInterceptor.enlist(TxInterceptor.java:272)

      at org.infinispan.interceptors.TxInterceptor.enlistIfNeeded(TxInterceptor.java:236)

      at org.infinispan.interceptors.TxInterceptor.enlistReadAndInvokeNext(TxInterceptor.java:230)

      at org.infinispan.interceptors.TxInterceptor.visitGetKeyValueCommand(TxInterceptor.java:226)

      at org.infinispan.commands.read.GetKeyValueCommand.acceptVisitor(GetKeyValueCommand.java:58)

      at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)

      at org.infinispan.interceptors.CacheMgmtInterceptor.visitGetKeyValueCommand(CacheMgmtInterceptor.java:92)

      at org.infinispan.commands.read.GetKeyValueCommand.acceptVisitor(GetKeyValueCommand.java:58)

      at org.infinispan.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:120)

      at org.infinispan.interceptors.InvocationContextInterceptor.handleAll(InvocationContextInterceptor.java:128)

      at org.infinispan.interceptors.InvocationContextInterceptor.handleDefault(InvocationContextInterceptor.java:92)

      at org.infinispan.commands.AbstractVisitor.visitGetKeyValueCommand(AbstractVisitor.java:104)

      at org.infinispan.commands.read.GetKeyValueCommand.acceptVisitor(GetKeyValueCommand.java:58)

      at org.infinispan.interceptors.InterceptorChain.invoke(InterceptorChain.java:343)

      at org.infinispan.CacheImpl.get(CacheImpl.java:289)

      at org.infinispan.CacheImpl.get(CacheImpl.java:281)

      at org.infinispan.AbstractDelegatingCache.get(AbstractDelegatingCache.java:303)

      at org.hibernate.cache.infinispan.access.TransactionalAccessDelegate.get(TransactionalAccessDelegate.java:67) [hibernate-infinispan-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.cache.infinispan.entity.TransactionalAccess.get(TransactionalAccess.java:36) [hibernate-infinispan-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.event.internal.DefaultLoadEventListener.loadFromSecondLevelCache(DefaultLoadEventListener.java:550) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:421) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:206) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:262) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:150) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1098) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1025) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:671) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.type.ManyToOneType.assemble(ManyToOneType.java:280) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.cache.internal.StandardQueryCache.get(StandardQueryCache.java:161) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.loader.Loader.getResultFromQueryCache(Loader.java:2453) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.loader.Loader.list(Loader.java:2334) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1275) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) [hibernate-core-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268) [hibernate-entitymanager-4.2.7.SP1-redhat-3.jar:4.2.7.SP1-redhat-3]

      at org.jboss.as.jpa.container.QueryNonTxInvocationDetacher.getResultList(QueryNonTxInvocationDetacher.java:58) [jboss-as-jpa-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]

      at com.unisys.trans.logistics.lms.framework.dao.ParameterStoreJpaDaoImpl.findParameterByMultiSearchCriteria(ParameterStoreJpaDaoImpl.java:60)