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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006501
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2008-12-11 18:222009-04-22 00:00
ReportershuehnerView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision11709
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version
OS VersionDatabase version8.3.5Ant version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006501: 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
Tagsdbsm_migrate
Attached Fileslog file icon update.database.oracle.r10408.11123.works.log [^] (9,853 bytes) 2008-12-11 18:31
log file icon update.database.postgresql.r10408.11123.broken.log [^] (34,886 bytes) 2008-12-11 18:42

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0011977)
svnbot (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-12-11 18:22 shuehner New Issue
2008-12-11 18:31 shuehner File Added: update.database.oracle.r10408.11123.works.log
2008-12-11 18:42 shuehner File Added: update.database.postgresql.r10408.11123.broken.log
2008-12-18 11:14 rafaroda Status new => scheduled
2008-12-18 11:14 rafaroda fix_in_branch => trunk
2008-12-18 12:38 jpabloae Sticky Issue No => Yes
2008-12-18 12:39 jpabloae Sticky Issue Yes => No
2008-12-18 12:39 jpabloae Tag Attached: dbsm_migrate
2008-12-18 12:41 jpabloae Project @4@ => Openbravo ERP
2008-12-18 12:41 jpabloae Category => Y. DBSourceManager
2008-12-18 12:43 jpabloae Assigned To => marvintm
2009-01-08 11:50 svnbot Checkin
2009-01-08 11:50 svnbot Note Added: 0011977
2009-01-08 11:50 svnbot Status scheduled => resolved
2009-01-08 11:50 svnbot Resolution open => fixed
2009-01-08 11:50 svnbot svn_revision => 203
2009-01-08 11:50 svnbot Checkin
2009-01-08 11:50 svnbot Note Added: 0011978
2009-01-08 11:50 svnbot svn_revision 203 => 11709
2009-04-21 11:09 psarobe Status resolved => closed
2009-04-22 00:00 anonymous sf_bug_id 0 => 2777918


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker