Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035912Openbravo ERPI. Performancepublic2017-05-03 17:262017-05-29 17:43
ReporterSandrahuguet 
Assigned ToSandrahuguet 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version3.0PR17Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035912: Has no sense to have an index with ad_client_id at fist column
DescriptionHas no sense to have an index with ad_client_id at fist column, these indexes should be modified:

CREATE INDEX fact_acct_account
  ON public.fact_acct
  USING btree
  (ad_client_id COLLATE pg_catalog."default", ad_org_id COLLATE pg_catalog."default", c_acctschema_id COLLATE pg_catalog."default", account_id COLLATE pg_catalog."default");

CREATE INDEX ad_user_name
  ON public.ad_user
  USING btree
  (ad_client_id COLLATE pg_catalog."default", name COLLATE pg_catalog."default");

Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0037113 new AtulOpenbravo Index clean up in C_Order table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-05-03 17:26SandrahuguetNew Issue
2017-05-03 17:26SandrahuguetAssigned To => Triage Finance
2017-05-03 17:26SandrahuguetOBNetwork customer => No
2017-05-03 17:26SandrahuguetModules => Core
2017-05-03 17:26SandrahuguetTriggers an Emergency Pack => No
2017-05-04 09:48SandrahuguetOBNetwork customerNo => Yes
2017-05-04 09:48SandrahuguetResolution time => 1495663200
2017-05-04 09:48SandrahuguetSeveritymajor => minor
2017-05-04 09:48SandrahuguetTag Attached: Performance
2017-05-04 15:22hgbotCheckin
2017-05-04 15:22hgbotNote Added: 0096386
2017-05-04 15:22hgbotStatusnew => resolved
2017-05-04 15:22hgbotResolutionopen => fixed
2017-05-04 15:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/990d615bbfd3005de682104dd42e4c1f70b1908c [^]
2017-05-04 15:24SandrahuguetAssigned ToTriage Finance => Sandrahuguet
2017-05-04 16:32aferrazReview Assigned To => aferraz
2017-05-04 16:32aferrazNote Added: 0096395
2017-05-04 16:32aferrazStatusresolved => closed
2017-05-04 16:32aferrazFixed in Version => 3.0PR17Q3
2017-05-29 17:43hudsonbotCheckin
2017-05-29 17:43hudsonbotNote Added: 0096940
2017-10-19 11:55shuehnerRelationship addedrelated to 0037113

Notes
(0096386)
hgbot   
2017-05-04 15:22   
Repository: erp/devel/pi
Changeset: 990d615bbfd3005de682104dd42e4c1f70b1908c
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu May 04 10:42:22 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/990d615bbfd3005de682104dd42e4c1f70b1908c [^]

Fixed issue 35912 delete clientid in fact_acct_account and ad_user_name index

Added ad_user_id in ad_user_name index because is needed in the orderby
clause in some queries

---
M src-db/database/model/tables/AD_USER.xml
M src-db/database/model/tables/FACT_ACCT.xml
---
(0096395)
aferraz   
2017-05-04 16:32   
Code review OK
(0096940)
hudsonbot   
2017-05-29 17:43   
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/1ee70113bdc4 [^]
Maturity status: Test