anonymous
Log in
Log out
Search
Recents:
v3.0
My subscriptions
My posts
My profile
gx-l
Problema en Ms Azure
11/11/20 10:21
agomezr@vtr.net
Replies:
2
Estimad@s: Tengo una app web funcionando en una VM en la nube de Azure. En general funciona sin problemas, pero cuando pasan algunos segundos de inactividad se me presenta un error de desconexión a la base de datos. Creo que es solo un tema de configuración en la KB o en el DBMS, por lo que quería preguntar si algun@ de ustedes ya le ha pasado y como lo solucionaron. Es Gx 16, generando Java 1.8 con MySql 5.7. El error es el siguiente: Estado HTTP 500 – Internal Server Error Tipo Informe de Excepción mensaje java.lang.reflect.InvocationTargetException Descripción El servidor encontró un error interno que hizo que no pudiera rellenar este requerimiento. excepción javax.servlet.ServletException: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.genexus.webpanels.GXWebPanel$DynAjaxEvent.doInvoke(GXWebPanel.java:1089) at com.genexus.webpanels.GXWebPanel$DynAjaxEvent.invoke(GXWebPanel.java:1119) at com.genexus.webpanels.GXWebPanel.webAjaxEvent(GXWebPanel.java:469) at com.genexus.webpanels.GXWebPanel.webExecuteEx(GXWebPanel.java:420) at com.genexus.webpanels.GXWebPanel.doExecute(GXWebPanel.java:443) at com.servicioslab.agenda.doExecute(agenda.java:24) at com.genexus.webpanels.GXWebObjectStub.callDoExecute(GXWebObjectStub.java:242) at com.genexus.webpanels.GXWebObjectStub.callExecute(GXWebObjectStub.java:124) at com.genexus.webpanels.GXWebObjectStub.doPost(GXWebObjectStub.java:40) at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at com.genexus.filters.ExpiresFilter.doFilter(ExpiresFilter.java:1241) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: com.genexus.GXRuntimeException: java.sql.SQLException: No operations allowed after statement closed. Saludos; Álvaro Gómez ----------------------------------------- Para Suscribirse/Desuscribirse: http://www.gxtechnical.com/cgi-bin/hforum.exe?2,3,30,1 Por consultas owner-gx-l@gxtech.com.uy
Estimad@s:
Tengo una app web funcionando en una VM en la nube de Azure. En
general funciona sin problemas, pero cuando pasan algunos segundos de
inactividad se me presenta un error de desconexión a la base de datos.
Creo que es solo un tema de configuración en la KB o en el DBMS, por
lo que quería preguntar si algun@ de ustedes ya le ha pasado y como lo
solucionaron. Es Gx 16, generando Java 1.8 con MySql 5.7. El error es
el siguiente:
Estado HTTP 500 – Internal Server Error
Tipo Informe de Excepción
mensaje java.lang.reflect.InvocationTargetException
Descripción El servidor encontró un error interno que hizo que no
pudiera rellenar este requerimiento.
excepción
javax.servlet.ServletException:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
com.genexus.webpanels.GXWebPanel$DynAjaxEvent.doInvoke(GXWebPanel.java:1089)
at
com.genexus.webpanels.GXWebPanel$DynAjaxEvent.invoke(GXWebPanel.java:1119)
at com.genexus.webpanels.GXWebPanel.webAjaxEvent(GXWebPanel.java:469)
at com.genexus.webpanels.GXWebPanel.webExecuteEx(GXWebPanel.java:420)
at com.genexus.webpanels.GXWebPanel.doExecute(GXWebPanel.java:443)
at com.servicioslab.agenda.doExecute(agenda.java:24)
at
com.genexus.webpanels.GXWebObjectStub.callDoExecute(GXWebObjectStub.java:242)
at
com.genexus.webpanels.GXWebObjectStub.callExecute(GXWebObjectStub.java:124)
at
com.genexus.webpanels.GXWebObjectStub.doPost(GXWebObjectStub.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
com.genexus.filters.ExpiresFilter.doFilter(ExpiresFilter.java:1241)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: com.genexus.GXRuntimeException: java.sql.SQLException: No
operations allowed after statement closed.
Saludos;
Álvaro Gómez
-----------------------------------------
Para Suscribirse/Desuscribirse:
http://www.gxtechnical.com/cgi-bin/hforum.exe?2,3,30,1
Por consultas owner-gx-l@gxtech.com.uy
Replies
Paulo Andrés Sa88723
12/11/20 19:29
Algo asi me paso alguna vez, fijate en no usar pool de conexiones a ver si con eso se soluciona, esta en las propiedades del datastore Saludo! El mié., 11 de nov. de 2020 a la(s) 10:52, <agomezr@vtr.net>
Algo asi me paso alguna vez, fijate en no usar pool de conexiones a ver si con eso se soluciona, esta en las propiedades del datastore Saludo! El mié., 11 de nov. de 2020 a la(s) 10:52,
agomezr@vtr.net
13/11/20 09:08
Muchas gracias, probaré. El Thu, 12 Nov 2020 19:29:42 -0300 Paulo Sapuppo <paulosapuppo@gmail.com>
Muchas gracias, probaré. El Thu, 12 Nov 2020 19:29:42 -0300 Paulo Sapuppo
Back to gx-l