You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
===========> MLookup.run: M_Component.FTU_Component_ID, 82476 : Loader - SELECT M_Component.FTU_Component_ID,NULL,NVL((SELECT M_Product.value || ' ' || M_AttributeSetInstance.Description FROM M_Product, M_AttributeSetInstance WHERE M_Product.M_Product_ID = FTU_Component.M_Product_ID AND M_AttributeSetInstance.M_AttributeSetInstance_ID = FTU_Component.M_AttributeSetInstance_ID),'-1'),M_Component.IsActive FROM M_Component WHERE M_Component.AD_Client_ID IN (0,1000000) AND NOT EXISTS (SELECT FTU_ComponentBOMLine.FTU_Component_ID FROM FTU_ComponentBOMLine WHERE FTU_ComponentBOMLine.FTU_Component_ID=FTU_Component.FTU_Component_ID) ORDER BY 3 [2067]
org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "ftu_component"
Position: 190; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at com.sun.proxy.$Proxy2.executeQuery(Unknown Source)
at org.compiere.model.MLookup$MLoader.run(MLookup.java:768)
The text was updated successfully, but these errors were encountered:
Error loading Fleet Management Page
===========> MLookup.run: M_Component.FTU_Component_ID, 82476 : Loader - SELECT M_Component.FTU_Component_ID,NULL,NVL((SELECT M_Product.value || ' ' || M_AttributeSetInstance.Description FROM M_Product, M_AttributeSetInstance WHERE M_Product.M_Product_ID = FTU_Component.M_Product_ID AND M_AttributeSetInstance.M_AttributeSetInstance_ID = FTU_Component.M_AttributeSetInstance_ID),'-1'),M_Component.IsActive FROM M_Component WHERE M_Component.AD_Client_ID IN (0,1000000) AND NOT EXISTS (SELECT FTU_ComponentBOMLine.FTU_Component_ID FROM FTU_ComponentBOMLine WHERE FTU_ComponentBOMLine.FTU_Component_ID=FTU_Component.FTU_Component_ID) ORDER BY 3 [2067]
org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "ftu_component"
Position: 190; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at com.sun.proxy.$Proxy2.executeQuery(Unknown Source)
at org.compiere.model.MLookup$MLoader.run(MLookup.java:768)
The text was updated successfully, but these errors were encountered: