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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035680
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POS Hardware Managermajoralways2017-04-04 10:312017-05-02 11:28
Reporterranjith_qualiantech_comView Statuspublic 
Assigned Tojorge-garcia 
PrioritynormalResolutionfixedFixed in VersionRR17Q3
StatusclosedFix in branchFixed in SCM revision782ff570895b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase version11Ant version
Product VersionSCM revision 
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
Summary

0035680: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0035711RR17Q2 closedjorge-garcia Error in OrderGroupingProcessor in Oracle 11 
caused by defect 0035216 closedranjith_qualiantech_com during cashup, it is possible duplicate invoice lines when one orderline generates two or more invoice lines 

-  Notes
(0096184)
hgbot (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2017-04-04 10:31 ranjith_qualiantech_com New Issue
2017-04-04 10:31 ranjith_qualiantech_com Assigned To => Retail
2017-04-04 10:31 ranjith_qualiantech_com OBNetwork customer => No
2017-04-04 10:31 ranjith_qualiantech_com Triggers an Emergency Pack => No
2017-04-04 10:33 ranjith_qualiantech_com Relationship added caused by 0035216
2017-04-04 10:34 ranjith_qualiantech_com Description Updated View Revisions
2017-04-06 12:32 marvintm Status new => scheduled
2017-04-25 12:15 jorge-garcia Assigned To Retail => jorge-garcia
2017-04-26 09:18 hgbot Checkin
2017-04-26 09:18 hgbot Note Added: 0096184
2017-04-26 09:18 hgbot Status scheduled => resolved
2017-04-26 09:18 hgbot Resolution open => fixed
2017-04-26 09:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/782ff570895be5aecf9e85b868867e26cfaae17d [^]
2017-04-27 10:01 hgbot Checkin
2017-04-27 10:01 hgbot Note Added: 0096211
2017-05-02 11:28 guilleaer Review Assigned To => guilleaer
2017-05-02 11:28 guilleaer Status resolved => closed
2017-05-02 11:28 guilleaer Fixed in Version => RR17Q3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker