******** ERROR api_reporte.onopen(1)
java.lang.Exception: ERROR reportes4/api_reporte:api_reporte.onopen(1) i2: java.sql.SQLException: SELECT periodos.codigo as periodo,
(select count(*) from nsjobitems where job = '$job' and procesado >= periodos.desde and procesado < periodos.hasta2) as envios
 FROM periodos  WHERE periodos.desde >= '2024-01-01'
and periodos.desde <= current_date() AND (select id, concat(id, ' - ', para, ' - ', remitente) from nsjobs where tipo = 'wp' order by id desc limit 100) AND (select tipo, tipo from periodos group by tipo) AND () ORDER BY periodos.codigo LIMIT 2000
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY periodos.codigo LIMIT 2000' at line 4

java.sql.SQLException: SELECT periodos.codigo as periodo,
(select count(*) from nsjobitems where job = '$job' and procesado >= periodos.desde and procesado < periodos.hasta2) as envios
 FROM periodos  WHERE periodos.desde >= '2024-01-01'
and periodos.desde <= current_date() AND (select id, concat(id, ' - ', para, ' - ', remitente) from nsjobs where tipo = 'wp' order by id desc limit 100) AND (select tipo, tipo from periodos group by tipo) AND () ORDER BY periodos.codigo LIMIT 2000
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY periodos.codigo LIMIT 2000' at line 4

	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:193)
	at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:128)
	at flexa.fb.LibDb.sqltoarray(LibDb.java:205)
	at flexa.fb.LibDb.executeReport(LibDb.java:272)
	at flexa.fb.LibDb.call(LibDb.java:63)
	at flexa.fb.FContext.call(FContext.java:681)
	at flexa.fb.FContext.call(FContext.java:664)
	at flexa.fb.EFI.runBytecode(EFI.java:884)
	at flexa.fb.EFI.runBytecode(EFI.java:731)
	at flexa.fb.FComponent.event(FComponent.java:691)
	at flexa.ff.window.event(window.java:46)
	at flexa.fb.FComponent.executeEvent(FComponent.java:716)
	at flexa.fb.CompManager.processAction(CompManager.java:757)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:476)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:167)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:564)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:676)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:894)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:829)

	at flexa.fb.EFI.runBytecode(EFI.java:1139)
	at flexa.fb.EFI.runBytecode(EFI.java:731)
	at flexa.fb.FComponent.event(FComponent.java:691)
	at flexa.ff.window.event(window.java:46)
	at flexa.fb.FComponent.executeEvent(FComponent.java:716)
	at flexa.fb.CompManager.processAction(CompManager.java:757)
	at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:476)
	at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:167)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:564)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:676)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:894)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1741)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:829)


CONTEXT:
_module=reportes4  <i><small>String</small></i>
<b>component</b>


<b>request_</b>
     tipo=dia  <i><small>String</small></i>
     desde=2024-11-17  <i><small>String</small></i>
     _c=reportes4/api_reporte  <i><small>String</small></i>
     _ip=127.0.0.1  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _sessionid=AQagXND7EYvpCji2Ijgi  <i><small>String</small></i>
     _servername=66.97.46.32  <i><small>String</small></i>
     id=459  <i><small>String</small></i>
     job=10004936  <i><small>String</small></i>
     _url=http://66.97.46.32/app/index.html  <i><small>String</small></i>


<b><red>u_</red></b>


<b><red>s_</red></b>


<b><red>g_</red></b>
     g_base=http://66.97.46.32  <i><small>String</small></i>
     g_sidebarbgcolor=#ccc  <i><small>String</small></i>
     g_estilosadicionales=null
     _e=uv1066_quartier  <i><small>String</small></i>
     g_sidebarcolor=#fff  <i><small>String</small></i>
     g_sidebarposition=Nuevo  <i><small>String</small></i>