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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036657
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2017-08-16 14:282017-09-15 11:55
ReportermaiteView Statuspublic 
Assigned Tojorge-garcia 
PriorityurgentResolutionfixedFixed in VersionRR17Q4
StatusclosedFix in branchFixed in SCM revision05df0e218466
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036657: TimeOut needs to be increased for Receipts search

DescriptionIn 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 Reproduce1. 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
TagsNo tags attached.
Attached Filesdiff file icon issue36657.diff [^] (478 bytes) 2017-08-16 15:40 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0098962)
hgbot (developer)
2017-09-12 08:33

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 05df0e218466f9343b7540b6e018b0d4708a2674
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Mon Sep 11 12:11:51 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/05df0e218466f9343b7540b6e018b0d4708a2674 [^]

Fixed issue 36657: TimeOut needs to be increased for Receipts search

Increased time to 30 seconds.

---
M web/org.openbravo.retail.posterminal/js/components/modalpaidreceipts.js
---

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker