******** ERROR expensas.onopen(100)
java.lang.Exception: ERROR expensas4/index:expensas.onopen(100) i391: java.sql.SQLException: select 
    FORMAT(
    	ifnull((select sum(ifnull(importe,0))  from gcbalance where emprendimiento = emcuenta.emprendimiento and mes = '-01' /*and relacion = emcuenta.id*/ and concepto like 'saldo inicial%' ),0) /* saldo_inicial*/
        +
        ifnull((select sum(ifnull(-importe,0)) from  trans where  tipo = 'P' and descripcion like 'Su pago%' and emprendimiento = emcuenta.emprendimiento and fecha between '' and '' /*and cuenta = emcuenta.id*/ ),0) /** ingresos por expensas **/
        +
        ifnull((select sum(ifnull(-pagos,0))   from icgastos where emprendimiento = emcuenta.emprendimiento and presentacion = '-01' and pfecha between '' and ''  and estado = 'pagado' /*and pbanco = emcuenta.id*/),0) /** egresos pago a proveedores **/
        +
        ifnull((select sum(ifnull(-importe,0)) from trans where tipo = 'M' and emprendimiento = emcuenta.emprendimiento and fecha between '' and '' /*and origen = emcuenta.id*/ and importe < 0 ),0) /** otros movimientos de la cuenta EGRESOS **/
        +   
        ifnull((select  sum(ifnull(importe,0))  from trans where tipo = 'M' and emprendimiento = emcuenta.emprendimiento and fecha between '' and '' /*and destino = emcuenta.id*/ and importe > 0) ,0) /** otros movimientos de la cuenta INGRESOS **/
    ,2,'es_AR')  from 
    emcuenta 
where 
	emprendimiento = 'qbajo';
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

java.sql.SQLException: select 
    FORMAT(
    	ifnull((select sum(ifnull(importe,0))  from gcbalance where emprendimiento = emcuenta.emprendimiento and mes = '-01' /*and relacion = emcuenta.id*/ and concepto like 'saldo inicial%' ),0) /* saldo_inicial*/
        +
        ifnull((select sum(ifnull(-importe,0)) from  trans where  tipo = 'P' and descripcion like 'Su pago%' and emprendimiento = emcuenta.emprendimiento and fecha between '' and '' /*and cuenta = emcuenta.id*/ ),0) /** ingresos por expensas **/
        +
        ifnull((select sum(ifnull(-pagos,0))   from icgastos where emprendimiento = emcuenta.emprendimiento and presentacion = '-01' and pfecha between '' and ''  and estado = 'pagado' /*and pbanco = emcuenta.id*/),0) /** egresos pago a proveedores **/
        +
        ifnull((select sum(ifnull(-importe,0)) from trans where tipo = 'M' and emprendimiento = emcuenta.emprendimiento and fecha between '' and '' /*and origen = emcuenta.id*/ and importe < 0 ),0) /** otros movimientos de la cuenta EGRESOS **/
        +   
        ifnull((select  sum(ifnull(importe,0))  from trans where tipo = 'M' and emprendimiento = emcuenta.emprendimiento and fecha between '' and '' /*and destino = emcuenta.id*/ and importe > 0) ,0) /** otros movimientos de la cuenta INGRESOS **/
    ,2,'es_AR')  from 
    emcuenta 
where 
	emprendimiento = 'qbajo';
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

	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:
cantabiertas=0  <i><small>Long</small></i>
acumulado=0  <i><small>Long</small></i>
titulomes2=Expensas Noviembre 2024  <i><small>String</small></i>
timportecobranza=null
deudames=null
totalproveedor=null
saldomoneda1=3855387.379999999888241291046142578125  <i><small>BigDecimal</small></i>
_module=expensas4  <i><small>String</small></i>
count_avisos=185  <i><small>Long</small></i>
tsalcuent=null
cantunidades=1  <i><small>Long</small></i>
mes=2024-11  <i><small>String</small></i>
<b>component</b>


<b>request_</b>
     _c=expensas4/index  <i><small>String</small></i>
     _v=154  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _mv=956  <i><small>String</small></i>
     _h=U2lmRpNx3sQx0go3cLXK  <i><small>String</small></i>
     _sessionid=U2lmRpNx3sQx0go3cLXK  <i><small>String</small></i>
     _servername=miquartier.com.ar  <i><small>String</small></i>
     _url=https://miquartier.com.ar/miquartier/index.html  <i><small>String</small></i>


<b><red>u_</red></b>
     u_expensa=null  <i><small>String</small></i>
     u_posesiones=0  <i><small>Long</small></i>
     u_proyecto=[qbajo@emprendimientos4.emprendimiento]
     u_abierta=null  <i><small>String</small></i>
     u_totalproyectos=1  <i><small>Long</small></i>


<b><red>s_</red></b>
     s_usuario=[168375@consorcios4.persona]
     s_loggedin=yes  <i><small>String</small></i>
     s_perfil=Propietario  <i><small>String</small></i>
     s_idcontacto=168375  <i><small>Integer</small></i>
     s_phpurl=https://.miquartier.com.ar/consorcios3/  <i><small>String</small></i>
     s_cerradohasta=2024-11-30  <i><small>Date</small></i>
     s_unidadrel=Titular  <i><small>String</small></i>
     proyecto=qbajo  <i><small>String</small></i>
     s_idunidad=12177  <i><small>Integer</small></i>
     s_cerradodesde=2024-11-01  <i><small>Date</small></i>
     s_mescerrado=2024-11  <i><small>String</small></i>
     s_mudanza=157177  <i><small>Integer</small></i>
     s_unidad=[12177@unidades4.unidad]
     s_idusuario=  <i><small>String</small></i>
     s_unidadestado=Deshabitada  <i><small>String</small></i>


<b><red>g_</red></b>
     g_expensa=null
     g_base=..  <i><small>String</small></i>
     g_proyecto=null
     _e=uv1066_quartier  <i><small>String</small></i>