Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023549Openbravo ERPA. Platformpublic2013-04-15 13:102013-04-16 19:18
Reporteregoitz 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP23 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023549: Somo Missing indexes
DescriptionThere are some indexes that should be created.

 create INDEX AD_ALERT_RULE
  ON AD_ALERT
  USING btree
  (AD_ALERTRULE_ID);

  CREATE INDEX M_PRODUCT_UOM_PRODUCT
  ON M_PRODUCT_UOM
  USING btree
  (M_PRODUCT_ID);

    CREATE INDEX AD_PROCESS_RUN_STATUS
  ON AD_PROCESS_RUN
  USING btree
  (STATUS);

CREATE INDEX m_storage_detail_PRODUCT
  ON m_storage_detail
  USING btree
  (m_product_id);
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0023571 closed AugustoMauch Other index missing on m_storage_detail 
related to defect 0023902 closed shankarb A index missing affecting the m_inout_post process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-04-15 13:10egoitzNew Issue
2013-04-15 13:10egoitzAssigned To => AugustoMauch
2013-04-15 13:10egoitzModules => Core
2013-04-15 13:10egoitzOBNetwork customer => Yes
2013-04-15 13:10egoitzTriggers an Emergency Pack => No
2013-04-15 13:11egoitzTag Attached: Performance
2013-04-15 13:16egoitzDescription Updatedbug_revision_view_page.php?rev_id=4576#r4576
2013-04-15 13:26egoitzDescription Updatedbug_revision_view_page.php?rev_id=4579#r4579
2013-04-15 13:39AugustoMauchIssue Monitored: shankarb
2013-04-15 13:39AugustoMauchReview Assigned To => shankarb
2013-04-15 13:41hgbotCheckin
2013-04-15 13:41hgbotNote Added: 0057896
2013-04-15 13:41hgbotStatusnew => resolved
2013-04-15 13:41hgbotResolutionopen => fixed
2013-04-15 13:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/466f47a126b46f828a7550f6ef2f0a08f78060d9 [^]
2013-04-15 14:01shankarbNote Added: 0057905
2013-04-15 14:01shankarbStatusresolved => closed
2013-04-15 14:01shankarbFixed in Version => 3.0MP23
2013-04-16 19:18hudsonbotCheckin
2013-04-16 19:18hudsonbotNote Added: 0057974
2013-04-17 12:13egoitzRelationship addedrelated to 0023571
2013-05-23 13:32egoitzRelationship addedrelated to 0023902

Notes
(0057896)
hgbot   
2013-04-15 13:41   
Repository: erp/devel/pi
Changeset: 466f47a126b46f828a7550f6ef2f0a08f78060d9
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Apr 15 13:39:38 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/466f47a126b46f828a7550f6ef2f0a08f78060d9 [^]

Fixes issue 23549: Added missing indexes

---
M src-db/database/model/tables/AD_ALERT.xml
M src-db/database/model/tables/AD_PROCESS_RUN.xml
M src-db/database/model/tables/M_PRODUCT_UOM.xml
M src-db/database/model/tables/M_STORAGE_DETAIL.xml
---
(0057905)
shankarb   
2013-04-15 14:01   
Code reviewed and tested in pi changeset b96b3181a12a
(0057974)
hudsonbot   
2013-04-16 19:18   
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/8df08bea850d [^]

Maturity status: Test