Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0036657

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Retail Modules] Web POS

major

always

2017-08-16 14:28

2017-09-15 11:55

Reporter

maite

View Status

public

Assigned To

jorge-garcia

Priority

urgent

Resolution

fixed

Fixed in Version

RR17Q4

Status

closed

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

SCM revision

Merge Request Status

Review Assigned To

marvintm

OBNetwork customer

OBPS

Support ticket

47914

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

Tags

No tags attached.

issue36657.diff [^] (478 bytes) 2017-08-16 15:40 [Show Content] [Hide Content]

diff -r a49daf3a5a2e web/org.openbravo.retail.posterminal/js/components/modalpaidreceipts.js
--- a/web/org.openbravo.retail.posterminal/js/components/modalpaidreceipts.js	Fri Aug 11 11:59:06 2017 +0530
+++ b/web/org.openbravo.retail.posterminal/js/components/modalpaidreceipts.js	Wed Aug 16 15:40:34 2017 +0200
@@ -365,7 +365,7 @@
         me.$.renderLoading.hide();
         me.prsList.reset();
       }
-    });
+    }, true, 30000);
     return true;
   },
   prsList: null,

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	OBNetwork customer	=> Yes
2017-08-16 14:28	maite	Support ticket	=> 47914
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