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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0053369
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajorsometimes2023-09-04 10:212024-01-06 22:39
Reporterphilippe_muiView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0053369: 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
TagsFASH
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0054476 closedludmila_ursu Modules Loss of connection - Slow scan on Count - AWO 

-  Notes
(0155668)
agusti_gallego (developer)
2023-10-09 11:22
edited on: 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 (developer)
2023-10-13 13:39

Pending feedback from the client regarding the possibility of limiting results to improve search times.
(0158026)
philippe_mui (developer)
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 (developer)
2024-01-04 19:21

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/203 [^]
(0158877)
hgbot (developer)
2024-01-04 19:21

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/114 [^]
(0158904)
hgbot (developer)
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 (developer)
2024-01-06 22:39

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/203 [^]
(0158906)
hgbot (developer)
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 (developer)
2024-01-06 22:39

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.distributionorders/-/merge_requests/114 [^]

- Issue History
Date Modified Username Field Change
2023-09-04 10:21 philippe_mui New Issue
2023-09-04 10:21 philippe_mui Assigned To => Triage Omni WMS
2023-09-04 10:21 philippe_mui Modules => Core
2023-09-04 10:21 philippe_mui Triggers an Emergency Pack => No
2023-09-04 10:21 philippe_mui Tag Attached: FASH
2023-09-06 15:31 agusti_gallego Assigned To Triage Omni WMS => agusti_gallego
2023-10-09 11:22 agusti_gallego Note Added: 0155668
2023-10-09 11:22 agusti_gallego Note Edited: 0155668 View Revisions
2023-10-13 13:39 agusti_gallego Note Added: 0155833
2023-10-13 13:39 agusti_gallego Status new => feedback
2023-10-16 11:10 aferraz Assigned To agusti_gallego => philippe_mui
2023-12-08 14:36 philippe_mui Note Added: 0158026
2023-12-08 14:37 philippe_mui Assigned To philippe_mui => AtulOpenbravo
2024-01-04 19:16 AtulOpenbravo Status feedback => scheduled
2024-01-04 19:21 hgbot Note Added: 0158876
2024-01-04 19:21 hgbot Note Added: 0158877
2024-01-06 22:39 hgbot Resolution open => fixed
2024-01-06 22:39 hgbot Status scheduled => closed
2024-01-06 22:39 hgbot Note Added: 0158904
2024-01-06 22:39 hgbot Note Added: 0158905
2024-01-06 22:39 hgbot Note Added: 0158906
2024-01-06 22:39 hgbot Note Added: 0158907
2024-01-25 23:21 axelmercado Relationship added related to 0054476


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker