[java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: /home/usuario/Openbravos/OB235/openbravo/config/Openbravo.properties [java] 1 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy [java] 1 [main] INFO org.openbravo.data.Sqlc - directory source: . [java] 1 [main] INFO org.openbravo.data.Sqlc - directory destiny: /home/usuario/Openbravos/OB235/openbravo/build/javasqlc/src [java] 2 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql [java] 2 [main] INFO org.openbravo.data.Sqlc - file connection: /home/usuario/Openbravos/OB235/openbravo/config/dbCon5.xml [java] 2 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false [java] 62 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver [java] 66 [main] INFO org.openbravo.data.Sqlc - Driver loaded [java] 132 [main] INFO org.openbravo.data.Sqlc - connect made [java] 1029 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ws/externalSales/ExternalSalesProduct_data.xsql processed [java] 1421 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] [java] SELECT M_PRODUCT.M_PRODUCT_ID AS ID, M_PRODUCT.NAME AS NAME, [java] M_PRODUCT.VALUE AS NUMBER1, M_PRODUCT.DESCRIPTION AS DESCRIPTION, [java] M_PRODUCTPRICE.PRICESTD AS LIST_PRICE, COALESCE(Get_Purchase_Price(M_PRODUCT.M_PRODUCT_ID),0) AS PURCHASE_PRICE, [java] C_TAX.C_TAX_ID AS TAX_ID, C_TAX.NAME AS TAX_NAME, C_TAX.RATE AS PERCENTAGE, [java] M_PRODUCT.IMAGEURL AS IMAGE_URL, M_PRODUCT.UPC AS EAN, [java] M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID AS M_PRODUCT_CATEGORY_ID, M_PRODUCT_CATEGORY.NAME AS M_PRODUCT_CATEGORY_NAME, [java] M_PRODUCT_CATEGORY.DESCRIPTION AS M_PRODUCT_CATEGORY_DESCRIPTION [java] FROM C_EXTERNALPOS CEPOS, M_PRODUCT, M_PRODUCT_CATEGORY, C_TAX, C_TAXCATEGORY, M_PRODUCTPRICE [java] WHERE CEPOS.AD_CLIENT_ID = TO_NUMBER(?) [java] AND CEPOS.VALUE = TO_NUMBER(?) [java] AND CEPOS.ISACTIVE = 'Y' [java] AND M_PRODUCT.C_TAXCATEGORY_ID = C_TAXCATEGORY.C_TAXCATEGORY_ID [java] AND C_TAXCATEGORY.C_TAXCATEGORY_ID = C_TAX.C_TAXCATEGORY_ID [java] AND M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID [java] AND M_PRODUCTPRICE.AD_CLIENT_ID= CEPOS.AD_CLIENT_ID [java] AND M_PRODUCTPRICE.ISACTIVE = 'Y' [java] AND M_PRODUCTPRICE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID [java] AND M_PRODUCTPRICE.M_PRICELIST_VERSION_ID = Get_Pricelist_Version(CEPOS.M_PRICELIST_ID, now()) [java] AND ((COALESCE(CEPOS.INCLUDE_PRODUCT_CATEGORY,'Y') = 'N' [java] AND EXISTS (SELECT 1 FROM C_EXTERNALPOS_CATEGORY CEPOS_CAT [java] WHERE CEPOS_CAT.C_EXTERNALPOS_ID = CEPOS.C_EXTERNALPOS_ID [java] AND CEPOS_CAT.M_PRODUCT_CATEGORY_ID = M_PRODUCT.M_PRODUCT_CATEGORY_ID)) OR [java] (COALESCE(CEPOS.INCLUDE_PRODUCT_CATEGORY,'Y') = 'Y' [java] AND NOT EXISTS (SELECT 1 FROM C_EXTERNALPOS_CATEGORY CEPOS_CAT [java] WHERE CEPOS_CAT.C_EXTERNALPOS_ID = CEPOS.C_EXTERNALPOS_ID [java] AND CEPOS_CAT.M_PRODUCT_CATEGORY_ID = M_PRODUCT.M_PRODUCT_CATEGORY_ID))) [java] AND ((COALESCE(CEPOS.INCLUDE_PRODUCT,'Y') = 'N' [java] AND EXISTS (SELECT 1 FROM C_EXTERNALPOS_PRODUCT CEPOS_PROD [java] WHERE CEPOS_PROD.C_EXTERNALPOS_ID = CEPOS.C_EXTERNALPOS_ID [java] AND CEPOS_PROD.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID)) OR [java] (COALESCE(CEPOS.INCLUDE_PRODUCT,'Y') = 'Y' [java] AND NOT EXISTS (SELECT 1 FROM C_EXTERNALPOS_PRODUCT CEPOS_PROD [java] WHERE CEPOS_PROD.C_EXTERNALPOS_ID = CEPOS.C_EXTERNALPOS_ID [java] org.postgresql.util.PSQLException: ERROR: no existe la función get_pricelist_version(numeric, timestamp with time zone) [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250) [java] at org.openbravo.data.Sqlc.query(Sqlc.java:504) [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:408) [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:236) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:183) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.main(Sqlc.java:162) [java] Exception in thread "main" java.lang.NullPointerException [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:252) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:183) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:179) [java] at org.openbravo.data.Sqlc.main(Sqlc.java:162) [java] AND CEPOS_PROD.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID))) [java] [java] Exception:org.postgresql.util.PSQLException: ERROR: no existe la función get_pricelist_version(numeric, timestamp with time zone) [java] Java Result: 1