Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035680Retail ModulesWeb POS Hardware Managerpublic2017-04-04 10:312017-05-02 11:28
Reporterranjith_qualiantech_com 
Assigned Tojorge-garcia 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q3 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035680: 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
depends on backport 0035711RR17Q2 closed jorge-garcia Error in OrderGroupingProcessor in Oracle 11 
caused by defect 0035216 closed ranjith_qualiantech_com during cashup, it is possible duplicate invoice lines when one orderline generates two or more invoice lines 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-04-04 10:31ranjith_qualiantech_comNew Issue
2017-04-04 10:31ranjith_qualiantech_comAssigned To => Retail
2017-04-04 10:31ranjith_qualiantech_comOBNetwork customer => No
2017-04-04 10:31ranjith_qualiantech_comTriggers an Emergency Pack => No
2017-04-04 10:33ranjith_qualiantech_comRelationship addedcaused by 0035216
2017-04-04 10:34ranjith_qualiantech_comDescription Updatedbug_revision_view_page.php?rev_id=14942#r14942
2017-04-06 12:32marvintmStatusnew => scheduled
2017-04-25 12:15jorge-garciaAssigned ToRetail => jorge-garcia
2017-04-26 09:18hgbotCheckin
2017-04-26 09:18hgbotNote Added: 0096184
2017-04-26 09:18hgbotStatusscheduled => resolved
2017-04-26 09:18hgbotResolutionopen => fixed
2017-04-26 09:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/782ff570895be5aecf9e85b868867e26cfaae17d [^]
2017-04-27 10:01hgbotCheckin
2017-04-27 10:01hgbotNote Added: 0096211
2017-05-02 11:28guilleaerReview Assigned To => guilleaer
2017-05-02 11:28guilleaerStatusresolved => closed
2017-05-02 11:28guilleaerFixed in Version => RR17Q3

Notes
(0096184)
hgbot   
2017-04-26 09:18   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 782ff570895be5aecf9e85b868867e26cfaae17d
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Tue Apr 25 12:14:54 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/782ff570895be5aecf9e85b868867e26cfaae17d [^]

Fixed issue 35680: Error in OrderGroupingProcessor in Oracle 11

Fixed query for order grouping processor from cashup.

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor_data.xsql
---
(0096211)
hgbot   
2017-04-27 10:01   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: cca12e0b2e4f125ca4c22c13e5549791301127b7
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Wed Apr 26 13:00:16 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/cca12e0b2e4f125ca4c22c13e5549791301127b7 [^]

Related to issue 35680: Error in OrderGroupingProcessor in Oracle 11

Now the query is working properly in Oracle 11 and the result obtained
are the same.

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