Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053369Openbravo ERP04. Warehouse managementpublic2023-09-04 10:212024-01-06 22:39
Reporterphilippe_mui 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053369: RM-8085 [DO OTF] Disconnected after search a product in DO OTF
DescriptionWhen searching a product in DO OTF usually on 1st connection to AWO, this leads to disconnection

However once connected again, I can do the search and it works

See video :
https://drive.google.com/file/d/16PPkZi93n538PdppX8CU4ANH3W_fT1KY/view?usp=sharing [^]

https://openbravo.atlassian.net/browse/RM-8085 [^]
Steps To ReproduceThis bug occurs when you first connect to AWO

Access to AWO
Create a DO
Search for a product

Current result : Disconnected from AWO and no result displayed

Expected result : The search result appears without going offline

FYI : it's not a problem of network quality
Proposed Solution
Additional Information
TagsFASH
Relationships
related to defect 0054476 closed ludmila_ursu Modules Loss of connection - Slow scan on Count - AWO 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-09-04 10:21philippe_muiNew Issue
2023-09-04 10:21philippe_muiAssigned To => Triage Omni WMS
2023-09-04 10:21philippe_muiModules => Core
2023-09-04 10:21philippe_muiTriggers an Emergency Pack => No
2023-09-04 10:21philippe_muiTag Attached: FASH
2023-09-06 15:31agusti_gallegoAssigned ToTriage Omni WMS => agusti_gallego
2023-10-09 11:22agusti_gallegoNote Added: 0155668
2023-10-09 11:22agusti_gallegoNote Edited: 0155668bug_revision_view_page.php?bugnote_id=0155668#r26948
2023-10-13 13:39agusti_gallegoNote Added: 0155833
2023-10-13 13:39agusti_gallegoStatusnew => feedback
2023-10-16 11:10aferrazAssigned Toagusti_gallego => philippe_mui
2023-12-08 14:36philippe_muiNote Added: 0158026
2023-12-08 14:37philippe_muiAssigned Tophilippe_mui => AtulOpenbravo
2024-01-04 19:16AtulOpenbravoStatusfeedback => scheduled
2024-01-04 19:21hgbotNote Added: 0158876
2024-01-04 19:21hgbotNote Added: 0158877
2024-01-06 22:39hgbotResolutionopen => fixed
2024-01-06 22:39hgbotStatusscheduled => closed
2024-01-06 22:39hgbotNote Added: 0158904
2024-01-06 22:39hgbotNote Added: 0158905
2024-01-06 22:39hgbotNote Added: 0158906
2024-01-06 22:39hgbotNote Added: 0158907
2024-01-25 23:21axelmercadoRelationship addedrelated to 0054476

Notes
(0155668)
agusti_gallego   
2023-10-09 11:22   
Summary:

The disconnection happens due to a timeout in the AWO frontend. The issue is not always reproducible.
Key points:
- The first product search lasts longer than subsequent searches. If it lasts last longer than 30 seconds, the disconnection occurs.
- Database logs of the ww-dev environemnt show that the query gets aborted due to user request. The root cause for this is still under investigation. Probably due to timeouts, but it's not clear which ones.
- It's a costly query, but it takes advantages of indexes and filters. In the ww-dev environment, it takes 5 seconds to complete.
- Not reproducible in local environments.
(0155833)
agusti_gallego   
2023-10-13 13:39   
Pending feedback from the client regarding the possibility of limiting results to improve search times.
(0158026)
philippe_mui   
2023-12-08 14:36   
Checked with Atul.
The search results appear randomly. Most of the time, user is moved offline. Atul is checking how we can improve this by limiting the results
(0158876)
hgbot   
2024-01-04 19:21   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/203 [^]
(0158877)
hgbot   
2024-01-04 19:21   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/114 [^]
(0158904)
hgbot   
2024-01-06 22:39   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 35f2a590c9e89e83abe844b91bda936b7be5ea69
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 06-01-2024 21:39:01
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/35f2a590c9e89e83abe844b91bda936b7be5ea69 [^]

Fixes BUG-0053369: RM-8085 [DO OTF] Performanc Improvement in Product Selector to solve: Disconnected after search a product in DO OTF

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/ProductSelector.java
M web/org.openbravo.warehouse.advancedwarehouseoperations/source/inventorycount/components/obawo-productselector.js
M web/org.openbravo.warehouse.advancedwarehouseoperations/source/models/synchronizabledocument.js
---
(0158905)
hgbot   
2024-01-06 22:39   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/203 [^]
(0158906)
hgbot   
2024-01-06 22:39   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders [^]
Changeset: 2d9821948456f1272226d4c996d9d11616bb79c7
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 06-01-2024 21:39:22
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/commit/2d9821948456f1272226d4c996d9d11616bb79c7 [^]

Related to BUG-0053369: RM-8085 [DO OTF] Performanc Improvement in Product Selector to solve: Disconnected after search a product in DO OTF

---
M web/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/source/components/obawo-productselector.js
---
(0158907)
hgbot   
2024-01-06 22:39   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/114 [^]