Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000207 | Openbravo ERP | Y. DBSourceManager | public | 2008-05-08 10:06 | 2009-03-18 11:01 |
| Reporter | marvintm | ||||
| Assigned To | marvintm | ||||
| Priority | high | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| 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. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | dbsm_migrate | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||