Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0004763 | Openbravo ERP | Y. DBSourceManager | public | 2008-08-29 16:11 | 2009-03-18 11:02 |
|
| Reporter | marvintm | |
| Assigned To | marvintm | |
| Priority | normal | Severity | major | Reproducibility | always |
| 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 | 0004763: Upgrader gives an error when trying to recreate a UNIQUE constraint in Oracle |
| Description | When a UNIQUE constraint is created in Oracle, an INDEX with the same name is also created.
If the constraint changes, during the update process dbsourcemanager tries to drop it, and create it again. However, the creation is not successfull, because an INDEX with the same name still exists. |
| Steps To Reproduce | Simply create a unique constraint in the database, export the database, change in the xml the constraint (for example, adding more columns to it), and perform the update.database process. |
| Proposed Solution | DBsourcemanager will now drop the constraint and its associated index, ensuring that no problems happen when recreating it. |
| Additional Information | |
| Tags | dbsm_migrate |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2008-08-29 16:11 | marvintm | New Issue | |
| 2008-08-29 16:11 | marvintm | Assigned To | => marvintm |
| 2008-08-29 16:12 | svnbot | Checkin | |
| 2008-08-29 16:12 | svnbot | Note Added: 0008785 | |
| 2008-08-29 16:12 | svnbot | Status | new => resolved |
| 2008-08-29 16:12 | svnbot | Resolution | open => fixed |
| 2008-08-29 16:12 | svnbot | svn_revision | => 117 |
| 2008-11-25 23:36 | 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:02 | anonymous | sf_bug_id | 0 => 2691345 |