Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #35680 [ All Revisions ] [ Back to Issue ]
Summary 0035680: Error in OrderGroupingProcessor in Oracle 11
Revision 2017-04-04 10:34 by ranjith_qualiantech_com
Description In Oracle 11 instance, If cashup is done after several tickets is completed, Error occurs in OrderGroupingProcessorData.java as below
https://ci.openbravo.com/job/try-ret-test-oracle-suite1/6519/console [^]
[java] 623 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: select ol.c_orderline_id, o.c_order_id, '' as c_invoice_id
     [java] from c_orderline ol
     [java] join c_order o on ol.c_order_id = o.c_order_id
     [java] where (select count(1) from m_inoutline il where il.c_orderline_id = ol.c_orderline_id) > 1
     [java] and o.em_obpos_app_cashup_id = ?
     [java] and exists (select 1 from c_invoice ci join c_invoiceline cl on ci.c_invoice_id = cl.c_invoice_id
     [java] and cl.c_orderline_id = ol.c_orderline_id and ci.description like ('%' || ? || '%'))
     [java]
     [java] java.sql.SQLSyntaxErrorException: ORA-00904: "OL"."C_ORDERLINE_ID": invalid identifier
     [java]
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
     [java] at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573)
     [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     [java] at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:98)
     [java] at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:794)
     [java] at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:3944)
     [java] at oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:56)
     [java] at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:4312)
     [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.getMetaData(OraclePreparedStatementWrapper.java:1499)
     [java] at org.openbravo.data.Sqlc.query(Sqlc.java:745)
     [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:563)
     [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:358)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:281)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:266)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:271)
     [java] at org.openbravo.data.Sqlc.main(Sqlc.java:208)
     [java] 631 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLRecoverableException: Closed Statement
     [java] 632 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLRecoverableException: Closed Statement
     [java] 634 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:
     [java] java.sql.SQLRecoverableException: Closed Statement
     [java] at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4023)
     [java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1909)
     [java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:136)
     [java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:388)
     [java] at org.openbravo.data.Sqlc.printSQLReadResultRow(Sqlc.java:1602)
     [java] at org.openbravo.data.Sqlc.printFunctionSql(Sqlc.java:1457)
     [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:573)
     [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:358)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:281)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:266)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:271)
     [java] at org.openbravo.data.Sqlc.main(Sqlc.java:208)
Revision 2017-04-04 10:33 by ranjith_qualiantech_com
Description In Oracle 11 instance, If cashup is done after several tickets is completed, Error occurs in OrderGroupingProcessorData.java as below
[java] 623 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: select ol.c_orderline_id, o.c_order_id, '' as c_invoice_id
     [java] from c_orderline ol
     [java] join c_order o on ol.c_order_id = o.c_order_id
     [java] where (select count(1) from m_inoutline il where il.c_orderline_id = ol.c_orderline_id) > 1
     [java] and o.em_obpos_app_cashup_id = ?
     [java] and exists (select 1 from c_invoice ci join c_invoiceline cl on ci.c_invoice_id = cl.c_invoice_id
     [java] and cl.c_orderline_id = ol.c_orderline_id and ci.description like ('%' || ? || '%'))
     [java]
     [java] java.sql.SQLSyntaxErrorException: ORA-00904: "OL"."C_ORDERLINE_ID": invalid identifier
     [java]
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
     [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
     [java] at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573)
     [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     [java] at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:98)
     [java] at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:794)
     [java] at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:3944)
     [java] at oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:56)
     [java] at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:4312)
     [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.getMetaData(OraclePreparedStatementWrapper.java:1499)
     [java] at org.openbravo.data.Sqlc.query(Sqlc.java:745)
     [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:563)
     [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:358)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:281)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:266)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:271)
     [java] at org.openbravo.data.Sqlc.main(Sqlc.java:208)
     [java] 631 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLRecoverableException: Closed Statement
     [java] 632 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:java.sql.SQLRecoverableException: Closed Statement
     [java] 634 [main] ERROR org.openbravo.data.Sqlc - SQL Exception error:
     [java] java.sql.SQLRecoverableException: Closed Statement
     [java] at oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:4023)
     [java] at oracle.jdbc.driver.OracleStatement.getNumberOfColumns(OracleStatement.java:1909)
     [java] at oracle.jdbc.driver.OracleResultSetMetaData.getValidColumnIndex(OracleResultSetMetaData.java:136)
     [java] at oracle.jdbc.driver.OracleResultSetMetaData.getColumnType(OracleResultSetMetaData.java:388)
     [java] at org.openbravo.data.Sqlc.printSQLReadResultRow(Sqlc.java:1602)
     [java] at org.openbravo.data.Sqlc.printFunctionSql(Sqlc.java:1457)
     [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:573)
     [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:358)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:281)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:260)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:266)
     [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:271)
     [java] at org.openbravo.data.Sqlc.main(Sqlc.java:208)

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker