Hi Bodys...
We have continuos problem with connection pool on SQL Server, It generate stack the system and down.... the side to conectivity (NET) no view enything and the DBMS it no have mesages or log to related with problem or desconection...
on SOA Server.out
<18-dic-2016 23H33' CST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "datalogicDS" failed with exception: "javax.transaction.xa.XAException: [FMWGEN][SQLServer JDBC Driver]No more data available to read.".>
<18-dic-2016 23H48' CST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "cirisDS" failed with exception: "javax.transaction.xa.XAException: [FMWGEN][SQLServer JDBC Driver]No more data available to read.".>
<18-dic-2016 23H49' CST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "datalogicDS" failed with exception: "javax.transaction.xa.XAException: [FMWGEN][SQLServer JDBC Driver]No more data available to read.".>
<19-dic-2016 00H17' CST> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: '39' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "3.602" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 3602911 ms
[
POST /CierreTiendaProcessService/CierreTiendaProcessWS HTTP/1.1
Content-Type: application/soap+xml; charset=utf-8
Transfer-Encoding: chunked
User-Agent: Java1.6.0_31
Accept: text/html, image/gif, image/jpeg, */*; q=.2
Connection: Keep-Alive
]", which is more than the configured time (StuckThreadMaxTime) of "3.600" seconds. Stack trace:
Thread-272 "[STUCK] ExecuteThread: '39' for queue: 'weblogic.kernel.Default (self-tuning)'" <alive, suspended, blocked, priority=1, DAEMON> {
on Soa Server.log
####<18-dic-2016 02H46' CST> <Error> <com.cya.apps.commons.model.generic.srv.EJBException> <mexsoacya01.cyamoda.com> <soa_server_p01> <orabpel.invoke.pool-4.thread-5> <<anonymous>> <BEA1-6E59B9C577294D58734A> <11d1def534ea1be0:-526829e0:158f70ddd35:-7ffd-000000000034bd47> <1482050778546> <BEA-000000> <No se pudo realizar la conexión TCP/IP al host 10.154.3.10, puerto 1433. Error: "connect timed out. Verifique las propiedades de conexión, compruebe que hay una instancia de SQL Server ejecutándose en el host y aceptando las conexiones TCP/IP en el puerto y compruebe que no hay ningún firewall bloqueando las conexiones TCP en el puerto.".>
####<18-dic-2016 08H45' CST> <Error> <com.cya.apps.commons.model.generic.srv.EJBException> <mexsoacya01.cyamoda.com> <soa_server_p01> <orabpel.invoke.pool-4.thread-18> <<anonymous>> <BEA1-4077B74892A24D58734A> <11d1def534ea1be0:-526829e0:158f70ddd35:-7ffd-000000000035533d> <1482072312749> <BEA-000000> <El controlador no pudo establecer una conexión segura con SQL Server con el cifrado de Capa de sockets seguros (SSL). Error: "SQL Server devolvió una respuesta incompleta. Se cerró la conexión. ClientConnectionId:c6cdd5ae-560b-4bca-80ea-ced66874f40a".>
####<18-dic-2016 22H57' CST> <Error> <JMSPool> <mexsoacya01.cyamoda.com> <soa_server_p01> <[ACTIVE] ExecuteThread: '80' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <11d1def534ea1be0:-526829e0:158f70ddd35:-7ffd-000000000041b6f1> <1482123451917> <BEA-169805> <A pooled JMS connection is being closed because an error was detected on the connection: Unknown reason>
####<18-dic-2016 23H24' CST> <Warning> <JTA> <mexsoacya01.cyamoda.com> <soa_server_p01> <[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <11d1def534ea1be0:-526829e0:158f70ddd35:-7ffd-00000000004213b2> <1482125069784> <BEA-110484> <The JTA health state has changed from HEALTH_OK to HEALTH_WARN with reason codes: Resource cirisDS_soa_domain_produccion declared unhealthy.>
####<18-dic-2016 23H33' CST> <Error> <JDBC> <mexsoacya01.cyamoda.com> <soa_server_p01> <[ACTIVE] ExecuteThread: '64' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <11d1def534ea1be0:-526829e0:158f70ddd35:-7ffd-000000000042170a> <1482125619952> <BEA-001112> <Test "SELECT 1" set up for pool "datalogicDS" failed with exception: "javax.transaction.xa.XAException: [FMWGEN][SQLServer JDBC Driver]No more data available to read.".>