Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000207 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | sometimes | 2008-05-08 10:06 | 2009-03-18 11:01 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0000207: Error while trying to change a table's primary key | |||||||
| Description | Sometimes, when trying to change a table's primary key through a update.database task, the process fails, with a message similar to the following one: [alterdatabase] SQL Command failed with: ORA-00955: name is already used by an existing object [alterdatabase] [alterdatabase] -- END [alterdatabase] ALTER TABLE C_INVOICETAX [alterdatabase] ADD CONSTRAINT C_INVOICETAX_KEY PRIMARY KEY (C_INVOICETAX_ID) This problem is caused by an index associated to the previous primary key. This index has not been deleted, and prevents DBSourcemanager from creating the new primary key. | |||||||
| Steps To Reproduce | Sometimes this error can be reproduced by importing a previous database, changing the primary key of a table xml file (changing the columns, but not the primary key name), and doing an update.database. | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0000070) marvintm (viewer) 2008-05-08 11:43 |
Now in Oracle when dropping the Primary Key the index associated with it will be dropped as well, to prevent problems when trying to create a new Primary Key. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-08 10:06 | marvintm | New Issue | |
| 2008-05-08 10:06 | marvintm | Assigned To | => marvintm |
| 2008-05-08 10:10 | marvintm | Status | new => @40@ |
| 2008-05-08 10:10 | marvintm | Status | @40@ => scheduled |
| 2008-05-08 11:43 | marvintm | Status | scheduled => resolved |
| 2008-05-08 11:43 | marvintm | Resolution | open => fixed |
| 2008-05-08 11:43 | marvintm | Note Added: 0000070 | |
| 2008-11-26 14:12 | psarobe | Status | resolved => closed |
| 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 |
| 2009-03-18 11:01 | anonymous | sf_bug_id | 0 => 2691234 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |