Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026762Openbravo ERP09. Financial managementpublic2014-06-02 14:352014-06-11 17:39
Reportershuehner 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Torafaroda
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelAutomated tests
Regression date2014-06-02
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/3e75e4d92c64 [^]
Triggers an Emergency PackNo
Summary0026762: Open Balances commit broke oracle update.db as it has duplicate index definition
Descriptionhttps://ci.openbravo.com/job/int-inc-oracle/659/console [^]

This oracle incremental build fails inside update database with the following error:
     [java] CREATE INDEX FACT_ACCT_FACT_ACCT_GROUP_ID ON FACT_ACCT (FACT_ACCT_GROUP_ID)

Problem is that core fact_acct.xml table structure definition how has 2 indices defined for the same columns which does not make sense functionally and also causes this error.
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-06-02 14:35shuehnerNew Issue
2014-06-02 14:35shuehnerAssigned To => eduardo_Argal
2014-06-02 14:35shuehnerModules => Core
2014-06-02 14:35shuehnerOBNetwork customer => No
2014-06-02 14:35shuehnerTriggers an Emergency Pack => No
2014-06-02 14:37shuehnerRegression level => Automated tests
2014-06-02 14:37shuehnerRegression date => 2014-06-02
2014-06-02 14:37shuehnerRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/3e75e4d92c64 [^]
2014-06-02 17:28hgbotCheckin
2014-06-02 17:28hgbotNote Added: 0067683
2014-06-02 17:28hgbotStatusnew => resolved
2014-06-02 17:28hgbotResolutionopen => fixed
2014-06-02 17:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b91b157d20956ee63c37c441a6720981fca6d60e [^]
2014-06-02 17:52hgbotCheckin
2014-06-02 17:52hgbotNote Added: 0067685
2014-06-10 22:23hudsonbotCheckin
2014-06-10 22:23hudsonbotNote Added: 0067867
2014-06-10 22:23hudsonbotCheckin
2014-06-10 22:23hudsonbotNote Added: 0067868
2014-06-11 17:39rafarodaReview Assigned To => rafaroda
2014-06-11 17:39rafarodaNote Added: 0067911
2014-06-11 17:39rafarodaStatusresolved => closed

Notes
(0067683)
hgbot   
2014-06-02 17:28   
Repository: erp/devel/pi
Changeset: b91b157d20956ee63c37c441a6720981fca6d60e
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Jun 02 17:27:52 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b91b157d20956ee63c37c441a6720981fca6d60e [^]

Fixes bug 26762: Open Balances commit broke...

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0067685)
hgbot   
2014-06-02 17:52   
Repository: erp/devel/pi
Changeset: 825b6cb89bd40c42aa95cd5975322f054da7d626
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Jun 02 17:52:00 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/825b6cb89bd40c42aa95cd5975322f054da7d626 [^]

Related to issue 26762

---
M src-db/database/model/tables/FACT_ACCT.xml
---
(0067867)
hudsonbot   
2014-06-10 22:23   
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/763f16c2ad2e [^]
Maturity status: Test
(0067868)
hudsonbot   
2014-06-10 22:23   
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/763f16c2ad2e [^]
Maturity status: Test
(0067911)
rafaroda   
2014-06-11 17:39   
Properly removed duplicated index that caused problems in Oracle