Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0030839 | Retail Modules | Web POS | public | 2015-09-16 16:49 | 2015-09-29 18:32 |
| Reporter | aaroncalero | ||||
| Assigned To | mario_castello | ||||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | Fixed in Version | RR15Q4 | |||
| Merge Request Status | |||||
| Review Assigned To | marvintm | ||||
| OBNetwork customer | OBPS | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0030839: It is not possible to filter layaways, paid receipts, quotations or returns by date in oracle | ||||
| Description | When filtering by date (either start date or end date) on one of the following popups: *Layaways *Verified Returns *Receipts *Quotations in an Oracle instance, javascript errors are shown and the date filter is not applied. Also the following server error is raised: cdb72c84 2015-09-16 14:19:17,837 [TP-Processor2] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01861: literal does not match format string cdb72c84 2015-09-16 14:19:17,839 [TP-Processor2] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.retail.posterminal.PaidReceiptsHeader: Error when generating query: QueryImpl(select ord.id as id, ord.documentNo as documentNo, ord.orderDate as orderDate, ord.businessPartner.name as businessPartner, ord.grandTotalAmount as totalamount, ord.documentType.id as documentTypeId, 'false' as isLayaway from Order as ord where ord.client='B8D74EB90D8A422F900F442C2D721C2E' and ord.organization='DFEB3AE28E684CA7B6BCCB2D7FB7623F' and ( ord.documentType.id='19BADE1498E60FF2E0530100007F77FB' or ord.documentType.id='19BADE1498DD0FF2E0530100007F77FB' ) and ord.orderDate <='2016-02-15' and ord.obposApplications is not null and (exists( select 1 from ord.orderLineList where deliveredQuantity != 0) and exists( select 1 from ord.orderLineList where orderedQuantity > 0)) order by ord.orderDate desc, ord.documentNo desc) (could not execute query using scroll) org.hibernate.exception.DataException: could not execute query using scroll | ||||
| Steps To Reproduce | Login in Web POS in an Oracle-based instance (https://livebuilds.openbravo.com/retail_pi_oracle/web/org.openbravo.retail.posterminal/?terminal=VBS-1 [^]) Using the menu open the Layaways popup Add an end date filter (e.g. 10-01-2020) Click on the Search button. Verify that no results are loaded, error messages appear on the screen and js errors are shown on the console. Check the server-side log and verify the mentioned error. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-09-16 16:49 | aaroncalero | New Issue | |||
| 2015-09-16 16:49 | aaroncalero | Assigned To | => Retail | ||
| 2015-09-16 16:49 | aaroncalero | OBNetwork customer | => Yes | ||
| 2015-09-16 16:49 | aaroncalero | Resolution time | => 1442959200 | ||
| 2015-09-16 16:49 | aaroncalero | Triggers an Emergency Pack | => No | ||
| 2015-09-17 17:10 | mario_castello | Assigned To | Retail => mario_castello | ||
| 2015-09-17 17:11 | mario_castello | Status | new => scheduled | ||
| 2015-09-23 21:11 | hgbot | Checkin | |||
| 2015-09-23 21:11 | hgbot | Note Added: 0080593 | |||
| 2015-09-23 21:11 | hgbot | Status | scheduled => resolved | ||
| 2015-09-23 21:11 | hgbot | Resolution | open => fixed | ||
| 2015-09-23 21:11 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/605bad7e135c400846a574f30e3a903b5290af35 [^] | ||
| 2015-09-23 21:24 | hgbot | Checkin | |||
| 2015-09-23 21:24 | hgbot | Note Added: 0080594 | |||
| 2015-09-25 11:08 | Orekaria | Review Assigned To | => marvintm | ||
| 2015-09-29 18:32 | marvintm | Status | resolved => closed | ||
| 2015-09-29 18:32 | marvintm | Fixed in Version | => RR15Q4 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||