Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0026142Openbravo ERPA. Platformpublic2014-04-02 11:402014-05-07 18:10
marvintm 
marvintm 
normaltrivialhave not tried
closedfixed 
5
 
3.0PR14Q3 
AugustoMauch
Core
No
0026142: It doesn't make sense to check if the foreign keys on Ad_Module_Install are correct
The AD_Module_Install table is a special table which is filled when the user installs or updates modules, just before the rebuild it done. As this is an intermediate step before doing the full rebuild, it's not guaranteed that the integrity of referenced data will be correct at this point. Therefore, there shouldn't be foreign keys defined for this table, and therefore the system shouldn't check that they are correct.
- Put core in development.
- Do export.database
- Verify that the following message appears:

Foreign Key Column AD_MODULE_INSTALL.AD_Language is not part of a foreign key constraint.

This warning shouldn't be raised.
No tags attached.
Issue History
2014-04-02 11:40marvintmNew Issue
2014-04-02 11:40marvintmAssigned To => AugustoMauch
2014-04-02 11:40marvintmModules => Core
2014-04-02 11:40marvintmTriggers an Emergency Pack => No
2014-04-02 11:41marvintmAssigned ToAugustoMauch => marvintm
2014-04-02 11:42hgbotCheckin
2014-04-02 11:42hgbotNote Added: 0066058
2014-04-02 11:42hgbotStatusnew => resolved
2014-04-02 11:42hgbotResolutionopen => fixed
2014-04-02 11:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9fa79145ed3c493057e34d28965edd1a038a7d52 [^]
2014-04-02 11:44shuehnerReview Assigned To => AugustoMauch
2014-04-07 14:02AugustoMauchNote Added: 0066205
2014-04-07 14:02AugustoMauchStatusresolved => closed
2014-04-07 14:02AugustoMauchFixed in Version => PR14Q3
2014-05-07 18:10hudsonbotCheckin
2014-05-07 18:10hudsonbotNote Added: 0066876

Notes
(0066058)
hgbot   
2014-04-02 11:42   
Repository: erp/devel/pi
Changeset: 9fa79145ed3c493057e34d28965edd1a038a7d52
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Apr 02 11:42:03 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9fa79145ed3c493057e34d28965edd1a038a7d52 [^]

Fixed issue 26142. AD_Module_Install table foreign keys will no longer be checked.

---
M src/org/openbravo/service/system/DatabaseValidator.java
---
(0066205)
AugustoMauch   
2014-04-07 14:02   
Code reviewed and verified in pi@9fa79145ed3c
(0066876)
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