******** ERROR saldofiducianteb.content(1) java.lang.Exception: ERROR consorcios4/home:saldofiducianteb.content(1) i6: java.lang.Exception: Invalid format data flexa.ff.div: 3855387.379999999888241291046142578125 java.lang.Exception: Invalid format data flexa.ff.div: 3855387.379999999888241291046142578125 at flexa.fb.LibText.format(LibText.java:279) at flexa.fb.LibText.call(LibText.java:70) at flexa.fb.FContext.call(FContext.java:681) at flexa.fb.FContext.call(FContext.java:664) at flexa.fb.EFI.runBytecode(EFI.java:871) at flexa.fb.FComponent.calcExpressions(FComponent.java:839) at flexa.fb.FComponent.calcExpressions(FComponent.java:872) at flexa.fb.FComponent.calcExpressions(FComponent.java:872) at flexa.fb.FComponent.calcExpressions(FComponent.java:872) at flexa.fb.CompManager.processAction(CompManager.java:711) at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465) at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159) 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:1083) at flexa.fb.FComponent.calcExpressions(FComponent.java:839) at flexa.fb.FComponent.calcExpressions(FComponent.java:872) at flexa.fb.FComponent.calcExpressions(FComponent.java:872) at flexa.fb.FComponent.calcExpressions(FComponent.java:872) at flexa.fb.CompManager.processAction(CompManager.java:711) at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465) at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159) 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) ******** ERROR home.onopen(163) java.lang.Exception: ERROR consorcios4/home:home.onopen(163) i476: java.sql.SQLException: select sum(t.saldo * -1) from emdocobra d join emtransobra t on d.id = t.documento join ocomobra as o on d.ocom = o.id join rcomobra as r on d.ocom = r.operacioncomercial join Unidadesobra as u on r.unidadId = u.id where o.estado not in ('Anulada', 'Inactiva') and t.descripcion not like 'FR %' and t.descripcion not like '%FR' and t.descripcion != 'SALDO' and if(t.contabilidad is null,t.contabilidad is null,t.contabilidad != 'G') and d.tipo = 'ov' and t.tipo = 'M' and t.moneda = 'ARS' and t.vencimiento < date_add(current_date(), interval day) and ( (abs(t.saldo) > 10 and t.moneda = 'ARS') or (abs(t.saldo) > 1 and t.moneda = 'UVA') or (abs(t.saldo) > 1 and t.moneda = 'USD') ) and d.estado = '+Emitida' and d.empresa = (select empresa from uv1066_quartier.Emprendimientos where id = '2') and t.estado != "ANULADA" and t.estado != "Anulada" and d.ocom in (select id from uv1066_quartier.ocom where estado !="ANULADA" and estado not like 'Reserva%' and estado not like 'Oferta%' /** and clase = 'Fiduciante A' **/) and u.tipou = 'D' and u.id in (select unidad from icrel where contacto = '168347' and tipo in ('Titular', 'Inquilino', 'Contacto principal') and estado = 'Activo'); 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 ') and ( (abs(t.saldo) > 10 and t.moneda = 'ARS') or (abs(t.' at line 17 java.sql.SQLException: select sum(t.saldo * -1) from emdocobra d join emtransobra t on d.id = t.documento join ocomobra as o on d.ocom = o.id join rcomobra as r on d.ocom = r.operacioncomercial join Unidadesobra as u on r.unidadId = u.id where o.estado not in ('Anulada', 'Inactiva') and t.descripcion not like 'FR %' and t.descripcion not like '%FR' and t.descripcion != 'SALDO' and if(t.contabilidad is null,t.contabilidad is null,t.contabilidad != 'G') and d.tipo = 'ov' and t.tipo = 'M' and t.moneda = 'ARS' and t.vencimiento < date_add(current_date(), interval day) and ( (abs(t.saldo) > 10 and t.moneda = 'ARS') or (abs(t.saldo) > 1 and t.moneda = 'UVA') or (abs(t.saldo) > 1 and t.moneda = 'USD') ) and d.estado = '+Emitida' and d.empresa = (select empresa from uv1066_quartier.Emprendimientos where id = '2') and t.estado != "ANULADA" and t.estado != "Anulada" and d.ocom in (select id from uv1066_quartier.ocom where estado !="ANULADA" and estado not like 'Reserva%' and estado not like 'Oferta%' /** and clase = 'Fiduciante A' **/) and u.tipou = 'D' and u.id in (select unidad from icrel where contacto = '168347' and tipo in ('Titular', 'Inquilino', 'Contacto principal') and estado = 'Activo'); 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 ') and ( (abs(t.saldo) > 10 and t.moneda = 'ARS') or (abs(t.' at line 17 at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:190) at flexa.fb.LibDb.sqltoarrayddtotal(LibDb.java:125) at flexa.fb.LibDb.sqltoarray(LibDb.java:202) at flexa.fb.LibDb.call(LibDb.java:45) at flexa.fb.FContext.call(FContext.java:681) at flexa.fb.FContext.call(FContext.java:664) at flexa.fb.EFI.runBytecode(EFI.java:871) at flexa.fb.FComponent.event(FComponent.java:692) at flexa.ff.window.event(window.java:46) at flexa.fb.FComponent.executeEvent(FComponent.java:717) at flexa.fb.CompManager.processAction(CompManager.java:693) at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465) at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159) 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:1083) at flexa.fb.FComponent.event(FComponent.java:692) at flexa.ff.window.event(window.java:46) at flexa.fb.FComponent.executeEvent(FComponent.java:717) at flexa.fb.CompManager.processAction(CompManager.java:693) at flexa.fb.ComponentServlet.doGetOrPost(ComponentServlet.java:465) at flexa.fb.ComponentServlet.doGet(ComponentServlet.java:159) 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: datosBancarios=null labeltitulo=Novedades Recientes String que2=0 Long que1=0 Long estadounidad=En Obra String adhesiondebautomatico=N String labeldebito=Adherirse a débito automático String verselectorproyecto=true Boolean monedaobra1=ARS String _module=consorcios4 String ultimotalon=null cantidadmaxima=50 String saldoactual=null btntext=Novedades Archivadas String idnovedad=1425 Integer texto1=SU SALDO CON VENCIMENTO ES String cantunidades=1 Long monedaactual=USD String hayunidadposesion=0 Long component request_ _c=consorcios4/home String _v=992 String _x=onopen String _mv=970 String _h=U2lmRpNx3sQx0go3cLXK String _sessionid=U2lmRpNx3sQx0go3cLXK String _servername=miquartier.com.ar String _url=https://miquartier.com.ar/miquartier/ String u_ u_expensa=null String u_posesiones=0 Long u_proyecto=[2@emprendimientos4.emprendimiento] u_abierta=null String u_totalproyectos=1 Long s_ s_usuario=[168347@consorcios4.persona] s_loggedin=yes String s_abiertodesde=null s_perfil=Propietario String s_idcontacto=168347 Integer s_abiertohasta=null s_phpurl=https://.miquartier.com.ar/consorcios3/ String s_mesabierto=null s_expensasabiertas=null s_unidadrel=Titular String proyecto=2 String s_idunidad=15136 String s_unidad=[15136@unidades4.unidad] s_idusuario= String s_unidadestado=En Obra String g_ g_expensa=null g_base=.. String g_proyecto=null _e=uv1066_quartier String