Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039329ModulesAnalyticspublic2018-09-20 12:442018-10-08 13:33
ReporterJONHM 
Assigned Todmiguelez 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Support ticket
OBNetwork customer
Regression introduced in release
Summary0039329: Deleting an order on an environment with analytics installed is slower
DescriptionDeleting an order on an environment with analytics installed is slower because of the referential integrity.
Steps To ReproduceOn environment with lots of data and analytics installed:
- Delete an order (delete from C_Order where C_Order_ID=$1)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0039328 closed AtulOpenbravo Modules Analytics should not have referential integrity with transactional data 
related to defect 0039447 closed markmm82 Openbravo ERP slow delete action in some backend windows 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-09-20 12:44JONHMNew Issue
2018-09-20 12:44JONHMAssigned To => platform
2018-09-20 12:44JONHMResolution time => 1539208800
2018-09-20 12:58JONHMRelationship addedrelated to 0039328
2018-09-21 07:43alostaleAssigned Toplatform => Triage Finance
2018-10-08 13:01dmiguelezNote Added: 0107210
2018-10-08 13:08hgbotCheckin
2018-10-08 13:08hgbotNote Added: 0107212
2018-10-08 13:08hgbotStatusnew => resolved
2018-10-08 13:08hgbotResolutionopen => fixed
2018-10-08 13:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/c61366f60aa41f2ef59139dab124a6a1b21180ee [^]
2018-10-08 13:32SandrahuguetAssigned ToTriage Finance => dmiguelez
2018-10-08 13:33SandrahuguetReview Assigned To => Sandrahuguet
2018-10-08 13:33SandrahuguetNote Added: 0107217
2018-10-08 13:33SandrahuguetStatusresolved => closed
2018-10-15 14:13alostaleRelationship addedrelated to 0039447

Notes
(0107210)
dmiguelez   
2018-10-08 13:01   
Tested in a Client's environment with this result.

Before the change, when deleting an Order header, in the explain plan:
Trigger for constraint obanaly_fact_disc_order_fk: time=109.325 calls=1
Trigger for constraint obanaly_fact_order_order_fk: time=4049.113 calls=1
Trigger for constraint obanaly_fact_soh_order_fk: time=14033.799 calls=1

After the change:
Trigger for constraint obanaly_fact_disc_order_fk: time=19.878 calls=1
Trigger for constraint obanaly_fact_order_order_fk: time=32.450 calls=1
Trigger for constraint obanaly_fact_soh_order_fk: time=39.993 calls=1
(0107212)
hgbot   
2018-10-08 13:08   
Repository: erp/pmods/org.openbravo.client.analytics
Changeset: c61366f60aa41f2ef59139dab124a6a1b21180ee
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Oct 08 12:58:49 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/c61366f60aa41f2ef59139dab124a6a1b21180ee [^]

Fixes Issue 39329. Adds missing indexes in aggregated tables for
c_order_id column

---
M src-db/database/model/tables/OBANALY_FACT_ORDER.xml
M src-db/database/model/tables/OBANALY_FACT_SALESORDHEADER.xml
---
(0107217)
Sandrahuguet   
2018-10-08 13:33   
Code review + testing OK