Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0030839 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2015-09-16 16:49 | 2015-09-29 18:32 | |||
| Reporter | aaroncalero | View Status | public | |||||
| Assigned To | mario_castello | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | RR15Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 605bad7e135c | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0080593) hgbot (developer) 2015-09-23 21:11 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 605bad7e135c400846a574f30e3a903b5290af35 Author: Mario Castello <mario.castello <at> peoplewalking.com> Date: Wed Sep 23 13:10:34 2015 -0600 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/605bad7e135c400846a574f30e3a903b5290af35 [^] Fixed issue 30839: Format string parameter to date in hql --- M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java --- |
|
(0080594) hgbot (developer) 2015-09-23 21:24 |
Repository: tools/automation/pi-mobile Changeset: 3a87b43d95adab8766e0ab45e903f98a15284a59 Author: Mario Castello <mario.castello <at> peoplewalking.com> Date: Wed Sep 23 13:24:12 2015 -0600 URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/3a87b43d95adab8766e0ab45e903f98a15284a59 [^] Related to issue 30839: Automation test to verify the date in receipt search --- M src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/sales/I30839_SalesVerifyDateInOracle.java --- |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |