Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039670Openbravo ERPA. Platformpublic2018-11-22 09:122019-04-17 13:22
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q1 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039670: view generation scalability issues
DescriptionView generation for standard application dictionary windows has several performance and scalability issues, which causes opening a window that is not yet cached in the browser to take up to several seconds and also to virtually get OOM if many users try to do the same concurrently.

More details in the project [1].

---
[1] http://wiki.openbravo.com/wiki/Projects:View_Generation_Improved_Scalability [^]
Steps To ReproduceOpen a view with many tabs and fields (ie. Sales Order) -> it takes 2-4 seconds
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0038066 closed alostale Openbravo ERP incorrect view cache in browser for windows with server display logic 
related to defect 0028478 closed NaroaIriarte Openbravo ERP view generation: unneeded queries to grid config tables 
depends on defect 0031696 closed platform Openbravo ERP unneeded queries to OBUIAPP_GC_System when generating views 
depends on defect 0039671 closed alostale Openbravo ERP API changes for improved view generation scalability 
has duplicate defect 0028477 closed alostale Openbravo ERP view generation: unneeded queries to trl tables 
related to design defect 0037999 closed platform Openbravo ERP Performance issue opening a window with hundreds of fields distributed on different tabs. 
related to defect 0039681 closed alostale Modules incorrect window definition: Dynamic Task Report 
causes defect 0040633 closed alostale Openbravo ERP Generation of Discounts and Promotions windows fails under some circumstances 
causes defect 0041338 closed alostale Openbravo ERP error when opening some backoffice windows 
causes defect 0041892 closed alostale Openbravo ERP Masked String reference can leave ADCS in an inconsitent state 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-11-22 09:12alostaleNew Issue
2018-11-22 09:12alostaleAssigned To => alostale
2018-11-22 09:12alostaleModules => Core
2018-11-22 09:12alostaleTriggers an Emergency Pack => No
2018-11-22 09:12alostaleReview Assigned To => caristu
2018-11-22 09:12alostaleRelationship addedrelated to 0037999
2018-11-22 09:13alostaleRelationship addedrelated to 0038066
2018-11-22 09:13alostaleRelationship addeddepends on 0031696
2018-11-22 09:15alostaleRelationship addedrelated to 0028478
2018-11-22 09:24alostaleRelationship addeddepends on 0039671
2018-11-22 09:25alostaleRelationship addedhas duplicate 0028477
2018-11-22 09:35hgbotCheckin
2018-11-22 09:35hgbotNote Added: 0108049
2018-11-22 09:35hgbotStatusnew => resolved
2018-11-22 09:35hgbotResolutionopen => fixed
2018-11-22 09:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4d71d9e4d6d5c9be49d1a301da6dbeefeb5d9048 [^]
2018-11-22 11:18hgbotCheckin
2018-11-22 11:18hgbotNote Added: 0108053
2018-11-22 15:52alostaleRelationship addedrelated to 0039681
2018-11-27 08:50caristuNote Added: 0108119
2018-11-27 08:51caristuStatusresolved => closed
2018-11-27 08:51caristuFixed in Version => 3.0PR19Q1
2018-12-11 20:22hudsonbotCheckin
2018-12-11 20:22hudsonbotNote Added: 0108491
2018-12-11 20:22hudsonbotCheckin
2018-12-11 20:22hudsonbotNote Added: 0108492
2019-04-17 12:05caristuRelationship addedcauses 0040633
2019-04-17 13:22alostaleTag Attached: Performance
2019-07-12 14:08alostaleRelationship addedblocks 0041338
2019-07-12 14:08alostaleRelationship replacedrelated to 0041338
2019-07-16 08:40alostaleRelationship replacedcauses 0041338
2019-09-26 17:08alostaleRelationship addedcauses 0041892

Notes
(0108049)
hgbot   
2018-11-22 09:35   
Repository: erp/devel/pi
Changeset: 4d71d9e4d6d5c9be49d1a301da6dbeefeb5d9048
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Nov 22 09:28:59 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/4d71d9e4d6d5c9be49d1a301da6dbeefeb5d9048 [^]

fixed issue 39670: view generation scalability issues

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/ViewComponent.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/attachment/AttachmentWindowComponent.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/ApplicationDictionaryCachedStructures.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewFieldHandler.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewGridComponent.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewParameterHandler.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewTab.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/OBViewUtil.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/StandardWindowComponent.java
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/BaseComponent.java
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelApplicationInitializer.java
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelUtils.java
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/FKComboUIDefinition.java
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/UIDefinition.java
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/HQLDataSourceService.java
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorComponent.java
M src-test/src/org/openbravo/test/AllAntTaskTests.java
M src-test/src/org/openbravo/test/base/TestConstants.java
M src-test/src/org/openbravo/test/views/ETagGeneration.java
M src-test/src/org/openbravo/test/views/GCSequenceNumberTests.java
M src-test/src/org/openbravo/test/views/GridConfigurationTest.java
M src-test/src/org/openbravo/test/views/SortingFilteringGridConfiguration.java
M src-test/src/org/openbravo/test/views/ViewGenerationWithDifferentConfigLevelTest.java
M src/org/openbravo/erpCommon/ad_forms/About.java
M src/org/openbravo/erpCommon/utility/Utility.java
A modules/org.openbravo.client.application/src/org/openbravo/client/application/window/JmxApplicationDictionaryCachedStructures.java
A modules/org.openbravo.client.application/src/org/openbravo/client/application/window/JmxApplicationDictionaryCachedStructuresMBean.java
A src-test/src/org/openbravo/test/views/ViewGeneration.java
---
(0108053)
hgbot   
2018-11-22 11:18   
Repository: erp/devel/pi
Changeset: ae10c525813c8f75acf314081b6b0b12a6f01182
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Nov 22 11:18:15 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ae10c525813c8f75acf314081b6b0b12a6f01182 [^]

related to issue 39670: restore KernelUtils public constructor

  It is required for subclasses (MobileCoreKernelUtils)

---
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelUtils.java
---
(0108119)
caristu   
2018-11-27 08:50   
Reviewed as part of the project. See[1].

[1] https://docs.google.com/spreadsheets/d/1dIvB_RpemUiASmWWqpf-_qbewDfNracYGGkWJKf-Fpo/edit#gid=0 [^]
(0108491)
hudsonbot   
2018-12-11 20:22   
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/470e3cd384c5 [^]
Maturity status: Test
(0108492)
hudsonbot   
2018-12-11 20:22   
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/470e3cd384c5 [^]
Maturity status: Test