Openbravo Issue Tracking System - Modules
View Issue Details
0040364ModulesAdvanced Warehouse Operationspublic2019-03-12 17:012019-07-30 17:28
JONHM 
guilleaer 
highmajoralways
closedfixed 
5
 
 
marvintm
0040364: AWO: Server side problem when loading attribute sets
The queries executed to retrieve attribute sets together with attributes which compose this set is behaving slow. It requires around 40 seconds in the server side and then some time to transfer the data and insert it into the database.
It's also required high memory usage in tomcat to load the Attribute model when logging into AWO.
* Ask environment to Support and set the following values to tomcat:
-server -Djava.awt.headless=true -Xms384M -Xmx5000M -XX:MaxPermSize=256M
or increase the timeout for that model

- Open AWO and login with Openbravo user
No tags attached.
blocks defect 0040365 closed guilleaer AWO: Performance problems on mobile devices 
png image (3).png (523,112) 2019-03-12 17:01
https://issues.openbravo.com/file_download.php?file_id=12739&type=bug
diff diff40364_dlc.diff (13,921) 2019-07-30 16:50
https://issues.openbravo.com/file_download.php?file_id=13188&type=bug
Issue History
2019-03-12 17:01JONHMNew Issue
2019-03-12 17:01JONHMAssigned To => Triage Finance
2019-03-12 17:01JONHMFile Added: image (3).png
2019-03-12 17:01JONHMResolution time => 1522620000
2019-03-12 17:07JONHMNote Added: 0110388
2019-03-13 08:33SandrahuguetAssigned ToTriage Finance => guilleaer
2019-03-25 11:32guilleaerResolution time1522620000 => 1554156000
2019-03-27 18:16guilleaerFile Added: diff40634_dlc.diff
2019-04-15 15:49guilleaerRelationship addedblocks 0040365
2019-04-15 15:50guilleaerNote Added: 0111142
2019-04-29 10:06marvintmResolution time1554156000 => 1557439200
2019-05-08 13:28marvintmResolution time1557439200 => 1558735200
2019-05-27 10:58marvintmResolution time1558735200 => 1559599200
2019-06-10 10:25marvintmResolution time1559599200 => 1560290400
2019-07-29 12:06marvintmResolution time1560290400 =>
2019-07-29 12:06marvintmTypedefect => design defect
2019-07-29 17:26guilleaerTypedesign defect => defect
2019-07-29 17:26guilleaerStatusnew => scheduled
2019-07-29 17:27guilleaerNote Added: 0113696
2019-07-29 17:27guilleaerStatusscheduled => resolved
2019-07-29 17:27guilleaerResolutionopen => fixed
2019-07-29 17:30guilleaerNote Edited: 0113696bug_revision_view_page.php?bugnote_id=0113696#r19212
2019-07-30 11:00hgbotCheckin
2019-07-30 11:00hgbotNote Added: 0113702
2019-07-30 16:49guilleaerFile Deleted: diff40634_dlc.diff
2019-07-30 16:50guilleaerFile Added: diff40364_dlc.diff
2019-07-30 17:28marvintmReview Assigned To => marvintm
2019-07-30 17:28marvintmStatusresolved => closed
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0110388)
JONHM   
2019-03-12 17:07   
M_AttributeValue = 90882 records
M_Attribute = 163 records
(0111142)
guilleaer   
2019-04-15 15:50   
Patch provided. It is being tested by customer
(0113696)
guilleaer   
2019-07-29 17:27   
(edited on: 2019-07-29 17:30)
This fix is included in 1.4.500

https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/d7a0f4a23e1b [^]

Fixed issue 40364: New preference added to avoid to load atts with many possible values

A new preference OBAWO_FE_LimitToIgnoreAttValues has been created. When an attribute has more accepted values than the number specified in that preference then values of this attributes are not loaded in AWO FE

(0113702)
hgbot   
2019-07-30 11:00   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 8f0a0c518e0181e4b6c47399bd62af93eefb5f20
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Jul 30 11:00:10 2019 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/8f0a0c518e0181e4b6c47399bd62af93eefb5f20 [^]

Related to issue 40364: Cleanup + Use scroll instead of list

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/master/Attribute.java
---