Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032235ModulesAnalyticspublic2016-02-15 16:482016-04-11 15:29
Reporterngarcia 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusacknowledgedResolutionopen 
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
Summary0032235: Update Analytics Fact Tables background process takes too long when the tables are empty
DescriptionUpdate Analytics Fact Tables background process takes too long when the tables are empty: the first launch or a launch after launching the Clear Fact Tables process
Steps To ReproduceIn a copy of the customer environment the process has lasted three days. The records created were:

obanaly_fact_discounts - 338464
obanaly_fact_order - 2795442
obanaly_fact_salesordheader - 1136997
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032500 closed platform Openbravo ERP incorrect duration in process monitor for times bigger than 1 day 
related to design defect 0032192 acknowledged Triage Platform Base Modules First launch of Update Time Dimension Refs + Tree Closure Table background process takes too long 
related to feature request 0033148 closed platform Modules Configurable Update Analytics Fact Tables Process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-02-15 16:48ngarciaNew Issue
2016-02-15 16:48ngarciaAssigned To => platform
2016-02-15 16:48ngarciaResolution time => 1456786800
2016-02-15 16:48ngarciaRelationship addedrelated to 0032192
2016-03-17 14:17alostaleRelationship addedrelated to 0032500
2016-03-17 14:38alostaleAssigned Toplatform => alostale
2016-03-17 14:38alostaleStatusnew => acknowledged
2016-03-17 14:42hgbotCheckin
2016-03-17 14:42hgbotNote Added: 0085204
2016-03-17 14:42hgbotCheckin
2016-03-17 14:42hgbotNote Added: 0085205
2016-03-17 14:42hgbotCheckin
2016-03-17 14:42hgbotNote Added: 0085206
2016-03-17 14:43hgbotCheckin
2016-03-17 14:43hgbotNote Added: 0085207
2016-03-17 14:48alostaleNote Added: 0085208
2016-04-11 15:29alostaleResolution time1456786800 =>
2016-04-11 15:29alostaleTypedefect => design defect
2016-06-06 11:21caristuRelationship addedrelated to 0033148

Notes
(0085204)
hgbot   
2016-03-17 14:42   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 1a8b9d040d962649cf227e69aee97d0df7a9bac3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 14 12:50:49 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/1a8b9d040d962649cf227e69aee97d0df7a9bac3 [^]

related to bug 32235: added extra logging info

---
M src/org/openbravo/client/analytics/OBOlapClosureTreeHandler.java
M src/org/openbravo/client/analytics/TimeDimensionProvider.java
---
(0085205)
hgbot   
2016-03-17 14:42   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: fd3590548ef5ef565be93bcf1fcb871dd6f218db
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 14 12:52:09 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/fd3590548ef5ef565be93bcf1fcb871dd6f218db [^]

related to bug 32235: do a single query to calculate taxes

---
M src/org/openbravo/client/analytics/OBAnalyticsFactSalesOrderHeaderUpdater.java
---
(0085206)
hgbot   
2016-03-17 14:42   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 4d9d78b83b3d5b2d0c2c6c9a17e71cab1ab28c3c
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 14 12:53:21 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/4d9d78b83b3d5b2d0c2c6c9a17e71cab1ab28c3c [^]

related to bug 32235: improved bp birthdate calcualtion

  using queries instead of loading children lists

---
M src/org/openbravo/client/analytics/OBAnalyticsFactOrderUpdater.java
M src/org/openbravo/client/analytics/OBAnalyticsFactSalesOrderHeaderUpdater.java
M src/org/openbravo/client/analytics/OBAnalyticsUtils.java
---
(0085207)
hgbot   
2016-03-17 14:43   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: 6905e0d070be9f69213016e9f914256ad6492112
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 17 14:29:35 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/6905e0d070be9f69213016e9f914256ad6492112 [^]

related to bug 32235: eager initialization in getData queries

  Elements that belong to mapped properties are now eagerly initialized, this
  improves performance (in around 40% of time savings) by preventing db roundtrips
  DAL objects are initialized from a single query now.

---
M src/org/openbravo/client/analytics/OBAnalyticsFactOrderUpdater.java
M src/org/openbravo/client/analytics/OBAnalyticsFactSalesOrderHeaderUpdater.java
---
(0085208)
alostale   
2016-03-17 14:48   
Published version 1.2.600 improves perfomance for this process making it around 40% faster. With provided dataset, it was reduced from 3 days to 41 hours.