Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027930Openbravo ERPA. Platformpublic2014-10-21 13:052014-12-30 23:23
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q1 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelAutomated tests
Regression date2014-10-21
Regression introduced in releasepi
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/203b797e4189534f4b1dfca962588e3d6013ab62 [^]
Triggers an Emergency PackNo
Summary0027930: Changeset has broken the int-inc-pgsql and int-inc-oracle tests
DescriptionThis changeset [1], in particular this part [2], has broken the integration. This is happening due to this known design defect [3].

The following error is thrown when updating the application dictionary data: ERROR: duplicate key value violates unique constraint "ad_table_treetype_un"

[1] https://code.openbravo.com/erp/devel/pi/rev/203b797e4189534f4b1dfca962588e3d6013ab62 [^]
[2] https://code.openbravo.com/erp/devel/pi/diff/203b797e4189/src-db/database/sourcedata/AD_TABLE.xml [^]
[3] https://issues.openbravo.com/view.php?id=12577 [^]
Steps To ReproduceSee [1] and [2].

[1] http://ci.openbravo.com/job/int-inc-pgsql/1116/ [^]
[2] http://ci.openbravo.com/job/int-inc-oracle/1113/ [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 00279183.0PR15Q1 closed AugustoMauch After PR14Q2.X and new tree infrastructure, window User Defined Accounting Report Setup window has lost the tree view 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-10-21 13:05AugustoMauchNew Issue
2014-10-21 13:05AugustoMauchAssigned To => AugustoMauch
2014-10-21 13:05AugustoMauchOBNetwork customer => No
2014-10-21 13:05AugustoMauchModules => Core
2014-10-21 13:05AugustoMauchRegression level => Automated tests
2014-10-21 13:05AugustoMauchRegression date => 2014-10-21
2014-10-21 13:05AugustoMauchRegression introduced in release => pi
2014-10-21 13:05AugustoMauchRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/203b797e4189534f4b1dfca962588e3d6013ab62 [^]
2014-10-21 13:05AugustoMauchTriggers an Emergency Pack => No
2014-10-21 13:06AugustoMauchRelationship addedcaused by 0027918
2014-10-21 13:10hgbotCheckin
2014-10-21 13:10hgbotNote Added: 0071084
2014-10-21 13:10hgbotStatusnew => resolved
2014-10-21 13:10hgbotResolutionopen => fixed
2014-10-21 13:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8a23d66e2f6b9734c14076e86094cc527ac1044c [^]
2014-10-21 14:02AugustoMauchNote Added: 0071090
2014-10-21 14:02AugustoMauchStatusresolved => closed
2014-10-21 14:02AugustoMauchFixed in Version => 3.0PR15Q1
2014-12-30 23:23hudsonbotCheckin
2014-12-30 23:23hudsonbotNote Added: 0072959

Notes
(0071084)
hgbot   
2014-10-21 13:10   
Repository: erp/devel/pi
Changeset: 8a23d66e2f6b9734c14076e86094cc527ac1044c
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Tue Oct 21 13:09:51 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8a23d66e2f6b9734c14076e86094cc527ac1044c [^]

Fixes issue 27918, fixes issue 27930. Prevents breaking the int-inc tests

The problem was that due to this design defect [1], the oracle and postgres int-inc tests were failing. This is because a value 'AR' was being set to the treetype of a table and then being set to null in other table whose treetype was also 'AR'. Treetype has a unique constraint that was enabled when the application data was updated, so the constraint failed.

To prevent this error, the treetype of the second table is going to be set to null in a modulescript, that is executed before updating the application data.

[1] https://issues.openbravo.com/view.php?id=12577 [^]

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADTrees.class
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADTreesData.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateADTrees.java
M src-util/modulescript/src/org/openbravo/modulescript/UpdateADTrees_Data.xsql
---
(0071090)
AugustoMauch   
2014-10-21 14:02   
The tests are no longer broken
(0072959)
hudsonbot   
2014-12-30 23: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/6525fe229e06 [^]
Maturity status: Test