Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0032235 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Modules] Analytics | major | always | 2016-02-15 16:48 | 2016-04-11 15:29 | ||||||
| Reporter | ngarcia | View Status | public | ||||||||
| Assigned To | alostale | ||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Merge Request Status | |||||||||||
| Regression date | |||||||||||
| Regression introduced by commit | |||||||||||
| Regression level | |||||||||||
| Review Assigned To | |||||||||||
| Support ticket | 40340 | ||||||||||
| OBNetwork customer | OBPS | ||||||||||
| Regression introduced in release | |||||||||||
| Summary | 0032235: Update Analytics Fact Tables background process takes too long when the tables are empty | ||||||||||
| Description | Update 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 Reproduce | In 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 | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0085204) hgbot (developer) 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 (developer) 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 (developer) 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 (developer) 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 (viewer) 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-02-15 16:48 | ngarcia | New Issue | |
| 2016-02-15 16:48 | ngarcia | Assigned To | => platform |
| 2016-02-15 16:48 | ngarcia | Resolution time | => 1456786800 |
| 2016-02-15 16:48 | ngarcia | Support ticket | => 40340 |
| 2016-02-15 16:48 | ngarcia | OBNetwork customer | => Yes |
| 2016-02-15 16:48 | ngarcia | Relationship added | related to 0032192 |
| 2016-03-17 14:17 | alostale | Relationship added | related to 0032500 |
| 2016-03-17 14:38 | alostale | Assigned To | platform => alostale |
| 2016-03-17 14:38 | alostale | Status | new => acknowledged |
| 2016-03-17 14:42 | hgbot | Checkin | |
| 2016-03-17 14:42 | hgbot | Note Added: 0085204 | |
| 2016-03-17 14:42 | hgbot | Checkin | |
| 2016-03-17 14:42 | hgbot | Note Added: 0085205 | |
| 2016-03-17 14:42 | hgbot | Checkin | |
| 2016-03-17 14:42 | hgbot | Note Added: 0085206 | |
| 2016-03-17 14:43 | hgbot | Checkin | |
| 2016-03-17 14:43 | hgbot | Note Added: 0085207 | |
| 2016-03-17 14:48 | alostale | Note Added: 0085208 | |
| 2016-04-11 15:29 | alostale | Resolution time | 1456786800 => |
| 2016-04-11 15:29 | alostale | Type | defect => design defect |
| 2016-06-06 11:21 | caristu | Relationship added | related to 0033148 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |