Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011600
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2009-12-02 11:272010-01-20 23:26
ReporternetworkbView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version2.50MP11
StatusclosedFix in branchFixed in SCM revision8c46d759a1c6
ProjectionnoneETAnoneTarget Version2.50MP11
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP9SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011600: '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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0023507)
hgbot (developer)
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 (viewer)
2010-01-19 21:01

 Checked and works
(0023668)
hudsonbot (viewer)
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 [^]

- Issue History
Date Modified Username Field Change
2009-12-02 11:27 networkb New Issue
2009-12-02 11:27 networkb Assigned To => rafaroda
2009-12-02 11:27 networkb OBNetwork customer => Yes
2009-12-07 19:57 psarobe Assigned To rafaroda => marvintm
2009-12-07 19:57 psarobe Priority immediate => normal
2009-12-07 19:57 psarobe Status new => scheduled
2010-01-18 16:42 hgbot Checkin
2010-01-18 16:42 hgbot Note Added: 0023507
2010-01-18 16:42 hgbot Status scheduled => resolved
2010-01-18 16:42 hgbot Resolution open => fixed
2010-01-18 16:42 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8c46d759a1c6e32770ca5e80589750fb1d9493c9 [^]
2010-01-19 21:01 mtaal Note Added: 0023582
2010-01-19 21:01 mtaal Status resolved => closed
2010-01-19 21:02 mtaal Fixed in Version => 2.50MP11
2010-01-20 00:01 anonymous sf_bug_id 0 => 2935289
2010-01-20 23:26 hudsonbot Checkin
2010-01-20 23:26 hudsonbot Note Added: 0023668

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker