Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004726Openbravo ERPY. DBSourceManagerpublic2008-08-27 10:352009-03-18 11:02
Reportermarvintm 
Assigned Tomarvintm 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS 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
Summary0004726: Several indexes are not exported in Oracle
DescriptionAfter creating a database and exporting it, several indexes are not exported.
Steps To Reproduceant create.database
ant export.database

Several indexes in tables should have disappeared.
Proposed SolutionThe solution is to change the order of the primary key and index creation statements, during the creation of the database, in dbsourcemanager.
Additional Information
Tagsdbsm_migrate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-27 10:35marvintmNew Issue
2008-08-27 10:35marvintmAssigned To => marvintm
2008-08-27 10:36svnbotCheckin
2008-08-27 10:36svnbotNote Added: 0008764
2008-08-27 10:36svnbotStatusnew => resolved
2008-08-27 10:36svnbotResolutionopen => fixed
2008-08-27 10:36svnbotsvn_revision => 111
2008-08-27 11:00svnbotCheckin
2008-08-27 11:00svnbotNote Added: 0008765
2008-08-27 11:00svnbotsvn_revision111 => 112
2008-12-15 19:00psarobeStatusresolved => 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:42jpabloaeCategory => Y. DBSourceManager
2009-03-18 11:02anonymoussf_bug_id0 => 2691344

Notes
(0008764)
svnbot   
2008-08-27 10:36   
Repository: dbsourcemanager
Revision: 111
Author: marvintm
Date: 2008-08-27 10:36:23 +0200 (Wed, 27 Aug 2008)

Fixed issue 0004726. Now the indexes will be created after the primary keys, so make sure their type is correct, and that therefore they are exported without problems in Oracle.

---
U branches/r0.8x/src/org/apache/ddlutils/platform/SqlBuilder.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=111&sc=1 [^]
(0008765)
svnbot   
2008-08-27 11:00   
Repository: dbsourcemanager
Revision: 112
Author: marvintm
Date: 2008-08-27 11:00:10 +0200 (Wed, 27 Aug 2008)

Backport of bug 4726 fix. Now indexes will be created after primary keys.

---
_U trunk/
U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java
---

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