Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0026139 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2014-04-02 10:26 | 2014-05-07 18:10 | |||
| Reporter | AugustoMauch | View Status | public | |||||
| Assigned To | AugustoMauch | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR14Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 409cf54877df | ||||
| Projection | none | ETA | none | Target Version | 3.0PR14Q3 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | alostale | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0026139: Missing constraint in AD_TABLE_TREE table | |||||||
| Description | The 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 Reproduce | ant 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0066053) hgbot (developer) 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 (manager) 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 (manager) 2014-04-02 13:33 |
code reviewed + tested |
|
(0066874) hudsonbot (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-04-02 10:26 | AugustoMauch | New Issue | |
| 2014-04-02 10:26 | AugustoMauch | Assigned To | => AugustoMauch |
| 2014-04-02 10:26 | AugustoMauch | Modules | => Core |
| 2014-04-02 10:26 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2014-04-02 10:31 | AugustoMauch | Issue Monitored: shankarb | |
| 2014-04-02 10:31 | AugustoMauch | Review Assigned To | => shankarb |
| 2014-04-02 10:39 | hgbot | Checkin | |
| 2014-04-02 10:39 | hgbot | Note Added: 0066053 | |
| 2014-04-02 10:39 | hgbot | Status | new => resolved |
| 2014-04-02 10:39 | hgbot | Resolution | open => fixed |
| 2014-04-02 10:39 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/409cf54877df55e56b04bfb6fac07837dca3a2f9 [^] |
| 2014-04-02 10:52 | AugustoMauch | Note Added: 0066054 | |
| 2014-04-02 13:33 | alostale | Review Assigned To | shankarb => alostale |
| 2014-04-02 13:33 | alostale | Note Added: 0066072 | |
| 2014-04-02 13:33 | alostale | Status | resolved => closed |
| 2014-04-02 13:33 | alostale | Fixed in Version | => PR14Q2 |
| 2014-05-07 18:10 | hudsonbot | Checkin | |
| 2014-05-07 18:10 | hudsonbot | Note Added: 0066874 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |