ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object
mirela-roksandic-b846361 Nov 18, 2015 9:54 AMHI All,
Im doing insert to Oracle database, two schemas and two tables, I have created two XA datasources in Jboss 6.3.2, with same URL but different users,
For each call I create new transaction, and what happens is that sometimes (aproximatly half the time) i get this error.
Tried all kinds of solution - setting Pad Xid to false, adding <no-tx-separate-pools/> tag inside <xa-pool>, increasing number of minimum connections etc.
I tried also to work with only one datasource, and only one method, and this error happend no matter that.
I don't know what else to do.
Exception stack trace:
[#|2015-11-18 10:32:59,810|WARN |[com.arjuna.ats.jta]|(ThreadId: sc-http-executor-threads - 89)|ARJUNA016061: TransactionImple.enlistResource - XAResource.start returned: XAException.XAER_RMFAIL for < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffac1564ab:-422f4503:56435b24:16de29bc, node_name=1, branch_uid=0:ffffac1564ab:-422f4503:56435b24:16de2a59, subordinatenodename=null, eis_name=unknown eis name >: oracle.jdbc.xa.OracleXAException at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1188) at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:253) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:646) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:407) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:704) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:350) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:483) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:626) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:494) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:890) at com.ericsson.iptv.portal.avalanche.tt.rr.iap.RegulatoryRatingBean.saveChannelRatingEvents(RegulatoryRatingBean.java:196) at com.ericsson.iptv.portal.avalanche.tt.rr.iap.RegulatoryRatingBean.sendChannelEvents(RegulatoryRatingBean.java:320) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_85] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_85] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_85] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_85] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy2054.sendChannelEvents(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_85] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_85] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_85] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_85] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:78) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:68) at com.ericsson.iptv.portal.fw.cors.AbstractCorsRequestFilter.doFilter(AbstractCorsRequestFilter.java:130) at com.ericsson.iptv.portal.iap.cors.CorsRequestFilter.doFilter(CorsRequestFilter.java:55) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalFilter(ServletFilterManager.java:79) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalPerformAction(ServletFilterManager.java:89) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:76) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:68) at com.ericsson.iptv.portal.fw.backend.gzip.GZIPServletFilter.doFilter(GZIPServletFilter.java:88) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.backend.startup.DisableDirectoryListings.doFilter(DisableDirectoryListings.java:114) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.backend.cache.StaticDataCacheControl.doFilter(StaticDataCacheControl.java:83) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalFilter(ServletFilterManager.java:79) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalPerformAction(ServletFilterManager.java:89) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:76) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter.doFilter(PortalServletFilter.java:93) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:832) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:620) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:553) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:482) at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.internalForwardRequest(ArtifactBase.java:325) at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.internalPerformAction(ArtifactBase.java:351) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$4.invokeOn(MBeanManagerBase.java:619) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.invokeOnSingleManager(MBeanManagerBase.java:514) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.broadcast(MBeanManagerBase.java:616) at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.forwardRequest(ArtifactBase.java:424) at com.ericsson.iptv.portal.proxy.ProxyServlet.service(ProxyServlet.java:130) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91) at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:559) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:876) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:607) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2505) at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:849) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_85] at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] |#] [#|2015-11-18 10:32:59,812|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)|oracle.jdbc.xa.OracleXAException|#] [#|2015-11-18 10:32:59,812|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1188)|#] [#|2015-11-18 10:32:59,813|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:253)|#] [#|2015-11-18 10:32:59,813|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)|#] [#|2015-11-18 10:32:59,814|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:646)|#] [#|2015-11-18 10:32:59,814|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:407)|#] [#|2015-11-18 10:32:59,815|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:704)|#] [#|2015-11-18 10:32:59,815|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:350)|#] [#|2015-11-18 10:32:59,816|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:483)|#] [#|2015-11-18 10:32:59,816|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:626)|#] [#|2015-11-18 10:32:59,816|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:494)|#] [#|2015-11-18 10:32:59,817|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)|#] [#|2015-11-18 10:32:59,817|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)|#] [#|2015-11-18 10:32:59,818|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)|#] [#|2015-11-18 10:32:59,818|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575)|#] [#|2015-11-18 10:32:59,819|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)|#] [#|2015-11-18 10:32:59,819|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:890)|#] [#|2015-11-18 10:32:59,820|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.avalanche.tt.rr.iap.RegulatoryRatingBean.saveChannelRatingEvents(RegulatoryRatingBean.java:196)|#] [#|2015-11-18 10:32:59,820|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.avalanche.tt.rr.iap.RegulatoryRatingBean.sendChannelEvents(RegulatoryRatingBean.java:320)|#] [#|2015-11-18 10:32:59,820|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|#] [#|2015-11-18 10:32:59,821|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)|#] [#|2015-11-18 10:32:59,821|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)|#] [#|2015-11-18 10:32:59,822|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at java.lang.reflect.Method.invoke(Method.java:606)|#] [#|2015-11-18 10:32:59,822|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)|#] [#|2015-11-18 10:32:59,823|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)|#] [#|2015-11-18 10:32:59,823|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)|#] [#|2015-11-18 10:32:59,824|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)|#] [#|2015-11-18 10:32:59,824|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)|#] [#|2015-11-18 10:32:59,825|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)|#] [#|2015-11-18 10:32:59,826|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)|#] [#|2015-11-18 10:32:59,826|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)|#] [#|2015-11-18 10:32:59,826|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.sun.proxy.$Proxy2054.sendChannelEvents(Unknown Source)|#] [#|2015-11-18 10:32:59,827|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)|#] [#|2015-11-18 10:32:59,827|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)|#] [#|2015-11-18 10:32:59,828|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)|#] [#|2015-11-18 10:32:59,828|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at java.lang.reflect.Method.invoke(Method.java:606)|#] [#|2015-11-18 10:32:59,829|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)|#] [#|2015-11-18 10:32:59,829|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)|#] [#|2015-11-18 10:32:59,830|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)|#] [#|2015-11-18 10:32:59,830|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)|#] [#|2015-11-18 10:32:59,830|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)|#] [#|2015-11-18 10:32:59,831|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)|#] [#|2015-11-18 10:32:59,831|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)|#] [#|2015-11-18 10:32:59,832|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)|#] [#|2015-11-18 10:32:59,832|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)|#] [#|2015-11-18 10:32:59,833|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855)|#] [#|2015-11-18 10:32:59,833|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)|#] [#|2015-11-18 10:32:59,834|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)|#] [#|2015-11-18 10:32:59,834|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)|#] [#|2015-11-18 10:32:59,835|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)|#] [#|2015-11-18 10:32:59,835|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)|#] [#|2015-11-18 10:32:59,835|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:78)|#] [#|2015-11-18 10:32:59,836|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:68)|#] [#|2015-11-18 10:32:59,836|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.cors.AbstractCorsRequestFilter.doFilter(AbstractCorsRequestFilter.java:130)|#] [#|2015-11-18 10:32:59,837|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.iap.cors.CorsRequestFilter.doFilter(CorsRequestFilter.java:55)|#] [#|2015-11-18 10:32:59,837|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66)|#] [#|2015-11-18 10:32:59,838|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalFilter(ServletFilterManager.java:79)|#] [#|2015-11-18 10:32:59,838|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalPerformAction(ServletFilterManager.java:89)|#] [#|2015-11-18 10:32:59,838|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534)|#] [#|2015-11-18 10:32:59,839|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547)|#] [#|2015-11-18 10:32:59,839|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544)|#] [#|2015-11-18 10:32:59,840|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317)|#] [#|2015-11-18 10:32:59,840|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:76)|#] [#|2015-11-18 10:32:59,841|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:68)|#] [#|2015-11-18 10:32:59,841|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.backend.gzip.GZIPServletFilter.doFilter(GZIPServletFilter.java:88)|#] [#|2015-11-18 10:32:59,842|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66)|#] [#|2015-11-18 10:32:59,842|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.backend.startup.DisableDirectoryListings.doFilter(DisableDirectoryListings.java:114)|#] [#|2015-11-18 10:32:59,842|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66)|#] [#|2015-11-18 10:32:59,843|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.backend.cache.StaticDataCacheControl.doFilter(StaticDataCacheControl.java:83)|#] [#|2015-11-18 10:32:59,843|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66)|#] [#|2015-11-18 10:32:59,844|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalFilter(ServletFilterManager.java:79)|#] [#|2015-11-18 10:32:59,844|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalPerformAction(ServletFilterManager.java:89)|#] [#|2015-11-18 10:32:59,845|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534)|#] [#|2015-11-18 10:32:59,845|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547)|#] [#|2015-11-18 10:32:59,846|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544)|#] [#|2015-11-18 10:32:59,846|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317)|#] [#|2015-11-18 10:32:59,847|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:76)|#] [#|2015-11-18 10:32:59,847|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter.doFilter(PortalServletFilter.java:93)|#] [#|2015-11-18 10:32:59,847|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)|#] [#|2015-11-18 10:32:59,848|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)|#] [#|2015-11-18 10:32:59,849|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:832)|#] [#|2015-11-18 10:32:59,849|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:620)|#] [#|2015-11-18 10:32:59,849|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:553)|#] [#|2015-11-18 10:32:59,850|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:482)|#] [#|2015-11-18 10:32:59,850|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.internalForwardRequest(ArtifactBase.java:325)|#] [#|2015-11-18 10:32:59,851|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.internalPerformAction(ArtifactBase.java:351)|#] [#|2015-11-18 10:32:59,851|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534)|#] [#|2015-11-18 10:32:59,852|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547)|#] [#|2015-11-18 10:32:59,852|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544)|#] [#|2015-11-18 10:32:59,853|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317)|#] [#|2015-11-18 10:32:59,853|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$4.invokeOn(MBeanManagerBase.java:619)|#] [#|2015-11-18 10:32:59,854|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.invokeOnSingleManager(MBeanManagerBase.java:514)|#] [#|2015-11-18 10:32:59,854|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.broadcast(MBeanManagerBase.java:616)|#] [#|2015-11-18 10:32:59,855|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.forwardRequest(ArtifactBase.java:424)|#] [#|2015-11-18 10:32:59,855|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at com.ericsson.iptv.portal.proxy.ProxyServlet.service(ProxyServlet.java:130)|#] [#|2015-11-18 10:32:59,856|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)|#] [#|2015-11-18 10:32:59,856|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)|#] [#|2015-11-18 10:32:59,857|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)|#] [#|2015-11-18 10:32:59,857|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)|#] [#|2015-11-18 10:32:59,858|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)|#] [#|2015-11-18 10:32:59,859|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91)|#] [#|2015-11-18 10:32:59,859|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72)|#] [#|2015-11-18 10:32:59,859|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)|#] [#|2015-11-18 10:32:59,860|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)|#] [#|2015-11-18 10:32:59,860|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)|#] [#|2015-11-18 10:32:59,861|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466)|#] [#|2015-11-18 10:32:59,861|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:559)|#] [#|2015-11-18 10:32:59,862|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)|#] [#|2015-11-18 10:32:59,862|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)|#] [#|2015-11-18 10:32:59,863|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:876)|#] [#|2015-11-18 10:32:59,863|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:607)|#] [#|2015-11-18 10:32:59,864|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2505)|#] [#|2015-11-18 10:32:59,864|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)|#] [#|2015-11-18 10:32:59,864|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808)|#] [#|2015-11-18 10:32:59,865|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)|#] [#|2015-11-18 10:32:59,865|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:849)|#] [#|2015-11-18 10:32:59,866|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at java.lang.Thread.run(Thread.java:745)|#] [#|2015-11-18 10:32:59,866|ERROR|[stderr]|(ThreadId: sc-http-executor-threads - 89)| at org.jboss.threads.JBossThread.run(JBossThread.java:122)|#] [#|2015-11-18 10:32:59,867|ERROR|[com.ericsson.iptv.portal.avalanche.tt.rr.iap.RegulatoryRatingBean]|(ThreadId: sc-http-executor-threads - 89)|Failed to insert channel regulatory rating events from petra.kirin: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3d6cb34e[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2b6fe563 connection handles=0 lastUse=1447779656009 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2b9aa5f1 pool internal context=SemaphoreArrayListManagedConnectionPool@469fd40d[pool=jdbc_tivibu_ott] xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2b6fe563 txSync=null] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:890) at com.ericsson.iptv.portal.avalanche.tt.rr.iap.RegulatoryRatingBean.saveChannelRatingEvents(RegulatoryRatingBean.java:196) at com.ericsson.iptv.portal.avalanche.tt.rr.iap.RegulatoryRatingBean.sendChannelEvents(RegulatoryRatingBean.java:320) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_85] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_85] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_85] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_85] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy2054.sendChannelEvents(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_85] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_85] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_85] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_85] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:78) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:68) at com.ericsson.iptv.portal.fw.cors.AbstractCorsRequestFilter.doFilter(AbstractCorsRequestFilter.java:130) at com.ericsson.iptv.portal.iap.cors.CorsRequestFilter.doFilter(CorsRequestFilter.java:55) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalFilter(ServletFilterManager.java:79) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalPerformAction(ServletFilterManager.java:89) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:76) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:68) at com.ericsson.iptv.portal.fw.backend.gzip.GZIPServletFilter.doFilter(GZIPServletFilter.java:88) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.backend.startup.DisableDirectoryListings.doFilter(DisableDirectoryListings.java:114) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.backend.cache.StaticDataCacheControl.doFilter(StaticDataCacheControl.java:83) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager$FilterChainImpl.doFilter(ServletFilterManager.java:66) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalFilter(ServletFilterManager.java:79) at com.ericsson.iptv.portal.fw.servlet.mbean.ServletFilterManager.internalPerformAction(ServletFilterManager.java:89) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter$FilterChainImpl.doFilter(PortalServletFilter.java:76) at com.ericsson.iptv.portal.fw.servlet.PortalServletFilter.doFilter(PortalServletFilter.java:93) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:832) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:620) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:553) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:482) at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.internalForwardRequest(ArtifactBase.java:325) at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.internalPerformAction(ArtifactBase.java:351) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.performAction(MBeanManagerBase.java:534) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:547) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$1.compareTo(MBeanManagerBase.java:544) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$Manager.invoke(MBeanManagerBase.java:317) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase$4.invokeOn(MBeanManagerBase.java:619) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.invokeOnSingleManager(MBeanManagerBase.java:514) at com.ericsson.iptv.portal.fw.mbean.MBeanManagerBase.broadcast(MBeanManagerBase.java:616) at com.ericsson.iptv.portal.fw.artifact.ArtifactBase.forwardRequest(ArtifactBase.java:424) at com.ericsson.iptv.portal.proxy.ProxyServlet.service(ProxyServlet.java:130) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91) at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:559) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:876) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:607) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2505) at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:849) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_85] at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.1.Final-redhat-1.jar:2.1.1.Final-redhat-1] Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3d6cb34e[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2b6fe563 connection handles=0 lastUse=1447779656009 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2b9aa5f1 pool internal context=SemaphoreArrayListManagedConnectionPool@469fd40d[pool=jdbc_tivibu_ott] xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2b6fe563 txSync=null] at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:151) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) ... 104 more Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@3d6cb34e[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2b6fe563 connection handles=0 lastUse=1447779656009 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2b9aa5f1 pool internal context=SemaphoreArrayListManagedConnectionPool@469fd40d[pool=jdbc_tivibu_ott] xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@2b6fe563 txSync=null] at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:631) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:494) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143) ... 106 more Caused by: javax.resource.ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:490) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:626) ... 108 more Caused by: javax.transaction.SystemException: IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffffac1564ab:-422f4503:56435b24:16de29bc status: ActionStatus.ABORT_ONLY > at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:669) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:368) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:483) ... 109 more |#]
Interface:
@RequestMapping @Transactional public interface RRStatisticsService { @Cache(CacheType.NO_CACHE) @AuthRequired(AuthType.USER) @Transactional(propagation = Propagation.REQUIRES_NEW) @RequestMapping(value = "/private/rr/sendChannelEvents.ajax", method = RequestMethod.POST) public @ResponseBody void sendChannelEvents(@Valid @RequestBody ChannelRatingEvents events, @SubscriberId String subscriberId, @UserId String userId, @DeviceId String deviceId) throws PortalException; @Cache(CacheType.NO_CACHE) @AuthRequired(AuthType.USER) @Transactional(propagation = Propagation.REQUIRES_NEW) @RequestMapping(value = "/private/rr/sendVodEvents.ajax", method = RequestMethod.POST) public @ResponseBody void sendVodEvents(@Valid @RequestBody VodRatingEvents events, @SubscriberId String subscriberId, @UserId String userId, @DeviceId String deviceId) throws PortalException; }
Bean:
@Controller public class RRBean implements RRStatisticsService { @Override public void sendChannelEvents(ChannelRatingEvents events, String subscriberId, String userId, String deviceId) throws PortalException { saveChannelRatingEvents(events, subscriberId, userId, deviceId); } @Override public void sendVodEvents(VodRatingEvents events, String subscriberId, String userId, String deviceId) throws PortalException { saveVodRatingEvents(events, subscriberId, userId, deviceId); } v private void saveChannelRatingEvents(ChannelRatingEvents events, String subscriberId, String userId, String deviceId) throws SomeException { try { JdbcTemplate template = getJdbcTemplate(userId, deviceId, events.getClientType()); insertChannelRating(events, subscriberId, userId, template); } catch (Exception e) { //Handle exception } } private void insertChannelRating(ChannelRatingEvents events, String subscriberId, String userId, JdbcTemplate template){ template.batchUpdate(SQL_CHANNEL_RATING, new BatchPreparedStatementSetter() { @Override public void setValues(PreparedStatement ps, int i) throws SQLException { ChannelRatingEvent event = rrevents.get(i); ps.setString(1, event.getChannelViewID()); ps.setString(2, event.getChannelName()); ps.setInt(3, event.getChannelID()); ps.setInt(4, event.getStreamFlag()); ps.setInt(5, events.getClientType()); ps.setDate(6, event.Date()); ps.setString(7, userId); ps.setString(8, subscriberId); ps.setString(9, "0"); ps.setDate(10, event.Date()); } @Override public int getBatchSize() { return rrevents.size(); } }); } private void saveVodRatingEvents(VodRatingEvents events, String subscriberId, String userId, String deviceId) throws SomeException { try { JdbcTemplate template = getJdbcTemplate(userId, deviceId, events.getClientType()); insertVodRating(events, subscriberId, userId, template); } catch (Exception e) { //HANDLE EXCEPTION } } private void insertVodRating(VodRatingEvents events, String subscriberId, String userId, JdbcTemplate template){ template.batchUpdate(SQL_VOD_RATING, new BatchPreparedStatementSetter() { @Override public void setValues(PreparedStatement ps, int i) throws SQLException { VodRatingEvent event = rrevents.get(i); ps.setString(1, event.getVodViewID()); ps.setString(2, event.getVodName()); ps.setString(3, event.getAssetID()); ps.setInt(4, event.getVodType()); ps.setInt(5, event.getVodSegment()); ps.setInt(6, clientType); ps.setDate(7, event.getDate()); ps.setString(8, userId); ps.setString(9, subscriberId); ps.setString(10, "0"); ps.setDate(11, event.getDate()); } @Override public int getBatchSize() { return rrevents.size(); } }); } private JdbcTemplate getJdbcTemplate(String userId, String deviceId, Integer clientType) { DataSource dataSource = null; JndiTemplate jndi = new JndiTemplate(); String dataSourceJndi; if (clientType.intValue() == 0) { dataSourceJndi = getUserPreferences(userId, deviceId).get(STB_DS_PREF_KEY); } } else { dataSourceJndi = getUserPreferences(userId, deviceId).get(OTT_DS_PREF_KEY); } } try { dataSource = (DataSource) jndi.lookup(dataSourceJndi); } catch (NamingException e) { logger.error("NamingException for " + dataSourceJndi, e); return null; } return new JdbcTemplate(dataSource); } }
Datasource definition:
<xa-datasource jndi-name="java:/jdbc/tivibu_stb" pool-name="jdbc_tivibu_stb" enabled="true" use-ccm="false"> <xa-datasource-property name="User"> USER2 </xa-datasource-property> <xa-datasource-property name="Password"> PWD2 </xa-datasource-property> <xa-datasource-property name="URL"> jdbc:oracle:thin:@hostip2:1521:TTEST2 </xa-datasource-property> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> <driver>ojdbc</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <xa-pool> <min-pool-size>30</min-pool-size> <max-pool-size>80</max-pool-size> <use-strict-min>true</use-strict-min> <is-same-rm-override>false</is-same-rm-override> <interleaving>false</interleaving> <no-tx-separate-pools>true</no-tx-separate-pools> <pad-xid>false</pad-xid> <wrap-xa-resource>false</wrap-xa-resource> </xa-pool> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <timeout> <set-tx-query-timeout>false</set-tx-query-timeout> <blocking-timeout-millis>0</blocking-timeout-millis> <idle-timeout-minutes>1</idle-timeout-minutes> <query-timeout>0</query-timeout> <use-try-lock>0</use-try-lock> <allocation-retry>0</allocation-retry> <allocation-retry-wait-millis>0</allocation-retry-wait-millis> <xa-resource-timeout>0</xa-resource-timeout> </timeout> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </xa-datasource> <xa-datasource jndi-name="java:/jdbc/tivibu_ott" pool-name="jdbc_tivibu_ott" enabled="true" use-ccm="false"> <xa-datasource-property name="User"> USER1 </xa-datasource-property> <xa-datasource-property name="Password"> PWD1 </xa-datasource-property> <xa-datasource-property name="URL"> jdbc:oracle:thin:@hostip1:1521:TTEST1 </xa-datasource-property> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> <driver>ojdbc</driver> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <xa-pool> <min-pool-size>30</min-pool-size> <max-pool-size>80</max-pool-size> <prefill>false</prefill> <use-strict-min>true</use-strict-min> <flush-strategy>FailingConnectionOnly</flush-strategy> <is-same-rm-override>false</is-same-rm-override> <interleaving>false</interleaving> <no-tx-separate-pools>true</no-tx-separate-pools> <pad-xid>false</pad-xid> <wrap-xa-resource>false</wrap-xa-resource> </xa-pool> <validation> <validate-on-match>false</validate-on-match> <background-validation>false</background-validation> </validation> <timeout> <set-tx-query-timeout>false</set-tx-query-timeout> <blocking-timeout-millis>0</blocking-timeout-millis> <idle-timeout-minutes>1</idle-timeout-minutes> <query-timeout>0</query-timeout> <use-try-lock>0</use-try-lock> <allocation-retry>0</allocation-retry> <allocation-retry-wait-millis>0</allocation-retry-wait-millis> <xa-resource-timeout>0</xa-resource-timeout> </timeout> <statement> <share-prepared-statements>false</share-prepared-statements> </statement> </xa-datasource>