[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