Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052967Retail ModulesWeb POSpublic2023-07-14 10:462023-07-20 06:08
Reportermalsasua 
Assigned Toranjith_qualiantech_com 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR23Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerOBPS
Support ticket69262
Regression level
Regression date2020-02-20
Regression introduced in releaseRR20Q3
Regression introduced by commithttps://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/e34fc68b24c19a6f211eec03e6b98397d20d50e0#2c4b5b0b69481acccdd2d8c9d08613a0c835e8e3_74_121 [^]
Triggers an Emergency PackNo
Summary0052967: masterdata timeout is not used to cancel the query
DescriptionThe timeout configured in MobileServices is not being used to cancel the query when the timeout is reached
Steps To Reproduceenvironment with a big volume
BO:
. Mobile Service window:
 - org.openbravo.retail.posterminal.master.Product -> timeout=1

POS:
. do login
. open dev tools -> network
. execute incremental refresh
master.product request is executed and it is taking more than 1 sec
no "canceling statement due to user" log trace is displayed in the postgres log
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0052977RR23Q3 closed ranjith_qualiantech_com masterdata timeout is not used to cancel the query 
depends on backport 0052978RR23Q2.3 closed ranjith_qualiantech_com masterdata timeout is not used to cancel the query 
depends on backport 0052979RR23Q1.4 closed ranjith_qualiantech_com masterdata timeout is not used to cancel the query 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-07-14 10:46malsasuaNew Issue
2023-07-14 10:46malsasuaAssigned To => Retail
2023-07-14 10:46malsasuaOBNetwork customer => OBPS
2023-07-14 10:46malsasuaSupport ticket => 69262
2023-07-14 10:46malsasuaTriggers an Emergency Pack => No
2023-07-14 12:57ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2023-07-17 08:11ranjith_qualiantech_comRegression date => 2020-01-30
2023-07-17 08:11ranjith_qualiantech_comRegression introduced in release => RR20Q2
2023-07-17 08:11ranjith_qualiantech_comRegression introduced by commit => https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/e34fc68b24c19a6f211eec03e6b98397d20d50e0#2c4b5b0b69481acccdd2d8c9d08613a0c835e8e3_74_121 [^]
2023-07-17 08:12ranjith_qualiantech_comStatusnew => scheduled
2023-07-17 15:13hgbotMerge Request Status => open
2023-07-17 15:13hgbotNote Added: 0152563
2023-07-17 15:13hgbotNote Added: 0152564
2023-07-17 15:13hgbotNote Added: 0152565
2023-07-19 07:28guillermogilRegression introduced in releaseRR20Q2 => RR20Q3
2023-07-19 07:29guillermogilRegression date2020-01-30 => 2020-02-20
2023-07-19 12:02hgbotNote Added: 0152655
2023-07-19 12:02hgbotNote Added: 0152656
2023-07-19 12:17guillermogilSeveritymajor => critical
2023-07-19 12:17guillermogilPriorityhigh => immediate
2023-07-20 06:08hgbotMerge Request Statusopen => approved
2023-07-20 06:08hgbotResolutionopen => fixed
2023-07-20 06:08hgbotStatusscheduled => closed
2023-07-20 06:08hgbotFixed in Version => RR23Q4
2023-07-20 06:08hgbotNote Added: 0152676
2023-07-20 06:08hgbotNote Added: 0152677

Notes
(0152563)
hgbot   
2023-07-17 15:13   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/575 [^]
(0152564)
hgbot   
2023-07-17 15:13   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1960 [^]
(0152565)
hgbot   
2023-07-17 15:13   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.restaurant/-/merge_requests/239 [^]
(0152655)
hgbot   
2023-07-19 12:02   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1960 [^]
(0152656)
hgbot   
2023-07-19 12:02   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.restaurant/-/merge_requests/239 [^]
(0152676)
hgbot   
2023-07-20 06:08   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core [^]
Changeset: a2fbbe422567dfe36afe2d2d3c4da29317afbbe1
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 20-07-2023 04:08:26
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/a2fbbe422567dfe36afe2d2d3c4da29317afbbe1 [^]

Fixed ISSUE-52967: Added timeout for MasterDataProcessHQLQuery

---
M src/org/openbravo/mobile/core/master/MasterDataLoader.java
M src/org/openbravo/mobile/core/master/MasterDataProcessHQLQuery.java
M src/org/openbravo/mobile/core/process/SecuredJSONProcess.java
---
(0152677)
hgbot   
2023-07-20 06:08   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/575 [^]