Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007312Openbravo ERPY. DBSourceManagerpublic2009-02-02 12:322009-04-21 12:39
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007312: update.database may fail when the dataset definition is changed
DescriptionIf the dataset definition is changed (for example, if a table is removed from the dataset AD), update.database will not work correctly.

The reason for this is that the dataset definition that DAL (and therefore dbsourcemanager) uses is the one stored in the database.
Steps To Reproduce
Proposed SolutionThe most obvious solution is to update the dataset tables first when doing an update.database, and then do the update of the rest of the tables.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-02 12:32marvintmNew Issue
2009-02-02 12:32marvintmAssigned To => marvintm
2009-02-02 12:32marvintmsf_bug_id0 => 2556634
2009-02-02 12:32marvintmOBNetwork customer => No
2009-02-02 12:32marvintmRegression testing => No
2009-02-02 13:00svnbotCheckin
2009-02-02 13:00svnbotNote Added: 0013009
2009-02-02 13:00svnbotStatusnew => resolved
2009-02-02 13:00svnbotResolutionopen => fixed
2009-02-02 13:00svnbotsvn_revision => 225
2009-02-02 13:02svnbotCheckin
2009-02-02 13:02svnbotNote Added: 0013010
2009-02-02 13:02svnbotsvn_revision225 => 12645
2009-04-21 12:39psarobeStatusresolved => closed

Notes
(0013009)
svnbot   
2009-02-02 13:00   
Repository: dbsourcemanager
Revision: 225
Author: marvintm
Date: 2009-02-02 13:00:10 +0100 (Mon, 02 Feb 2009)

Fixed issue 7312. Now dataset tables will be updated at the begining if necessary, and then the rest of the tables will be updated.

---
U trunk/src/org/apache/ddlutils/alteration/DataComparator.java
U trunk/src/org/openbravo/ddlutils/task/AlterDatabaseDataAll.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=225&sc=1 [^]
(0013010)
svnbot   
2009-02-02 13:02   
Repository: openbravo
Revision: 12645
Author: marvintm
Date: 2009-02-02 13:02:17 +0100 (Mon, 02 Feb 2009)

Fixed issue 7312. Now dataset tables will be updated at the begining if necessary, and then the rest of the tables will be updated.

---
U trunk/src/org/openbravo/service/dataset/DataSetService.java
U trunk/src-db/database/lib/dbsourcemanager.jar
U trunk/src-db/database/sourcedata/AD_DATASET.xml
U trunk/src-db/database/sourcedata/AD_DATASET_TABLE.xml
---

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