Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011600Openbravo ERP00. Application dictionarypublic2009-12-02 11:272010-01-20 23:26
Reporternetworkb 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP11Fixed in Version2.50MP11 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011600: 'Warnings for Validation type' appears on some cases
DescriptionIn your DB when you create a table and add a column from core's table
(IE, m_product_id) and you don't create the foreign key constraint when you export the module created appears this warning:

+++++++++++++++++++++++++++++++++++++++++++++++++++
Warnings for Validation type: NOT_PART_OF_FOREIGN_KEY
+++++++++++++++++++++++++++++++++++++++++++++++++++
Foreign Key Column MI_TABLA.M_Product_ID is not part of a foreign key constraint.

But if you add a column of the table created on a core's table and you don't create the foreign key constraint, when you export the warning doesn't appear.
Steps To Reproduce-As System Administrator create a module.
-On DB create a table and add a core's column.
   -IE: alter table mi_tabla add m_product_id character varying(32).
-As System Administrator create the table and the columns.
-ant export.database
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-02 11:27networkbNew Issue
2009-12-02 11:27networkbAssigned To => rafaroda
2009-12-07 19:57psarobeAssigned Torafaroda => marvintm
2009-12-07 19:57psarobePriorityimmediate => normal
2009-12-07 19:57psarobeStatusnew => scheduled
2010-01-18 16:42hgbotCheckin
2010-01-18 16:42hgbotNote Added: 0023507
2010-01-18 16:42hgbotStatusscheduled => resolved
2010-01-18 16:42hgbotResolutionopen => fixed
2010-01-18 16:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8c46d759a1c6e32770ca5e80589750fb1d9493c9 [^]
2010-01-19 21:01mtaalNote Added: 0023582
2010-01-19 21:01mtaalStatusresolved => closed
2010-01-19 21:02mtaalFixed in Version => 2.50MP11
2010-01-20 00:01anonymoussf_bug_id0 => 2935289
2010-01-20 23:26hudsonbotCheckin
2010-01-20 23:26hudsonbotNote Added: 0023668

Notes
(0023507)
hgbot   
2010-01-18 16:42   
Repository: erp/devel/pi
Changeset: 8c46d759a1c6e32770ca5e80589750fb1d9493c9
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Jan 18 16:42:09 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8c46d759a1c6e32770ca5e80589750fb1d9493c9 [^]

Fixed issue 11600. Foreign key related warnings will be shown also for columns added to a table which doesn't belong to the module.

---
M src/org/openbravo/service/system/DatabaseValidator.java
---
(0023582)
mtaal   
2010-01-19 21:01   
Checked and works
(0023668)
hudsonbot   
2010-01-20 23:26   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/8c46d759a1c6 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/fa6621f85351 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15942.obx [^]