Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006501Openbravo ERPY. DBSourceManagerpublic2008-12-11 18:222009-04-22 00:00
Reportershuehner 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS Version
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
Summary0006501: ant update.database in erp-branch r2.40 from r10408 to r11123 fails
DescriptionUsing ant update.database with the specified svn-revision (both are post 2.40MP1) fails. This could possibly affect upgrades from MP1 to MP2.

The upgrade only fails on postgres as inside dbsourcemanager a different codepath seems to be used for oracle vs. postgres.

Log-files for the working update.database on oracle (for these revisions) and for the broken update.database on postgres are attached.
Steps To Reproducecreate working copy for r10408 branch r2.40 of erp
create.database on postgres for this revision
update to r11123
apply patch from issue (6489) which fixes a different update problem
run update.database, see it failing
Proposed Solution
Additional Information
Tagsdbsm_migrate
Relationships
Attached Fileslog update.database.oracle.r10408.11123.works.log (9,853) 2008-12-11 18:31
https://issues.openbravo.com/file_download.php?file_id=527&type=bug
log update.database.postgresql.r10408.11123.broken.log (34,886) 2008-12-11 18:42
https://issues.openbravo.com/file_download.php?file_id=528&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-12-11 18:22shuehnerNew Issue
2008-12-11 18:31shuehnerFile Added: update.database.oracle.r10408.11123.works.log
2008-12-11 18:42shuehnerFile Added: update.database.postgresql.r10408.11123.broken.log
2008-12-18 11:14rafarodaStatusnew => scheduled
2008-12-18 11:14rafarodafix_in_branch => trunk
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
2008-12-18 12:43jpabloaeAssigned To => marvintm
2009-01-08 11:50svnbotCheckin
2009-01-08 11:50svnbotNote Added: 0011977
2009-01-08 11:50svnbotStatusscheduled => resolved
2009-01-08 11:50svnbotResolutionopen => fixed
2009-01-08 11:50svnbotsvn_revision => 203
2009-01-08 11:50svnbotCheckin
2009-01-08 11:50svnbotNote Added: 0011978
2009-01-08 11:50svnbotsvn_revision203 => 11709
2009-04-21 11:09psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777918

Notes
(0011977)
svnbot   
2009-01-08 11:50   
Repository: dbsourcemanager
Revision: 203
Author: marvintm
Date: 2009-01-08 11:50:35 +0100 (Thu, 08 Jan 2009)

Fixed issue 6501. Changed the update mechanism, so that the foreign keys and triggers are removed before both the model and the data update, and added after both updates have been completed.

---
U branches/r0.8x/src/org/apache/ddlutils/io/DataToDatabaseSink.java
U branches/r0.8x/src/org/apache/ddlutils/model/Database.java
U branches/r0.8x/src/org/apache/ddlutils/platform/SqlBuilder.java
U branches/r0.8x/src/org/apache/ddlutils/platform/oracle/Oracle8Builder.java
U branches/r0.8x/src/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
U branches/r0.8x/src/org/openbravo/ddlutils/task/AlterDatabaseData.java
U branches/r0.8x/src/org/openbravo/ddlutils/task/AlterXML2SQL.java
U branches/r0.8x/src/org/openbravo/ddlutils/task/ImportDataXML.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=203&sc=1 [^]
(0011978)
svnbot   
2009-01-08 11:50   
Repository: openbravo
Revision: 11709
Author: marvintm
Date: 2009-01-08 11:50:51 +0100 (Thu, 08 Jan 2009)

Fixed issue 6501. Changed the update mechanism, so that the foreign keys and triggers are removed before both the model and the data update, and added after both updates have been completed.

---
U branches/r2.40/src-db/database/lib/dbsourcemanager.jar
---

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