Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0054476ModulesAdvanced Warehouse Operationspublic2024-01-25 23:202024-02-14 00:36
Reporteraxelmercado 
Assigned Toludmila_ursu 
PrioritynormalSeverityminorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0054476: Loss of connection - Slow scan on Count - AWO
DescriptionIn some clients there are constant connection losses when scanning when doing an inventory, in addition to the slowness of reading.

Checking we have detected that in the ProductSelector.java class when reading only by upc (parameter "onlyUPC") a like is done. This causes the query to fire in time.

We have changed it to "=" and now it seems to work fine and the query is fast.
Steps To ReproduceAccess to AWO
Create a new inventory
Search for a product

Current result : Disconnected from AWO and no result displayed

Expected result : The search result appears without going offline
Proposed SolutionAttached is a patch that modifies the like by an "=" with the UPC/EAN value since these codes are usually unique, which speeds up the search.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0053369 closed AtulOpenbravo Openbravo ERP RM-8085 [DO OTF] Disconnected after search a product in DO OTF 
Attached Filesdiff bugFixEscaneoLento.diff (907) 2024-01-25 23:20
https://issues.openbravo.com/file_download.php?file_id=19390&type=bug
Issue History
Date ModifiedUsernameFieldChange
2024-01-25 23:20axelmercadoNew Issue
2024-01-25 23:20axelmercadoAssigned To => Triage Omni WMS
2024-01-25 23:20axelmercadoFile Added: bugFixEscaneoLento.diff
2024-01-25 23:21axelmercadoRelationship addedrelated to 0053369
2024-01-26 06:40PracticsIssue Monitored: Practics
2024-02-07 14:12hgbotNote Added: 0160343
2024-02-12 12:02ludmila_ursuNote Added: 0160613
2024-02-12 12:02ludmila_ursuAssigned ToTriage Omni WMS => ludmila_ursu
2024-02-14 00:36hgbotResolutionopen => fixed
2024-02-14 00:36hgbotStatusnew => closed
2024-02-14 00:36hgbotNote Added: 0160708
2024-02-14 00:36hgbotNote Added: 0160709

Notes
(0160343)
hgbot   
2024-02-07 14:12   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/217 [^]
(0160613)
ludmila_ursu   
2024-02-12 12:02   
Related Jira: https://openbravo.atlassian.net/browse/RM-11582 [^]

Proof of testing: https://docs.google.com/spreadsheets/d/1t-tj99NgzoPguBnNbp34gy-G5kyDkc4xxSlCO5UWWOk/edit#gid=0 [^]
(0160708)
hgbot   
2024-02-14 00:36   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 11b13e17d125fb3d5209aa369258bfbe357534eb
Author: Ludmila Ursu <ludmila.ursu@openbravo.com>
Date: 07-02-2024 14:05:37
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/11b13e17d125fb3d5209aa369258bfbe357534eb [^]

Fixes ISSUE-54476: use "=" when scanning ("onlyUPC"), instead of like

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/ProductSelector.java
---
(0160709)
hgbot   
2024-02-14 00:36   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/217 [^]