Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040449Openbravo ERP02. Master data managementpublic2019-03-25 18:042019-05-21 15:16
ReporterJONHM 
Assigned Tojarmendariz 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q3 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040449: 'Show audit trail' manual window has performance problems in environments with many business partners
Description'Show audit trail' manual window has performance problems in environments with many business partners. It takes too long in load data and sometimes it causes the browser to be locked
Steps To Reproduce* Ask environment to support

- Open 'Business partner' window
- Open 'Show audit trail' window (press the feet button in the toolbar)
- When trying to select a record from the "User" drop-down takes 12 seconds to respond and may cause performance problems on the browser.

AD_USER table has 139899 records
AD_AUDIT_TRAIL table has 5 records

Proposed Solution
Additional Information
TagsPerformance
Relationships
related to design defect 0040479 acknowledged Triage Platform Base Reimplement Audit Trail popup with 3.0 technology 
related to defect 0044265 closed cberner Grid timeout is not working on the popup for audit trail 
Attached Filespng Screenshot from 2019-03-26 11-04-31.png (55,427) 2019-03-26 11:14
https://issues.openbravo.com/file_download.php?file_id=12775&type=bug
png

patch 40449.patch (10,490) 2019-03-27 17:48
https://issues.openbravo.com/file_download.php?file_id=12798&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-03-25 18:04JONHMNew Issue
2019-03-25 18:04JONHMAssigned To => Triage Finance
2019-03-25 18:04JONHMModules => Core
2019-03-25 18:04JONHMResolution time => 1555279200
2019-03-25 18:04JONHMTriggers an Emergency Pack => No
2019-03-26 09:19SandrahuguetAssigned ToTriage Finance => platform
2019-03-26 11:13JONHMSummary'Show audit trail' process has performance problems in environments with lots of data => 'Show audit trail' manual window has performance problems in environments with many business partners
2019-03-26 11:13JONHMDescription Updatedbug_revision_view_page.php?rev_id=18530#r18530
2019-03-26 11:13JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=18532#r18532
2019-03-26 11:14JONHMFile Added: Screenshot from 2019-03-26 11-04-31.png
2019-03-26 13:51alostaleTag Attached: Performance
2019-03-27 09:34jarmendarizAssigned Toplatform => jarmendariz
2019-03-27 17:48jarmendarizStatusnew => scheduled
2019-03-27 17:48jarmendarizFile Added: 40449.patch
2019-03-28 14:22jarmendarizRelationship addedrelated to 0040479
2019-04-03 18:56hgbotCheckin
2019-04-03 18:56hgbotNote Added: 0110978
2019-04-03 18:56hgbotStatusscheduled => resolved
2019-04-03 18:56hgbotResolutionopen => fixed
2019-04-03 18:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ff01c2b4f10e90ae8803119c4e847cddd7513be4 [^]
2019-04-03 19:13jarmendarizNote Added: 0110979
2019-04-04 12:35jarmendarizReview Assigned To => alostale
2019-04-05 09:10alostaleNote Added: 0110988
2019-04-05 09:10alostaleStatusresolved => closed
2019-04-05 09:10alostaleFixed in Version => 3.0PR19Q3
2019-05-21 15:16hudsonbotCheckin
2019-05-21 15:16hudsonbotNote Added: 0111960
2020-06-04 10:07alostaleRelationship addedrelated to 0044265

Notes
(0110978)
hgbot   
2019-04-03 18:56   
Repository: erp/devel/pi
Changeset: ff01c2b4f10e90ae8803119c4e847cddd7513be4
Author: Javier Armendáriz <javier.armendariz <at> openbravo.com>
Date: Wed Mar 27 13:49:32 2019 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ff01c2b4f10e90ae8803119c4e847cddd7513be4 [^]

Fixed issue 40449: Performance problems in Show Audit Trail popup.

Added a new preference 'ShowAuditTrailUserFilter' that, when its set to 'N',
will hide the User selector in audit trail filter fields. In case the number
of users available are really high, this will prevent to load all of them and
thus improving popup performance.

---
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/erpCommon/businessUtility/AuditTrailPopup.java
M src/org/openbravo/erpCommon/businessUtility/AuditTrailPopupDeleted.html
M src/org/openbravo/erpCommon/businessUtility/AuditTrailPopupHistory.html
---
(0110979)
jarmendariz   
2019-04-03 19:13   
Documented the new preference in the wiki:
http://wiki.openbravo.com/wiki/Audit_Trail#Disable_filtering_by_User [^]
(0110988)
alostale   
2019-04-05 09:10   
code reviewed + tested
(0111960)
hudsonbot   
2019-05-21 15:16   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9b8f37d9d85e [^]
Maturity status: Test