ORACLE

16:36:18 [ajp-8009-1] ERROR org.openbravo.erpCommon.ad_reports.ReportShipmentDimensionalAnalyzeJRData - SQL error in query:       SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM(LINENETAMT) AS AMOUNT, SUM(MOVEMENTQTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(LINENETREF) AS AMOUNTREF, SUM(MOVEMENTQTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, '' AS ID, '' AS NAME      FROM (SELECT to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char( 'es_ES'))) AS NIVEL1, to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char('en_US'))||' ('||UOMSYMBOL||')') AS NIVEL2, to_char(C_ORDER.DOCUMENTNO) AS NIVEL3, to_char('') AS NIVEL4, to_char('') AS NIVEL5, to_char('') AS NIVEL6, to_char('') AS NIVEL7, to_char('') AS NIVEL8, to_char('') AS NIVEL9,       COALESCE(M_INOUTLINE.MOVEMENTQTY*C_ORDERLINE.PRICEACTUAL,NULL) AS LINENETAMT, M_INOUTLINE.MOVEMENTQTY, M_INOUTLINE.MOVEMENTQTY*M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS MOVEMENTQTYREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL      FROM M_INOUTLINE left join C_ORDERLINE on M_INOUTLINE.C_ORDERLINE_ID = C_ORDERLINE.C_ORDERLINE_ID,           M_INOUT left join AD_USER on M_INOUT.SALESREP_ID = AD_USER.AD_USER_ID,           C_BPARTNER left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID,       C_BP_GROUP,  M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM,  AD_ORG       WHERE M_INOUT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID      AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID      AND M_INOUT.M_INOUT_ID = M_INOUTLINE.M_INOUT_ID      AND M_INOUTLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID      AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID      AND M_INOUT.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID      AND M_INOUTLINE.C_UOM_ID = C_UOM.C_UOM_ID      AND M_INOUT.AD_ORG_ID = AD_ORG.AD_ORG_ID      AND M_INOUT.ISSOTRX = 'Y'      AND M_INOUT.PROCESSED = 'Y'      AND 0=0 AND M_INOUT.AD_ORG_ID IN (1000000,0)      AND M_INOUT.AD_CLIENT_ID IN (0,1000000)      AND 1=1 AND M_INOUT.MOVEMENTDATE >= TO_DATE(?)  AND M_INOUT.MOVEMENTDATE < TO_DATE(?) ) AA      GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9 HAVING SUM(MOVEMENTQTY) <> 0 ORDER BY NIVEL1,NIVEL1,NIVEL2,NIVEL3Exception:java.sql.SQLException: ORA-00904: "C_ORDER"."DOCUMENTNO": invalid identifier

16:36:18 [ajp-8009-1] ERROR org.openbravo.erpCommon.ad_reports.ReportShipmentDimensionalAnalyzeJR - Error captured: javax.servlet.ServletException: @CODE=904@ORA-00904: "C_ORDER"."DOCUMENTNO": invalid identifier


POSTGRESQL

17:57:18 [ajp-8009-4] ERROR org.openbravo.erpCommon.ad_reports.ReportShipmentDimensionalAnalyzeJRData - SQL error in query:       SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, SUM(LINENETAMT) AS AMOUNT, SUM(MOVEMENTQTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(LINENETREF) AS AMOUNTREF, SUM(MOVEMENTQTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, '' AS ID, '' AS NAME      FROM (SELECT to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char( 'es_ES'))) AS NIVEL1, to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char('en_US'))||' ('||UOMSYMBOL||')') AS NIVEL2, to_char(C_ORDER.DOCUMENTNO) AS NIVEL3, to_char('') AS NIVEL4, to_char('') AS NIVEL5, to_char('') AS NIVEL6, to_char('') AS NIVEL7, to_char('') AS NIVEL8, to_char('') AS NIVEL9,       COALESCE(M_INOUTLINE.MOVEMENTQTY*C_ORDERLINE.PRICEACTUAL,NULL) AS LINENETAMT, M_INOUTLINE.MOVEMENTQTY, M_INOUTLINE.MOVEMENTQTY*M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS MOVEMENTQTYREF, 0 AS WEIGHTREF, C_UOM.UOMSYMBOL      FROM M_INOUTLINE left join C_ORDERLINE on M_INOUTLINE.C_ORDERLINE_ID = C_ORDERLINE.C_ORDERLINE_ID,           M_INOUT left join AD_USER on M_INOUT.SALESREP_ID = AD_USER.AD_USER_ID,           C_BPARTNER left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID,       C_BP_GROUP,  M_PRODUCT, M_PRODUCT_CATEGORY, M_WAREHOUSE, C_UOM,  AD_ORG       WHERE M_INOUT.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID      AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID      AND M_INOUT.M_INOUT_ID = M_INOUTLINE.M_INOUT_ID      AND M_INOUTLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID      AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID      AND M_INOUT.M_WAREHOUSE_ID = M_WAREHOUSE.M_WAREHOUSE_ID      AND M_INOUTLINE.C_UOM_ID = C_UOM.C_UOM_ID      AND M_INOUT.AD_ORG_ID = AD_ORG.AD_ORG_ID      AND M_INOUT.ISSOTRX = 'Y'      AND M_INOUT.PROCESSED = 'Y'      AND 0=0 AND M_INOUT.AD_ORG_ID IN (1000000,0)      AND M_INOUT.AD_CLIENT_ID IN (0,1000000)      AND 1=1 AND M_INOUT.MOVEMENTDATE >= TO_DATE(?)  AND M_INOUT.MOVEMENTDATE < TO_DATE(?) ) AA      GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9 HAVING SUM(MOVEMENTQTY) <> 0 ORDER BY NIVEL1,NIVEL1,NIVEL2,NIVEL3Exception:org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry in subquery for table "c_order"
17:57:18 [ajp-8009-4] ERROR org.openbravo.erpCommon.ad_reports.ReportShipmentDimensionalAnalyzeJR - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: missing FROM-clause entry in subquery for table "c_order"