Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026139Openbravo ERPA. Platformpublic2014-04-02 10:262014-05-07 18:10
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3Fixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026139: Missing constraint in AD_TABLE_TREE table
DescriptionThe column obserds_datasource_id of the ad_table_tree is a foreign key to the key column of the obserds_datasource.

Because of this, this warning in shown when executing ant export.database:

+++++++++++++++++++++++++++++++++++++++++++++++++++
Warnings for Validation type: NOT_PART_OF_FOREIGN_KEY
+++++++++++++++++++++++++++++++++++++++++++++++++++
Foreign Key Column AD_MODULE_INSTALL.AD_Language is not part of a
foreign key constraint.
Foreign Key Column AD_TABLE_TREE.Obserds_Datasource_ID is not part of
a foreign key constraint.
Steps To Reproduceant export.database. This warning will be shown:

+++++++++++++++++++++++++++++++++++++++++++++++++++
Warnings for Validation type: NOT_PART_OF_FOREIGN_KEY
+++++++++++++++++++++++++++++++++++++++++++++++++++
Foreign Key Column AD_MODULE_INSTALL.AD_Language is not part of a
foreign key constraint.
Foreign Key Column AD_TABLE_TREE.Obserds_Datasource_ID is not part of
a foreign key constraint.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-04-02 10:26AugustoMauchNew Issue
2014-04-02 10:26AugustoMauchAssigned To => AugustoMauch
2014-04-02 10:26AugustoMauchModules => Core
2014-04-02 10:26AugustoMauchOBNetwork customer => No
2014-04-02 10:26AugustoMauchTriggers an Emergency Pack => No
2014-04-02 10:31AugustoMauchIssue Monitored: shankarb
2014-04-02 10:31AugustoMauchReview Assigned To => shankarb
2014-04-02 10:39hgbotCheckin
2014-04-02 10:39hgbotNote Added: 0066053
2014-04-02 10:39hgbotStatusnew => resolved
2014-04-02 10:39hgbotResolutionopen => fixed
2014-04-02 10:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/409cf54877df55e56b04bfb6fac07837dca3a2f9 [^]
2014-04-02 10:52AugustoMauchNote Added: 0066054
2014-04-02 13:33alostaleReview Assigned Toshankarb => alostale
2014-04-02 13:33alostaleNote Added: 0066072
2014-04-02 13:33alostaleStatusresolved => closed
2014-04-02 13:33alostaleFixed in Version => PR14Q2
2014-05-07 18:10hudsonbotCheckin
2014-05-07 18:10hudsonbotNote Added: 0066874

Notes
(0066053)
hgbot   
2014-04-02 10:39   
Repository: erp/devel/pi
Changeset: 409cf54877df55e56b04bfb6fac07837dca3a2f9
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Apr 02 10:38:53 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/409cf54877df55e56b04bfb6fac07837dca3a2f9 [^]

Fixes issue 26139: Adds missing constraint in AD_TABLE_TREE table

The column obserds_datasource_id of the ad_table_tree is a foreign key to the key column of the obserds_datasource. There should be a contraint to explicit this in the database.

---
M src-db/database/model/tables/AD_TABLE_TREE.xml
---
(0066054)
AugustoMauch   
2014-04-02 10:52   
Test plan:
- After applying the fix run ant export.database again. Now the warning shown will be like this:

+++++++++++++++++++++++++++++++++++++++++++++++++++
Warnings for Validation type: NOT_PART_OF_FOREIGN_KEY
+++++++++++++++++++++++++++++++++++++++++++++++++++
Foreign Key Column AD_MODULE_INSTALL.AD_Language is not part of a foreign key constraint.
(0066072)
alostale   
2014-04-02 13:33   
code reviewed + tested
(0066874)
hudsonbot   
2014-05-07 18:10   
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/02ca2648bcdc [^]
Maturity status: Test