Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0036657 | Retail Modules | Web POS | public | 2017-08-16 14:28 | 2017-09-15 11:55 |
|
| Reporter | maite | |
| Assigned To | jorge-garcia | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR17Q4 | |
| Merge Request Status | |
| Review Assigned To | marvintm |
| OBNetwork customer | |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0036657: TimeOut needs to be increased for Receipts search |
| Description | In case current timeout of 15 seconds is reached, following error will be raised in the log and no results will be shown:
53b5b12 2017-08-16 07:00:05,201 [ajp-bio-127.0.0.1-8009-exec-2] 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='5A69C14231C34F64B007B6AF049B17AA' and ord.organization.id= :organization and ord.obposIsDeleted = false and (ord.documentNo like :filterT1 or upper(ord.businessPartner.name) like upper(:filterT1)) and ( ord.documentType.id in (:documentTypes) ) and ord.obposApplications is not null and exists (select 1 from ord.orderLineList where deliveredQuantity != 0) order by ord.orderDate desc, ord.documentNo desc) (could not execute query using scroll)
org.hibernate.exception.GenericJDBCException: could not execute query using scroll |
| Steps To Reproduce | 1. Access POS Terminal
2. Open "Receipts" option and set "VBS1/00000" value
In case query take more than 15 seconds no tickets will be returned and error will be raised in log |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  issue36657.diff (478) 2017-08-16 15:40
https://issues.openbravo.com/file_download.php?file_id=10985&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-08-16 14:28 | maite | New Issue | |
| 2017-08-16 14:28 | maite | Assigned To | => Retail |
| 2017-08-16 14:28 | maite | Resolution time | => 1504648800 |
| 2017-08-16 14:28 | maite | Triggers an Emergency Pack | => No |
| 2017-08-16 14:28 | maite | Issue Monitored: networkb | |
| 2017-08-16 15:40 | marvintm | File Added: issue36657.diff | |
| 2017-08-22 22:48 | rqueralta | Assigned To | Retail => rqueralta |
| 2017-08-22 22:58 | rqueralta | Status | new => scheduled |
| 2017-09-11 12:12 | jorge-garcia | Assigned To | rqueralta => jorge-garcia |
| 2017-09-12 08:33 | hgbot | Checkin | |
| 2017-09-12 08:33 | hgbot | Note Added: 0098962 | |
| 2017-09-12 08:33 | hgbot | Status | scheduled => resolved |
| 2017-09-12 08:33 | hgbot | Resolution | open => fixed |
| 2017-09-12 08:33 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/05df0e218466f9343b7540b6e018b0d4708a2674 [^] |
| 2017-09-15 11:55 | marvintm | Review Assigned To | => marvintm |
| 2017-09-15 11:55 | marvintm | Status | resolved => closed |
| 2017-09-15 11:55 | marvintm | Fixed in Version | => RR17Q4 |