Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000468Openbravo ERPY. DBSourceManagerpublic2008-05-29 09:532009-03-18 11:02
Reporterjpabloae 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionGentoo - 2.6.24
Product Version 
Target VersionFixed in Version 
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
Summary0000468: Sampledata consistency not kept in update.database
DescriptionThe "ant update.database" task does not maintain the sampledata consistency. So that if an ID is deleted in sourcedata and there are records in sampledata referencing that ID, then the update.database will fail with a constraint error.

Take into account that in a "svn update" both sampledata and sourcedata are updated. But the update.database doesn't take into account this change in sampledata. Thus it may be necessary to keep this consistency.
Steps To Reproduce1. Delete an AD_PROCESS_ID in AD_PROCESS.xml in sourcedata.
2. Make sure there's a record in sampledata/AD_PROCESS_ACCESS.xml referencing that deleted AD_PROCESS_ID.
3. Run "ant update.database".
Proposed Solution
Additional Information
Tagsdbsm_migrate
Relationships
related to defect 0000469 closed marvintm Constraints consistency not checked in update.database with PostgreSQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-05-29 09:53jpabloaeNew Issue
2008-05-29 10:01jpabloaeRelationship addedrelated to 0000469
2008-06-11 17:54svnbotCheckin
2008-06-11 17:54svnbotNote Added: 0000500
2008-06-11 17:54svnbotStatusnew => resolved
2008-06-11 17:54svnbotResolutionopen => fixed
2008-06-11 17:54svnbotsvn_revision => 72
2008-06-12 02:05cromeroAssigned To => marvintm
2008-06-12 02:05cromeroStatusresolved => new
2008-06-12 02:05cromeroResolutionfixed => open
2008-06-12 12:20svnbotCheckin
2008-06-12 12:20svnbotNote Added: 0007671
2008-06-12 12:20svnbotStatusnew => resolved
2008-06-12 12:20svnbotResolutionopen => fixed
2008-06-12 12:20svnbotsvn_revision72 => 73
2008-11-26 13:50psarobeStatusresolved => closed
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-03-18 11:02anonymoussf_bug_id0 => 2691317

Notes
(0000500)
svnbot   
2008-06-11 17:54   
Repository: dbsourcemanager
Revision: 72
Author: marvintm
Date: 2008-06-11 17:54:08 +0200 (Wed, 11 Jun 2008)

Fixes bug 468 . Now data rows which contain an ON DELETE CASCADE type reference to a missing row will be deleted during the update.database process

---
U trunk/src/org/apache/ddlutils/Platform.java
U trunk/src/org/apache/ddlutils/io/DataToDatabaseSink.java
U trunk/src/org/apache/ddlutils/platform/PlatformImplBase.java
U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java
U trunk/src/org/openbravo/ddlutils/task/AlterDatabaseData.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=72&sc=1 [^]
(0007671)
svnbot   
2008-06-12 12:20   
Repository: dbsourcemanager
Revision: 73
Author: marvintm
Date: 2008-06-12 12:20:38 +0200 (Thu, 12 Jun 2008)

Fixes bug 468 . Now data rows which contain an ON DELETE CASCADE type reference to a missing row will be deleted during the update.database process

---
U trunk/src/org/apache/ddlutils/io/DataToDatabaseSink.java
U trunk/src/org/apache/ddlutils/io/DatabaseDataIO.java
U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=73&sc=1 [^]