Buscar este blog

sábado, 18 de julio de 2015

JBoss - SQL Server - Error: "*** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***"

Error:
12:38:22,879 WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (http-localhost/127.0.0.1:8080-7) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1a7beef5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 connection handles=0 lastUse=1437215902877 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4efe0e2b pool internal context=SemaphoreArrayListManagedConnectionPool@789acdfa[pool=seguridadDS] xaResource=XAResourceWrapperImpl@171947e9[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 pad=false overrideRmValue=false productName=Microsoft SQL Server productVersion=10.50.4000 jndiName=java:jboss/datasources/seguridadDS] txSync=null]: javax.transaction.xa.XAException: Error en la función START:. El estado es: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
 at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:550)
 at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:679)
 at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
 at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.start(XAResourceWrapperImpl.java:203)
 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:636) [jbossjta-4.16.0.Final.jar:]
 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:397) [jbossjta-4.16.0.Final.jar:]
 at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:647)
 at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:305)
 at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
 at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599)
 at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
 at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
 at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:56) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:161) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:159) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1859) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1836) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1816) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.doQuery(Loader.java:900) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.doList(Loader.java:2526) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.doList(Loader.java:2512) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2342) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.Loader.list(Loader.java:2337) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1668) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374) [hibernate-core-4.2.7.SP1.jar:4.2.7.SP1]
 at es.sisifo.myapp.persistencia.dao.hibernate.PerfilDAOImpl.getPerfilesByNifAndSystem(PerfilDAOImpl.java:101) [seguridad-persistencia-1.3.0-SNAPSHOT.jar:]
 at es.sisifo.myapp.persistencia.fachada.impl.PerfilFacade.getPerfilesBySistemaNif(PerfilFacade.java:250) [seguridad-persistencia-1.3.0-SNAPSHOT.jar:]
 at es.sisifo.myapp.negocio.BusinessPerfilImpl.getPerfiles(BusinessPerfilImpl.java:177) [classes:]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_21]
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_21]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_21]
 at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_21]
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) [spring-tx-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) [spring-tx-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) [spring-tx-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at com.sun.proxy.$Proxy131.getPerfiles(Unknown Source)
 at es.sisifo.myapp.negocio.external.SeguridadServiceExternal.getPerfilesUsuario(SeguridadServiceExternal.java:50) [classes:]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_21]
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_21]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_21]
 at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_21]
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) [spring-tx-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) [spring-tx-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) [spring-tx-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) [spring-aop-3.2.4.RELEASE.jar:3.2.4.RELEASE]
 at com.sun.proxy.$Proxy134.getPerfilesUsuario(Unknown Source)
 at es.sisifo.myapp.negocio.external.ws.SeguridadServiceWS.getPerfilesUsuario(SeguridadServiceWS.java:37) [classes:]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_21]
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_21]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_21]
 at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_21]
 at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) [jboss-as-ee-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58) [jboss-as-ee-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58) [jboss-as-ee-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.as.webservices.deployers.WSComponentInstanceAssociationInterceptor.processInvocation(WSComponentInstanceAssociationInterceptor.java:49)
 at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
 at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.as.webservices.invocation.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:112)
 at org.jboss.wsf.stack.cxf.JBossWSInvoker.performInvocation(JBossWSInvoker.java:149)
 at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) [cxf-api-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:178) [cxf-rt-frontend-jaxws-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:68) [cxf-rt-frontend-jaxws-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:129)
 at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:57) [cxf-api-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_21]
 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_21]
 at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_21]
 at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) [cxf-api-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106) [cxf-api-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:272) [cxf-api-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-api-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:239) [cxf-rt-transports-http-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:92)
 at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:143)
 at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)
 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:286) [cxf-rt-transports-http-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:206) [cxf-rt-transports-http-2.7.7.redhat-1.jar:2.7.7.redhat-1]
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]
 at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)
 at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.2.2.Final-redhat-1.jar:2.2.2.Final-redhat-1]
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.jboss.as.web.session.ClusteredSessionValve.handleRequest(ClusteredSessionValve.java:134) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.as.web.session.ClusteredSessionValve.invoke(ClusteredSessionValve.java:99) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.as.web.session.JvmRouteValve.invoke(JvmRouteValve.java:92) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.as.web.session.LockingValve.invoke(LockingValve.java:64) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
 at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_21]
 
(...)


12:38:22,938 INFO  [stdout] (http-localhost/127.0.0.1:8080-7) [2015-07-18 12:38:22,938] (SqlExceptionHelper.java:145) WARN http-localhost/127.0.0.1:8080-7 org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 0, SQLState: null
12:38:22,939 INFO  [stdout] (http-localhost/127.0.0.1:8080-7) [2015-07-18 12:38:22,939] (SqlExceptionHelper.java:147) ERROR http-localhost/127.0.0.1:8080-7 org.hibernate.engine.jdbc.spi.SqlExceptionHelper javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1a7beef5[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 connection handles=0 lastUse=1437215902877 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4efe0e2b pool internal context=SemaphoreArrayListManagedConnectionPool@789acdfa[pool=seguridadDS] xaResource=XAResourceWrapperImpl@171947e9[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 pad=false overrideRmValue=false productName=Microsoft SQL Server productVersion=10.50.4000 jndiName=java:jboss/datasources/seguridadDS] txSync=null]
12:38:22,940 INFO  [stdout] (http-localhost/127.0.0.1:8080-7) [2015-07-18 12:38:22,939] (PerfilFacade.java:259) ERROR http-localhost/127.0.0.1:8080-7 es.sisifo.myapp.persistencia.fachada.impl.PerfilFacade PerfilFacade: getPerfilesBySistemaNif Could not open connection
12:38:22,940 INFO  [stdout] (http-localhost/127.0.0.1:8080-7) [2015-07-18 12:38:22,940] (BusinessPerfilImpl.java:187) ERROR http-localhost/127.0.0.1:8080-7 es.sisifo.myapp.negocio.BusinessPerfilImpl BusinessPerfilImpl: getPerfil(nif, sistema) PerfilFacade:getPerfilesBySistemaNif Could not open connection
12:38:22,941 ERROR [stderr] (http-localhost/127.0.0.1:8080-7) es.sisifo.myapp.api.exceptions.BussinessException: BusinessPerfilImpl: getPerfil(nif, sistema) PerfilFacade:getPerfilesBySistemaNif Could not open connection
12:38:22,941 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at es.sisifo.myapp.negocio.BusinessPerfilImpl.getPerfiles(BusinessPerfilImpl.java:188)
12:38:22,941 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:38:22,941 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
12:38:22,942 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
12:38:22,942 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at java.lang.reflect.Method.invoke(Method.java:601)
12:38:22,942 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
12:38:22,942 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
12:38:22,942 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
12:38:22,943 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
12:38:22,943 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
12:38:22,943 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
12:38:22,943 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
12:38:22,943 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
12:38:22,944 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at com.sun.proxy.$Proxy131.getPerfiles(Unknown Source)
12:38:22,944 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at es.sisifo.myapp.negocio.external.SeguridadServiceExternal.getPerfilesUsuario(SeguridadServiceExternal.java:50)
12:38:22,944 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:38:22,944 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
12:38:22,944 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
12:38:22,945 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at java.lang.reflect.Method.invoke(Method.java:601)
12:38:22,945 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
12:38:22,945 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
12:38:22,945 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
12:38:22,945 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
12:38:22,946 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
12:38:22,946 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
12:38:22,946 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
12:38:22,946 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
12:38:22,946 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at com.sun.proxy.$Proxy134.getPerfilesUsuario(Unknown Source)
12:38:22,947 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at es.sisifo.myapp.negocio.external.ws.SeguridadServiceWS.getPerfilesUsuario(SeguridadServiceWS.java:37)
12:38:22,947 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:38:22,947 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
12:38:22,947 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
12:38:22,947 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at java.lang.reflect.Method.invoke(Method.java:601)
12:38:22,948 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
12:38:22,948 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
12:38:22,948 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
12:38:22,948 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)
12:38:22,948 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
12:38:22,949 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
12:38:22,949 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:58)
12:38:22,949 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
12:38:22,949 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
12:38:22,949 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
12:38:22,949 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
12:38:22,950 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
12:38:22,950 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
12:38:22,950 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.webservices.deployers.WSComponentInstanceAssociationInterceptor.processInvocation(WSComponentInstanceAssociationInterceptor.java:49)
12:38:22,950 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
12:38:22,950 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
12:38:22,951 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
12:38:22,951 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.webservices.invocation.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:112)
12:38:22,951 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.wsf.stack.cxf.JBossWSInvoker.performInvocation(JBossWSInvoker.java:149)
12:38:22,951 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
12:38:22,951 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:178)
12:38:22,952 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:68)
12:38:22,952 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:129)
12:38:22,952 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:57)
12:38:22,952 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
12:38:22,953 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
12:38:22,953 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at java.util.concurrent.FutureTask.run(FutureTask.java:166)
12:38:22,953 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
12:38:22,953 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
12:38:22,953 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:272)
12:38:22,954 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
12:38:22,954 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:239)
12:38:22,954 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:92)
12:38:22,954 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:143)
12:38:22,954 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)
12:38:22,954 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:286)
12:38:22,955 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:206)
12:38:22,955 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
12:38:22,955 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)
12:38:22,955 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140)
12:38:22,955 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
12:38:22,956 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
12:38:22,956 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
12:38:22,956 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
12:38:22,956 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
12:38:22,956 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.web.session.ClusteredSessionValve.handleRequest(ClusteredSessionValve.java:134)
12:38:22,957 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.web.session.ClusteredSessionValve.invoke(ClusteredSessionValve.java:99)
12:38:22,957 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.web.session.JvmRouteValve.invoke(JvmRouteValve.java:92)
12:38:22,957 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.web.session.LockingValve.invoke(LockingValve.java:64)
12:38:22,957 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
12:38:22,957 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)
12:38:22,958 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
12:38:22,958 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
12:38:22,958 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336)
12:38:22,958 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
12:38:22,958 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
12:38:22,959 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920)
12:38:22,959 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at java.lang.Thread.run(Thread.java:722)
12:38:22,959 ERROR [stderr] (http-localhost/127.0.0.1:8080-7) Caused by: es.sisifo.myapp.persistencia.exceptions.PersistenceException: PerfilFacade:getPerfilesBySistemaNif Could not open connection
12:38:22,959 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at es.sisifo.myapp.persistencia.fachada.impl.PerfilFacade.getPerfilesBySistemaNif(PerfilFacade.java:262)
12:38:22,960 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at es.sisifo.myapp.negocio.BusinessPerfilImpl.getPerfiles(BusinessPerfilImpl.java:177)
12:38:22,960 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  ... 90 more
12:38:22,960 ERROR [stderr] (http-localhost/127.0.0.1:8080-7) Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection
12:38:22,961 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
12:38:22,961 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
12:38:22,961 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
12:38:22,961 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)
12:38:22,961 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
12:38:22,962 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:56)
12:38:22,962 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:161)
12:38:22,962 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
12:38:22,962 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:159)
12:38:22,962 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1859)
12:38:22,963 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1836)
12:38:22,963 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1816)
12:38:22,963 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.doQuery(Loader.java:900)
12:38:22,963 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)
12:38:22,963 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.doList(Loader.java:2526)
12:38:22,964 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.doList(Loader.java:2512)
12:38:22,964 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2342)
12:38:22,964 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.Loader.list(Loader.java:2337)
12:38:22,964 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:124)
12:38:22,964 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1668)
12:38:22,964 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
12:38:22,965 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at es.sisifo.myapp.persistencia.dao.hibernate.PerfilDAOImpl.getPerfilesByNifAndSystem(PerfilDAOImpl.java:101)
12:38:22,965 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at es.sisifo.myapp.persistencia.fachada.impl.PerfilFacade.getPerfilesBySistemaNif(PerfilFacade.java:250)
12:38:22,965 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  ... 91 more
12:38:22,966 ERROR [stderr] (http-localhost/127.0.0.1:8080-7) Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1a7beef5[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 connection handles=0 lastUse=1437215902877 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4efe0e2b pool internal context=SemaphoreArrayListManagedConnectionPool@789acdfa[pool=seguridadDS] xaResource=XAResourceWrapperImpl@171947e9[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 pad=false overrideRmValue=false productName=Microsoft SQL Server productVersion=10.50.4000 jndiName=java:jboss/datasources/seguridadDS] txSync=null]
12:38:22,966 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
12:38:22,966 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
12:38:22,966 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)
12:38:22,966 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
12:38:22,967 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  ... 110 more
12:38:22,967 ERROR [stderr] (http-localhost/127.0.0.1:8080-7) Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1a7beef5[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 connection handles=0 lastUse=1437215902877 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4efe0e2b pool internal context=SemaphoreArrayListManagedConnectionPool@789acdfa[pool=seguridadDS] xaResource=XAResourceWrapperImpl@171947e9[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 pad=false overrideRmValue=false productName=Microsoft SQL Server productVersion=10.50.4000 jndiName=java:jboss/datasources/seguridadDS] txSync=null]
12:38:22,967 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:604)
12:38:22,967 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
12:38:22,968 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
12:38:22,968 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  ... 113 more
12:38:22,968 ERROR [stderr] (http-localhost/127.0.0.1:8080-7) Caused by: javax.resource.ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object
12:38:22,968 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:474)
12:38:22,969 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599)
12:38:22,969 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  ... 115 more
12:38:22,969 ERROR [stderr] (http-localhost/127.0.0.1:8080-7) 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:ffffc0a80120:2e261a98:55aa2c5e:4d status: ActionStatus.ABORT_ONLY >
12:38:22,969 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:612)
12:38:22,970 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:323)
12:38:22,970 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
12:38:22,970 ERROR [stderr] (http-localhost/127.0.0.1:8080-7)  ... 116 more

(...)

This error appears when you use a XA-DATASOURCE from JBoss to connect to a database in SQL Server, and it does not have XA TRANSACTIONS activated.

The key error lines are:
org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1a7beef5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 connection handles=0 lastUse=1437215902877 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4efe0e2b pool internal context=SemaphoreArrayListManagedConnectionPool@789acdfa[pool=seguridadDS] xaResource=XAResourceWrapperImpl@171947e9[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@3e852468 pad=false overrideRmValue=false productName=Microsoft SQL Server productVersion=10.50.4000 jndiName=java:jboss/datasources/seguridadDS] txSync=null]: javax.transaction.xa.XAException: Error en la función START:. El estado es: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
And:
javax.transaction.SystemException: IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffffc0a80120:2e261a98:55aa2c5e:4d status: ActionStatus.ABORT_ONLY >
The first one says that there was an error when you tried to open a new transaction, and the second says that you can not enlist a xa-resource in a transaction with errors.


In order solve this error, you only have to configure XA TRANSACTIONS in SQL Server.
You can check:

No hay comentarios:

Publicar un comentario