Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035711Retail ModulesWeb POS Hardware Managerpublic2017-04-04 10:312017-05-02 11:58
Reporterranjith_qualiantech_com 
Assigned Tojorge-garcia 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR17Q2Fixed in VersionRR17Q2 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035711: Error in OrderGroupingProcessor in Oracle 11
DescriptionIn 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)
Steps To Reproduce1) Create pi retail instance with oracle 11
2) Create Several Tickets
3) Do Cashup

Error occurs in backoffice
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0035680 closed jorge-garcia Error in OrderGroupingProcessor in Oracle 11 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-04-06 12:32marvintmTypedefect => backport
2017-04-06 12:32marvintmTarget Version => RR17Q2
2017-04-27 10:02hgbotCheckin
2017-04-27 10:02hgbotNote Added: 0096212
2017-04-27 10:02hgbotStatusscheduled => resolved
2017-04-27 10:02hgbotResolutionopen => fixed
2017-04-27 10:02hgbotFixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR17Q2/org.openbravo.retail.posterminal/rev/2a9fc0a890d8cfdb784b3a47c6c232e27e60cc6f [^]
2017-04-27 10:03jorge-garciaAssigned ToRetail => jorge-garcia
2017-05-02 11:58guilleaerReview Assigned To => guilleaer
2017-05-02 11:58guilleaerStatusresolved => closed
2017-05-02 11:58guilleaerFixed in Version => RR17Q2

Notes
(0096212)
hgbot   
2017-04-27 10:02   
Repository: retail/backports/3.0RR17Q2/org.openbravo.retail.posterminal
Changeset: 2a9fc0a890d8cfdb784b3a47c6c232e27e60cc6f
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Wed Apr 26 13:11:06 2017 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR17Q2/org.openbravo.retail.posterminal/rev/2a9fc0a890d8cfdb784b3a47c6c232e27e60cc6f [^]

Fixed issue 35711: Error in OrderGroupingProcessor in Oracle 11

Fixed query for order grouping processor from cashup.

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor_data.xsql
---