anonymous Log in
Search
Recents:
v3.0
gx-l
Problema en Ms Azure
11/11/20 13: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
Replies

Paulo Andrés Sa88723

12/11/20 22: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

13/11/20 12:08
Muchas gracias, probaré. El Thu, 12 Nov 2020 19:29:42 -0300 Paulo Sapuppo


Back to gx-l