Atif-Desktop AppsOpenbravo # ant compile -Dtab=Cus Buildfile: build.xml compile: init: wad: [java] 0 [main] INFO org.openbravo.wad.Wad - strFileProperties: /opt/OpenbravoERP-2.22/AppsOpenbravo/config/Openbravo.properties [java] 1 [main] INFO org.openbravo.wad.Wad - jsDateFormat: %d-%m-%Y [java] 1 [main] INFO org.openbravo.wad.Wad - sqlDateFormat: DD-MM-YYYY [java] 1 [main] INFO org.openbravo.wad.Wad - File connection: /opt/OpenbravoERP-2.22/AppsOpenbravo/config [java] 1 [main] INFO org.openbravo.wad.Wad - window: Cus [java] 1 [main] INFO org.openbravo.wad.Wad - directory destiny: /opt/OpenbravoERP-2.22/AppsOpenbravo/srcAD/org/openbravo/erpWindows [java] 1 [main] INFO org.openbravo.wad.Wad - directory reference: /opt/OpenbravoERP-2.22/AppsOpenbravo/srcAD/org/openbravo/erpCommon/reference [java] 1 [main] INFO org.openbravo.wad.Wad - directory web.xml: /opt/OpenbravoERP-2.22/AppsOpenbravo/build/javasqlc/src [java] 1 [main] INFO org.openbravo.wad.Wad - directory ActionButtons: /opt/OpenbravoERP-2.22/AppsOpenbravo/srcAD/org/openbravo/erpCommon/ad_actionButton [java] 1 [main] INFO org.openbravo.wad.Wad - generate web.xml: true [java] 1 [main] INFO org.openbravo.wad.Wad - generate web.xml cliente: /opt/OpenbravoERP-2.22/AppsOpenbravo/srcClient/web.xml [java] 1 [main] INFO org.openbravo.wad.Wad - generate tabs: true [java] 1 [main] INFO org.openbravo.wad.Wad - directory Translate : /opt/OpenbravoERP-2.22/AppsOpenbravo/src-loc [java] 2 [main] INFO org.openbravo.wad.Wad - translation to : org/openbravo/erpWindows [java] 2 [main] INFO org.openbravo.wad.Wad - Separador del Sistema: / [java] 2 [main] INFO org.openbravo.wad.Wad - Base path: /opt/OpenbravoERP-2.22/AppsOpenbravo [java] 2 [main] INFO org.openbravo.wad.Wad - Attach path: /opt/OpenbravoERP-2.22/AppsOpenbravo/attach [java] 2 [main] INFO org.openbravo.wad.Wad - Web path: http://202.92.17.47:8080/openbravo22/web [java] 2 [main] INFO org.openbravo.wad.Wad - Src path: /opt/OpenbravoERP-2.22/AppsOpenbravo/src [java] 2 [main] INFO org.openbravo.wad.Wad - complete: false [java] 3 [main] WARN org.openbravo.wad.Wad - Directorio no existente: /opt/OpenbravoERP-2.22/AppsOpenbravo/srcClient/web.xml [java] 17119 [main] INFO org.openbravo.wad.Wad - Procesing ActionButton_data.xml [java] 17269 [main] INFO org.openbravo.wad.Wad - Procesing ActionButtonXml [java] 17723 [main] INFO org.openbravo.wad.Wad - Procesing ActionButtonHtml [java] 18101 [main] INFO org.openbravo.wad.Wad - Procesing ActionButton_Responser.xml [java] 18261 [main] INFO org.openbravo.wad.Wad - Procesing ActionButtonXml Generics [java] 18337 [main] INFO org.openbravo.wad.Wad - Procesing ActionButtonHtml for generics [java] 19089 [main] INFO org.openbravo.wad.Wad - Procesing ActionButtonHtml - Translated [java] 19426 [main] INFO org.openbravo.wad.Wad - Procesing ActionButtonHtml for generics - Translated [java] 19517 [main] INFO org.openbravo.wad.Wad - Procesing web.xml [java] 20537 [main] INFO org.openbravo.wad.Wad - Processing Window: Cus_New_Carrier - Tab: New Carrier - id: 100000 [java] 21592 [main] WARN org.openbravo.wad.WadUtility - There're no table name or column name for: newcarrier_id - TABLE_NAME: newcarrier - COLUMN_NAME: [java] 22016 [main] WARN org.openbravo.wad.WadUtility - There're no table name or column name for: newcarrier_id - TABLE_NAME: newcarrier - COLUMN_NAME: [java] 22735 [main] INFO org.openbravo.wad.Wad - Processing Window: Custom Attribute - Tab: Custom Attribute - id: 335 [java] 25389 [main] INFO org.openbravo.wad.Wad - Processing Window: Invoice (Customer) - Tab: Invoice - id: 263 [java] 29625 [main] INFO org.openbravo.wad.Wad - Processing Window: Invoice (Customer) - Tab: Invoice Line - id: 270 [java] 33802 [main] INFO org.openbravo.wad.Wad - Processing Window: Invoice (Customer) - Tab: Invoice Tax - id: 271 [java] 36442 [main] INFO org.openbravo.wad.Wad - Processing Window: Invoice (Customer) - Tab: Debt/Payment - id: 800028 [java] 40077 [main] INFO org.openbravo.wad.Wad - Processing Window: Invoice (Customer) - Tab: Offers - id: 800223 [java] 42535 [main] INFO org.openbravo.wad.Wad - Processing Window: Shipment (Customer) - Tab: Shipment - id: 257 [java] 46320 [main] INFO org.openbravo.wad.Wad - Processing Window: Shipment (Customer) - Tab: Shipment Line - id: 258 postwad: [copy] Copying 122 files to /opt/OpenbravoERP-2.22/AppsOpenbravo/src-loc/design [copy] Copying 122 files to /opt/OpenbravoERP-2.22/AppsOpenbravo/src-loc/design copy.srcClient: sqlc: [java] 1 [main] INFO org.openbravo.data.Sqlc - strFileProperties: /opt/OpenbravoERP-2.22/AppsOpenbravo/config/Openbravo.properties [java] 1 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy [java] 2 [main] INFO org.openbravo.data.Sqlc - directory source: . [java] 2 [main] INFO org.openbravo.data.Sqlc - directory destiny: /opt/OpenbravoERP-2.22/AppsOpenbravo/build/javasqlc/src [java] 3 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql [java] 3 [main] INFO org.openbravo.data.Sqlc - file connection: /opt/OpenbravoERP-2.22/AppsOpenbravo/config/dbCon5.xml [java] 3 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false [java] 48 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver [java] 54 [main] INFO org.openbravo.data.Sqlc - Driver loaded [java] 150 [main] INFO org.openbravo.data.Sqlc - connect made buildAD: [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: /opt/OpenbravoERP-2.22/AppsOpenbravo/config/Openbravo.properties [java] 2 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy [java] 3 [main] INFO org.openbravo.data.Sqlc - directory source: ../srcAD [java] 3 [main] INFO org.openbravo.data.Sqlc - directory destiny: /opt/OpenbravoERP-2.22/AppsOpenbravo/build/javasqlc/src [java] 3 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql [java] 3 [main] INFO org.openbravo.data.Sqlc - file connection: /opt/OpenbravoERP-2.22/AppsOpenbravo/config/dbCon5.xml [java] 4 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false [java] 49 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver [java] 55 [main] INFO org.openbravo.data.Sqlc - Driver loaded [java] 151 [main] INFO org.openbravo.data.Sqlc - connect made [java] 251 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/CustomAttribute/CustomAttribute_data.xsql processed [java] 476 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/InvoiceCustomer/Invoice_data.xsql processed [java] 686 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/InvoiceCustomer/InvoiceLine_data.xsql processed [java] 799 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/InvoiceCustomer/InvoiceTax_data.xsql processed [java] 830 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/InvoiceCustomer/DebtPayment_data.xsql processed [java] 938 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/InvoiceCustomer/Offers_data.xsql processed [java] 1025 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ShipmentCustomer/Shipment_data.xsql processed [java] 1223 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/ShipmentCustomer/ShipmentLine_data.xsql processed [java] 1363 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/Cus_New_Carrier/NewCarrier_data.xsql processed [java] 1370 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] SELECT cus_brq_newcarrier.Comments, [java] cus_brq_newcarrier.Technical_Contact, [java] cus_brq_newcarrier.Carrier_Ip, [java] cus_brq_newcarrier.SBC_Ip, [java] cus_brq_newcarrier.Route_Prefix, [java] cus_brq_newcarrier.Codec, [java] cus_brq_newcarrier.Orig_Term, [java] cus_brq_newcarrier.Mode, [java] cus_brq_newcarrier.Protocol, [java] cus_brq_newcarrier.Newcarrier_Name, [java] cus_brq_newcarrier.newcarrier_id, [java] (CASE WHEN cus_brq_newcarrier.newcarrier_id IS NULL THEN '' ELSE () END) AS newcarrier_idR, [java] [java] '' AS TR_BGCOLOR , [java] cus_brq_newcarrier.Created, [java] cus_brq_newcarrier.CreatedBy, [java] cus_brq_newcarrier.Updated, [java] cus_brq_newcarrier.UpdatedBy, ? AS LANGUAGE [java] FROM cus_brq_newcarrier left join (select newcarrier_id from newcarrier) table1 on (cus_brq_newcarrier.newcarrier_id = table1.newcarrier_id) [java] WHERE 2=2 [java] AND 1=1 [java] AND cus_brq_newcarrier.AD_Client_ID IN ('1') [java] AND cus_brq_newcarrier.AD_Org_ID IN ('1') [java] [java] ORDER BY 1, 1 [java] [java] Exception:org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" [java] 1376 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] SELECT cus_brq_newcarrier.Comments, [java] cus_brq_newcarrier.Technical_Contact, [java] cus_brq_newcarrier.Carrier_Ip, [java] cus_brq_newcarrier.SBC_Ip, [java] cus_brq_newcarrier.Route_Prefix, [java] cus_brq_newcarrier.Codec, [java] cus_brq_newcarrier.Orig_Term, [java] cus_brq_newcarrier.Mode, [java] cus_brq_newcarrier.Protocol, [java] cus_brq_newcarrier.Newcarrier_Name, [java] cus_brq_newcarrier.newcarrier_id, [java] (CASE WHEN cus_brq_newcarrier.newcarrier_id IS NULL THEN '' ELSE () END) AS newcarrier_idR, [java] [java] cus_brq_newcarrier.Created, [java] cus_brq_newcarrier.CreatedBy, [java] cus_brq_newcarrier.Updated, [java] cus_brq_newcarrier.UpdatedBy, ? AS LANGUAGE [java] FROM cus_brq_newcarrier left join (select newcarrier_id from newcarrier) table1 on (cus_brq_newcarrier.newcarrier_id = table1.newcarrier_id) [java] WHERE 2=2 [java] [java] AND 1=1 [java] AND cus_brq_newcarrier.newcarrier_id = ? [java] Exception:org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" [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(Unknown Source) [java] at org.openbravo.data.Sqlc.endElement(Unknown Source) [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.DTDConfiguration.parse(Unknown Source) [java] at org.apache.xerces.parsers.DTDConfiguration.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(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.main(Unknown Source) [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" [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(Unknown Source) [java] at org.openbravo.data.Sqlc.endElement(Unknown Source) [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.DTDConfiguration.parse(Unknown Source) [java] at org.apache.xerces.parsers.DTDConfiguration.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(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.main(Unknown Source) [java] Exception in thread "main" java.lang.NullPointerException [java] at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.listDir(Unknown Source) [java] at org.openbravo.data.Sqlc.main(Unknown Source) [java] Java Result: 1 compileSqlc: [javac] Compiling 1 source file to /opt/OpenbravoERP-2.22/AppsOpenbravo/build/classes/src [javac] Compiling 8 source files to /opt/OpenbravoERP-2.22/AppsOpenbravo/build/classes/src [javac] Compiling 18 source files to /opt/OpenbravoERP-2.22/AppsOpenbravo/build/classes/src [javac] /opt/OpenbravoERP-2.22/AppsOpenbravo/srcAD/org/openbravo/erpWindows/Cus_New_Carrier/NewCarrier.java:324: expected [javac] vars.setSessionValue(windowId + "|", data[0].); [javac] ^ [javac] /opt/OpenbravoERP-2.22/AppsOpenbravo/srcAD/org/openbravo/erpWindows/Cus_New_Carrier/NewCarrier.java:324: ')' expected [javac] vars.setSessionValue(windowId + "|", data[0].); [javac] ^ [javac] 2 errors BUILD FAILED /opt/OpenbravoERP-2.22/AppsOpenbravo/build.xml:89: The following error occurred while executing this line: /opt/OpenbravoERP-2.22/AppsOpenbravo/src/build.xml:82: Compile failed; see the compiler error output for details. Total time: 1 minute 5 seconds Atif-Desktop AppsOpenbravo #