[java] 607  [main] INFO  org.openbravo.data.Sqlc - connect made
     [java] 783  [main] INFO  org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/info/InvoiceLine_data.xsql      processed
     [java] 957  [main] ERROR org.openbravo.data.Sqlc - SQL error in query:             SELECT B.*,
     [java]                     C_INVOICELINE_ID || '#' || (DOCUMENTNO || ' - ' || DATEINVOICED || ' - ' || GRANDTOTAL || ' - ' || LINE || ' - ' || LINENETAMT) AS ROWKEY,
     [java]             (DOCUMENTNO || ' - ' || DATEINVOICED || ' - ' || GRANDTOTAL || ' - ' || LINE || ' - ' || LINENETAMT) AS LINE_TEXT
     [java]             FROM ( SELECT
     [java] '0' AS RN1, A.* FROM (
     [java]               SELECT IL.C_INVOICELINE_ID, b.NAME AS BPARTNER_NAME, p.NAME AS PRODUCT_NAME, I.DATEINVOICED, I.DOCUMENTNO,
     [java]               I.ISSOTRX, IL.QTYINVOICED AS QTY, IL.PRICEACTUAL, IL.LINENETAMT,
     [java]               IL.LINE, I.GRANDTOTAL
     [java]               FROM C_INVOICE I, C_INVOICELINE IL, M_PRODUCT p, C_BPARTNER b
     [java]               WHERE I.C_INVOICE_ID = IL.C_INVOICE_ID
     [java]               AND I.C_BPARTNER_ID = b.C_BPARTNER_ID
     [java]               AND IL.M_PRODUCT_ID = p.M_PRODUCT_ID
     [java]               AND I.AD_CLIENT_ID IN (
     [java] '1')
     [java]               AND I.AD_ORG_ID IN (
     [java] '1')
     [java]               AND I.IsActive='Y'
     [java]  AND UPPER(IL.DocumentNo) LIKE UPPER(?)
     [java]  AND UPPER(I.Description) LIKE UPPER(?)
     [java]  AND UPPER(I.POReference) LIKE UPPER(?)
     [java]  AND I.C_BPartner_ID=?
     [java]  AND I.DATEINVOICED >= TO_DATE(?)
     [java]  AND I.DATEINVOICED < TO_DATE(?)
     [java]   AND IL.PRICEACTUAL*IL.QTYINVOICED >= TO_NUMBER(?)
     [java]   AND IL.PRICEACTUAL*IL.QTYINVOICED <= TO_NUMBER(?)
     [java]  AND IL.M_Product_ID=?
     [java]               AND I.ISSOTRX = 'Y'
     [java]               ORDER BY
     [java] b.NAME
     [java]             ) A ) B
     [java]         WHERE 1=1
     [java]
     [java] java.sql.SQLSyntaxErrorException: ORA-00904: "IL"."DOCUMENTNO": invalid identifier
     [java]
     [java]     at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
     [java]     at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
     [java]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
     [java]     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
     [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
     [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
     [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
     [java]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
     [java]     at org.openbravo.data.Sqlc.query(Sqlc.java:704)
     [java]     at org.openbravo.data.Sqlc.endElement(Sqlc.java:524)
     [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:331)
     [java]     at org.openbravo.data.Sqlc.listDir(Sqlc.java:256)
     [java]     at org.openbravo.data.Sqlc.listDir(Sqlc.java:235)
     [java]     at org.openbravo.data.Sqlc.listDir(Sqlc.java:235)
     [java]     at org.openbravo.data.Sqlc.listDir(Sqlc.java:235)
     [java]     at org.openbravo.data.Sqlc.listDir(Sqlc.java:235)
     [java]     at org.openbravo.data.Sqlc.main(Sqlc.java:180)
     [java] 1104 [main] INFO  org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/info/SalesOrderLine_data.xsql   processed
     [java] 1255 [main] INFO  org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/info/ShipmentReceiptLine_data.xsql      processed
     [java] 1469 [main] ERROR org.openbravo.data.Sqlc - 1 errors found!

BUILD FAILED
/mnt2/pagedatagrid/oracle/pi-pageddatagrid/build.xml:315: The following error occurred while executing this line:
/mnt2/pagedatagrid/oracle/pi-pageddatagrid/src/build.xml:146: Java returned: 1