TransactionImple.enlistResource error with Oracle

64 views
Skip to first unread message

chandan shrivastava

unread,
Jul 17, 2020, 4:19:19 AM7/17/20
to narayana-users
I am struggling with an error since last few months where I am not able to use JBPM's spring boot business application with Oracle 12.2.0.1 database. The same application works fine with MySQL Db.
The error I am facing is exactly similar to the one highlighted by the gentleman in the link below :  


I am desperately hoping that some one among you would have found a solution to it and would be kind enough to share it with me.

Thanks,
Chandan

Error Trace : 
2020-07-17 02:42:10.602  WARN 15088 --- [0.0-8090-exec-1] com.arjuna.ats.jta                       : ARJUNA016061: TransactionImple.enlistResource - XAResource.start returned: XAException.XAER_PROTO for < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffc0a80035:d196:5f10c26a:54, node_name=1, branch_uid=0:ffffc0a80035:d196:5f10c26a:57, subordinatenodename=null, eis_name=0 >
oracle.jdbc.xa.OracleXAException: XAErr (-6): Routine was invoked in an inproper context. ORA-24776 SQLErr (0)
 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1112) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:265) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at com.arjuna.ats.internal.jdbc.IsSameRMOverrideXAResource.start(IsSameRMOverrideXAResource.java:66) ~[jdbc-5.9.0.Final.jar!/:5.9.0.Final]
 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:662) ~[jta-5.9.0.Final.jar!/:5.9.0.Final]
 at com.arjuna.ats.internal.jdbc.ConnectionImple.registerDatabase(ConnectionImple.java:940) ~[jdbc-5.9.0.Final.jar!/:5.9.0.Final]
 at com.arjuna.ats.internal.jdbc.ConnectionImple.prepareStatement(ConnectionImple.java:173) ~[jdbc-5.9.0.Final.jar!/:5.9.0.Final]
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:87) ~[hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:72) ~[hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:94) ~[hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.id.enhanced.PooledOptimizer.generate(PooledOptimizer.java:73) ~[hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:412) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.jpa.event.internal.core.JpaPersistEventListener.saveWithGeneratedId(JpaPersistEventListener.java:67) [hibernate-entitymanager-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:189) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:132) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:58) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:775) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:748) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:753) [hibernate-core-5.0.12.Final.jar!/:5.0.12.Final]
 at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1146) [hibernate-entitymanager-5.0.12.Final.jar!/:5.0.12.Final]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_112]
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_112]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_112]
 at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_112]
 at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:347) [spring-orm-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at com.sun.proxy.$Proxy126.persist(Unknown Source) [na:na]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_112]
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_112]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_112]
 at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_112]
 at org.kie.spring.persistence.AbstractKieSpringJpaManager$EmHolderDelegateInvocationHandler.invoke(AbstractKieSpringJpaManager.java:144) [kie-spring-7.14.0.Final.jar!/:7.14.0.Final]
 at com.sun.proxy.$Proxy141.persist(Unknown Source) [na:na]
 at org.jbpm.persistence.JpaProcessPersistenceContext.persist(JpaProcessPersistenceContext.java:56) [jbpm-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.persistence.processinstance.JPAProcessInstanceManager.addProcessInstance(JPAProcessInstanceManager.java:85) [jbpm-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.process.instance.AbstractProcessInstanceFactory.createProcessInstance(AbstractProcessInstanceFactory.java:47) [jbpm-flow-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:260) [jbpm-flow-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.process.instance.ProcessRuntimeImpl.createProcessInstance(ProcessRuntimeImpl.java:242) [jbpm-flow-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:225) [jbpm-flow-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:1906) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.command.runtime.process.StartCorrelatedProcessCommand.execute(StartCorrelatedProcessCommand.java:146) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.command.runtime.process.StartCorrelatedProcessCommand.execute(StartCorrelatedProcessCommand.java:44) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.fluent.impl.PseudoClockRunner.executeBatch(PseudoClockRunner.java:102) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.fluent.impl.PseudoClockRunner.executeBatches(PseudoClockRunner.java:69) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.fluent.impl.PseudoClockRunner.execute(PseudoClockRunner.java:61) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.fluent.impl.PseudoClockRunner.execute(PseudoClockRunner.java:39) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.PersistableRunner$TransactionInterceptor.execute(PersistableRunner.java:597) [drools-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.PersistableRunner$TransactionInterceptor.execute(PersistableRunner.java:563) [drools-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.internalExecute(OptimisticLockRetryInterceptor.java:102) [drools-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:83) [drools-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:44) [drools-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-api-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:45) [drools-persistence-api-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.internalExecute(ExecutionErrorHandlerInterceptor.java:66) [jbpm-runtime-manager-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.execute(ExecutionErrorHandlerInterceptor.java:52) [jbpm-runtime-manager-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.runtime.manager.impl.error.ExecutionErrorHandlerInterceptor.execute(ExecutionErrorHandlerInterceptor.java:29) [jbpm-runtime-manager-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.PersistableRunner.execute(PersistableRunner.java:398) [drools-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.persistence.PersistableRunner.execute(PersistableRunner.java:66) [drools-persistence-jpa-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:37) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:41) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:566) [drools-core-7.14.0.Final.jar!/:7.14.0.Final]
 at org.jbpm.kie.services.impl.ProcessServiceImpl.startProcess(ProcessServiceImpl.java:144) [jbpm-kie-services-7.14.0.Final.jar!/:7.14.0.Final]
 at org.kie.server.services.jbpm.ProcessServiceBase.startProcessWithCorrelation(ProcessServiceBase.java:115) [kie-server-services-jbpm-7.14.0.Final.jar!/:7.14.0.Final]
 at org.kie.server.remote.rest.jbpm.ProcessResource.startProcessWithCorrelation(ProcessResource.java:200) [kie-server-rest-jbpm-7.14.0.Final.jar!/:7.14.0.Final]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_112]
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_112]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_112]
 at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_112]
 at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) [cxf-core-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) [cxf-core-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:189) [cxf-rt-frontend-jaxrs-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99) [cxf-rt-frontend-jaxrs-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) [cxf-core-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) [cxf-core-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308) [cxf-core-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-core-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:262) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:299) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:218) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:274) [cxf-rt-transports-http-3.1.11.jar!/:3.1.11]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-embed-websocket-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) [spring-security-web-4.2.5.RELEASE.jar!/:4.2.5.RELEASE]
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.16.RELEASE.jar!/:4.3.16.RELEASE]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_112]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_112]
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.29.jar!/:8.5.29]
 at java.lang.Thread.run(Unknown Source) [na:1.8.0_112]
Caused by: java.sql.SQLException: ORA-24776: cannot start a new transaction
 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:441) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:436) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1061) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.driver.T4CTTIOtxse.doOTXSE(T4CTTIOtxse.java:166) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.driver.T4CXAResource.doStart(T4CXAResource.java:207) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:260) ~[ojdbc8-12.2.0.1.jar!/:12.2.0.1.0]
 ... 160 common frames omitted

jhal...@redhat.com

unread,
Jul 17, 2020, 6:29:07 AM7/17/20
to narayana-users
The Oracle JDBC driver is notoriously fussy about switching between modes (NO_TXN/LOCAL_TXN/GLOBAL_TXN) to the extent that JBoss connection pooling introduced no-tx-separate-pools to work around it. Depending how you're doing connection management, you may need to take similar precautions, or just use wildfly.

Regards

Jonathan

chandan shrivastava

unread,
Jul 20, 2020, 7:56:40 AM7/20/20
to jhal...@redhat.com, narayana-users
Thanks Jonathan for your response. I am using JBPM spring boot
business application.
This app is generated by using the link : https://start.jbpm.org
I am using version :
<version.org.kie>7.14.0.Final</version.org.kie>

I have only changed default appliation.properites files to point to my
oracle instance. Have treid with odbc7, odbc8 and ucp.jar too but all
results in the same problem. I have been suggested in some other blog
to use <is-same-rm-override>false</is-same-rm-override>

This property works for business central but as I am using custom
services too I need biz application.

I have attached application.properties currently in use.
Would you be able to point me to some thing more specific in spring
boot app context.

Thanks,
Chandan
> --
> You received this message because you are subscribed to the Google Groups
> "narayana-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to narayana-user...@googlegroups.com.
> To view this discussion on the web, visit
> https://groups.google.com/d/msgid/narayana-users/debcf6cc-5f96-4263-8e26-c02c6ec82aaan%40googlegroups.com.
>
application.properties

Michael Musgrove

unread,
Jul 22, 2020, 11:55:06 AM7/22/20
to narayana-users
As Jonathan pointed out this ORA error (24776) occurs when you use local and global transactions on the same connection and some drivers are more picky/spec compliant than others.

Are you sure you are closing the local transaction by either using setAutoCommit(true) or by explicitly committing/rolling back the connection.

Your properties file show that you are using the thin driver (jdbc:oracle:thin:@localhost:32769:ORCLCDB). Would it be possible for you to also try using the non thin driver (Oracle OCI JDBC) since the two drivers seem to use different XA APIs (native and non-native: https://docs.oracle.com/cd/E11882_01/java.112/e16548/xadistra.htm#JJDBC28873).
Reply all
Reply to author
Forward
0 new messages