******** ERROR unidad.onopen(5)
java.lang.Exception: ERROR emprendimientos4/unidad:unidad.onopen(5) i60: java.sql.SQLException: select id as idunidad, torre, piso, departamento, plano, status, superficieM2, superficieTotal, superficieCocheras, superficieBauleras,
dormitorios, cocheras, cochera1M2, cochera2M2, cochera3M2, precio, superficieCub, superficieDesc,
porcentajeCosto, superficieSemiCubierta, denominacion, notas, moneda, planocontrato, ambientes, vencimiento,
if(ifnull(Unidades.plano, '')!='',
(select archivo from planos where id = Unidades.plano),
(select planos.archivo from grupos cross join planosgrupos on grupos.id = planosgrupos.grupo cross join planos on planosgrupos.plano = planos.id
where grupos.emprendimientoid = Unidades.emprendimientoId and grupos.codigo = Unidades.grupo limit 1)
) as archivoplan, preciototal as precioTotalUnidad, precioTotalUsd, precioTotalLocal
from Unidades where id = '16024';
Unknown column 'precioTotalUsd' in 'field list'
java.sql.SQLException: select id as idunidad, torre, piso, departamento, plano, status, superficieM2, superficieTotal, superficieCocheras, superficieBauleras,
dormitorios, cocheras, cochera1M2, cochera2M2, cochera3M2, precio, superficieCub, superficieDesc,
porcentajeCosto, superficieSemiCubierta, denominacion, notas, moneda, planocontrato, ambientes, vencimiento,
if(ifnull(Unidades.plano, '')!='',
(select archivo from planos where id = Unidades.plano),
(select planos.archivo from grupos cross join planosgrupos on grupos.id = planosgrupos.grupo cross join planos on planosgrupos.plano = planos.id
where grupos.emprendimientoid = Unidades.emprendimientoId and grupos.codigo = Unidades.grupo limit 1)
) as archivoplan, preciototal as precioTotalUnidad, precioTotalUsd, precioTotalLocal
from Unidades where id = '16024';
Unknown column 'precioTotalUsd' in 'field list'
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: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=emprendimientos4 String
unidadcedidaventa=2 Long
monedalocal=ARS String
component
request_
_c=emprendimientos4/unidad String
_popup= String
_v=547 String
_ip=127.0.0.1 String
_x=onopen String
_mv=1473 String
_h=aLvXe9qHMvSgM07LS3qf String
_sessionid=aLvXe9qHMvSgM07LS3qf String
_servername=66.97.46.32 String
id=16024 String
_url=http://66.97.46.32/app/index.html String
u_
u_expensa=null String
u_posesiones=0 Long
u_proyecto=[3@emprendimientos4.emprendimiento]
u_abierta=null String
u_totalproyectos=6 Long
s_
s_usuario=[101677@consorcios4.persona]
s_loggedin=yes String
s_perfil=Superusuario String
s_idcontacto= String
s_cerradohasta=2025-03-31 Date
s_unidadrel= String
proyecto=3 String
s_idunidad=null
s_cerradodesde=2025-03-01 Date
s_mescerrado=2025-03 String
s_unidad=null
s_idusuario=101677 Integer
s_unidadestado= String
g_
g_base=http://66.97.46.32 String
g_sidebarbgcolor=#ccc String
g_estilosadicionales=null
_e=uv1066_quartier String
g_sidebarcolor=#fff String
g_sidebarposition=Nuevo String