******** ERROR verunidad.onopen(215)
java.lang.Exception: ERROR unidades4/verunidad:verunidad.onopen(215) i695: java.sql.SQLException: select o.id from ocomobra as o
    cross join rcomobra as r on o.id = r.operacioncomercial
    cross join Unidadesobra as u on r.unidadId = u.id  
    cross join Unidades as u2 on u.emprendimientoId = u2.emprendimientoId and u.tipou = 'D' and u2.tipou = 'D' and u.denominacion = u2.denominacion
where 
    u2.id = '' and o.estado not in ('Anulada', 'Inactiva');
Table 'uv1066_quartier.Unidadesobra' doesn't exist

java.sql.SQLException: select o.id from ocomobra as o
    cross join rcomobra as r on o.id = r.operacioncomercial
    cross join Unidadesobra as u on r.unidadId = u.id  
    cross join Unidades as u2 on u.emprendimientoId = u2.emprendimientoId and u.tipou = 'D' and u2.tipou = 'D' and u.denominacion = u2.denominacion
where 
    u2.id = '' and o.estado not in ('Anulada', 'Inactiva');
Table 'uv1066_quartier.Unidadesobra' doesn't exist

	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)


******** ERROR detallestabla.onopen(-1)
SQL Error: select 
    distinct u.denominacion as unidad, 
u.notas as notasunidad,
if(t.descripcion like '%cesion%', '', t.descripcion) as concepto, 
    t.importe * -1 as importe,
    t.saldo * -1 as saldo,
    t.moneda as moneda
    
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 (t.descripcion in ('Gastos funcionamiento', 'Gastos de equipamiento', 'Ingresos Brutos') or t.descripcion like '%Posesi%')**/
    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'**/
    /** mostrar todos los saldos
    and     
        if(''= 1, 
            t.vencimiento < date_add('', interval '' day),
            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 = 'qbajo') 
    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.denominacion = '1 RIO 5 6'
    
/** group by 2, t.vencimiento **/
order by 2,t.vencimiento,t.id
Table 'uv1066_quartier.emtransobra' doesn't exist
 SQLSTATE 42S02

******** ERROR cuentacorrientetabla.onopen(-1)
SQL Error: select
    /** CUOTAS **/
    d.id as iddoc,
    t.id as idtctacte,
    t.vencimiento as fecha,
    concat(
        t.descripcion,
        ' ',
        ifnull(
            (
                select
                    group_concat(descripcion)
                from
                    emtransobra
                where
                    aplica = t.id
                    and tipo = 'V'
            ),
            ''
        )
    ) as descripcion,
    - t.importe as importe,
    t.moneda,
    t.id as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.moneda = 'ARS'
    and t.estado != 'ANULADA'
    and t.tipo = 'M'
    /** vencimientos de OV **/
    and (
        t.vencimiento <= date_add(current_date(), INTERVAL 30 DAY)
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dias ó ya pagado **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    /**
    and (
        '' = ''
        or t.contabilidad not in ("")
    )
    **/
    and t.descripcion not like 'honorarios%'
    and t.documento in (
        select
            id
        from
            emdocobra
        where
            ocom = ''
            and tipo = 'OV'
    )
    /** vencimientos de OV **/
    /**
     and d.empresa = (select empresa from Emprendimientos where id = (select emprendimiento from ocom where id = ''))
     
     and (if(t.tipo='M', t.vencimiento, d.fechaemision) <= date_add(current_date(), INTERVAL 15 DAY) 
     or t.tipo='C' or t.saldo != t.importe)
     and d.contacto not in (select id from cmcont where razonsocial like '%CLIENTES%')
     and t.estado != 'ANULADA'
     **/
union
all
select
    /** CONCEPTOS DE RECIBOS **/
    d.id as iddoc,
    t.id as idtctacte,
    d.fechaemision as fecha,
    /** concat(d.descripcion, '<br>', group_concat(left(t.descripcion, 30))) as descripcion, **/
    d.descripcion as descripcion,
    sum(
        if(
            t.moneda = 'ARS',
            t.importe,
            t.importe / (
                select
                    tipocambio
                from
                    emtransobra
                where
                    id = t.aplica
            )
        )
    ) as importe,
    /** t.moneda, **/
    'ARS' as moneda,
    999999999999 as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.tipo = 'C'
    /** conceptos de RC **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    and t.descripcion not like 'honorarios%'
    and (
        d.sucursal not in ('99', '98')
        or d.sucursal is null
    )
    and (
        t.aplica in (
            /** quien aplique a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t3
            where
                t3.moneda = 'ARS'
                and t3.documento in (
                    select
                        id
                    from
                        emdocobra
                    where
                        ocom = ''
                        and tipo = 'OV'
                )
        )
        or t.aplica in (
            /** quien aplique a vencimientos de facturas que apliquen a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t4
            where
                t4.tipo = 'V'
                and t4.aplica in (
                    select
                        id
                    from
                        emtransobra as t3
                    where
                        t3.moneda = 'ARS'
                        and t3.documento in (
                            select
                                id
                            from
                                emdoc
                            where
                                ocom = ''
                                and tipo = 'OV'
                        )
                )
        )
    )
group by
    d.id
order by
    fecha,
    orden
Table 'uv1066_quartier.emtransobra' doesn't exist
 SQLSTATE 42S02

******** ERROR cuentacorrienteusdtabla.onopen(-1)
SQL Error: select
    /** CUOTAS **/
    d.id as iddoc,
    t.id as idtctacte,
    t.vencimiento as fecha,
    concat(
        t.descripcion,
        ' ',
        ifnull(
            (
                select
                    group_concat(descripcion)
                from
                    emtransobra
                where
                    aplica = t.id
                    and tipo = 'V'
            ),
            ''
        )
    ) as descripcion,
    - t.importe as importe,
    t.moneda,
    t.id as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.moneda = 'USD'
    and t.estado != 'ANULADA'
    and t.tipo = 'M'
    /** vencimientos de OV **/
    and (
        t.vencimiento <= date_add(current_date(), INTERVAL 30 DAY)
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dias ó ya pagado **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    /**
    and (
        '' = ''
        or t.contabilidad not in ("")
    )
    **/
    and t.descripcion not like 'honorarios%'
    and t.documento in (
        select
            id
        from
            emdocobra
        where
            ocom = ''
            and tipo = 'OV'
    )
    /** vencimientos de OV **/
    /**
     and d.empresa = (select empresa from Emprendimientos where id = (select emprendimiento from ocom where id = ''))
     
     and (if(t.tipo='M', t.vencimiento, d.fechaemision) <= date_add(current_date(), INTERVAL 15 DAY) 
     or t.tipo='C' or t.saldo != t.importe)
     and d.contacto not in (select id from cmcont where razonsocial like '%CLIENTES%')
     and t.estado != 'ANULADA'
     **/
union
all
select
    /** CONCEPTOS DE RECIBOS **/
    d.id as iddoc,
    t.id as idtctacte,
    d.fechaemision as fecha,
    /** concat(d.descripcion, '<br>', group_concat(left(t.descripcion, 30))) as descripcion, **/
    d.descripcion as descripcion,
    sum(
        if(
            t.moneda = 'USD',
            t.importe,
            t.importe / (
                select
                    tipocambio
                from
                    emtransobra
                where
                    id = t.aplica
            )
        )
    ) as importe,
    /** t.moneda, **/
    'USD' as moneda,
    999999999999 as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.tipo = 'C'
    /** conceptos de RC **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    and t.descripcion not like 'honorarios%'
    and (
        d.sucursal not in ('99', '98')
        or d.sucursal is null
    )
    and (
        t.aplica in (
            /** quien aplique a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t3
            where
                t3.moneda = 'USD'
                and t3.documento in (
                    select
                        id
                    from
                        emdocobra
                    where
                        ocom = ''
                        and tipo = 'OV'
                )
        )
        or t.aplica in (
            /** quien aplique a vencimientos de facturas que apliquen a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t4
            where
                t4.tipo = 'V'
                and t4.aplica in (
                    select
                        id
                    from
                        emtransobra as t3
                    where
                        t3.moneda = 'USD'
                        and t3.documento in (
                            select
                                id
                            from
                                emdoc
                            where
                                ocom = ''
                                and tipo = 'OV'
                        )
                )
        )
    )
group by
    d.id
order by
    fecha,
    orden
Table 'uv1066_quartier.emtransobra' doesn't exist
 SQLSTATE 42S02

CONTEXT:
codigounidad=  <i><small>String</small></i>
ingresointranet=null
texttitular=Cuando la unidad esté habitada podrá solicitar cambio de titular  <i><small>String</small></i>
textemg=Cuando la unidad esté habitada podrá registrar contactos de emergencia  <i><small>String</small></i>
inhreserva=btn-flat-success  <i><small>String</small></i>
visual=none  <i><small>String</small></i>
id=11823  <i><small>String</small></i>
alquilerespendientesnoconfirmados=0  <i><small>Long</small></i>
countcocheras3=0  <i><small>Long</small></i>
urlintranet=http://www.quartierdelbajo.com  <i><small>String</small></i>
tempdenominacion=1 CIUDAD 2 6  <i><small>String</small></i>
textmasc=Cuando la unidad esté habitada podrá registrar mascotas  <i><small>String</small></i>
title2=Torre: 1 CIUDAD 2 6()  <i><small>String</small></i>
_module=unidades4  <i><small>String</small></i>
tempdepartamento=6  <i><small>String</small></i>
textveh=Cuando la unidad esté habitada podrá registrar sus vehiculos  <i><small>String</small></i>
cantmascotas=0  <i><small>Long</small></i>
completadoinquilino=N  <i><small>String</small></i>
cantidad=0  <i><small>Long</small></i>
completado=S  <i><small>String</small></i>
permisosparaseguridadverinfocliente=N  <i><small>String</small></i>
textores=Habilitar Reservas  <i><small>String</small></i>
claveinquilino=null
cantalqprox=0  <i><small>Long</small></i>
total_registros_vehiculos=0  <i><small>Long</small></i>
ultimoingresoinquilino=null
estadounidad=  <i><small>panel</small></i>
textalquileres=Cuando la unidad esté habitada podrá agregar alquileres a su unidad  <i><small>String</small></i>
textotros=Cuando la unidad esté habitada podrá registrar autorizados  <i><small>String</small></i>
textresi=Cuando la unidad esté habitada podrá registrar residentes  <i><small>String</small></i>
temppiso=2  <i><small>String</small></i>
inhabilitareserva=null
today=Fri Dec 20 13:44:08 UTC 2024  <i><small>Date</small></i>
temptorre2=Torre: 1 CIUDAD  <i><small>String</small></i>
ultimoingreso=null
textinq=Cuando la unidad esté habitada podrá registrar inquilinos  <i><small>String</small></i>
clave=null
temptorre=1 CIUDAD  <i><small>String</small></i>
total_registros_emergencia=0  <i><small>Long</small></i>
unamoneda=ARS  <i><small>String</small></i>
saldo=null
disablecambiarestado=  <i><small>String</small></i>
textcont=Cuando la unidad esté habitada podrá registrar contactos principales  <i><small>String</small></i>
tempcodigo=  <i><small>String</small></i>
denominacion=1 CIUDAD 2 6  <i><small>String</small></i>
disable=disable  <i><small>String</small></i>
alquiler=null
textserv=Cuando la unidad esté habitada podrá registrar personal de servicio  <i><small>String</small></i>
idalquiler=null
tempdenominacion2=Denominacion: 1 CIUDAD 2 6  <i><small>String</small></i>
days=30  <i><small>Long</small></i>
<b>component</b>


<b>request_</b>
     idunidad=11823  <i><small>String</small></i>
     _c=unidades4/verunidad  <i><small>String</small></i>
     _v=6140  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _mv=939  <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_posesiones=0  <i><small>Long</small></i>
     u_proyecto=[qbajo@emprendimientos4.emprendimiento]
     u_totalproyectos=2  <i><small>Long</small></i>


<b><red>s_</red></b>
     s_usuario=[101677@consorcios4.persona]
     s_loggedin=yes  <i><small>String</small></i>
     s_perfil=Superusuario  <i><small>String</small></i>
     s_verreservaamenitie=S  <i><small>String</small></i>
     s_idcontacto=  <i><small>String</small></i>
     s_phpurl=https://qbajo.flexaconsorcios.com/consorcios3/  <i><small>String</small></i>
     s_unidadrel=  <i><small>String</small></i>
     proyecto=qbajo  <i><small>String</small></i>
     s_estadoperfil=Activo  <i><small>String</small></i>
     s_idunidad=null
     s_mudanza=157177  <i><small>Integer</small></i>
     s_unidad=null
     s_idusuario=101677  <i><small>Integer</small></i>
     s_unidadestado=  <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>