Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007068 | Openbravo ERP | Y. DBSourceManager | public | 2009-01-21 19:58 | 2023-09-22 12:08 |
| Reporter | shuehner | ||||
| Assigned To | marvintm | ||||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| 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 | 0007068: update.database fails on postgres when updating accross 12107 | ||||
| Description | Commit 12107 did remove the AD_TAB entry for the tab with the name 'Period Control' and in the same commit add a new record for a tab with the same name 'Period Control' but a different uuid. When updating postgres shows the error message: Executed 414 SQL command(s) with 0 error(s) Model update complete. Disabling foreign keys Executed 0 SQL command(s) with 0 error(s) Disabling triggers Executed 408 SQL command(s) with 0 error(s) Updating database data... Error while inserting into the database: ERROR: duplicate key value violates unique constraint "ad_tab_window_name_unique" [alterdatabasedataall] org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ERROR: duplicate key value violates unique constraint "ad_tab_window_name_unique" [alterdatabasedataall] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1557) | ||||
| Steps To Reproduce | |||||
| Proposed Solution | Check ordering of statements in update.database if not solvable in dbsm revert 12107 and commit it in two steps and advice all developers about the limitation. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-01-21 19:58 | shuehner | New Issue | |||
| 2009-01-21 19:58 | shuehner | Assigned To | => marvintm | ||
| 2009-01-21 19:58 | shuehner | sf_bug_id | 0 => 2526785 | ||
| 2009-01-21 19:58 | shuehner | Regression testing | => No | ||
| 2009-01-21 20:12 | shuehner | Note Added: 0012490 | |||
| 2009-01-22 12:45 | svnbot | Checkin | |||
| 2009-01-22 12:45 | svnbot | Note Added: 0012523 | |||
| 2009-01-22 12:45 | svnbot | Status | new => resolved | ||
| 2009-01-22 12:45 | svnbot | Resolution | open => fixed | ||
| 2009-01-22 12:45 | svnbot | svn_revision | => 214 | ||
| 2009-01-22 12:46 | svnbot | Checkin | |||
| 2009-01-22 12:46 | svnbot | Note Added: 0012524 | |||
| 2009-01-22 12:46 | svnbot | svn_revision | 214 => 12153 | ||
| 2009-01-22 19:18 | svnbot | Checkin | |||
| 2009-01-22 19:18 | svnbot | Note Added: 0012539 | |||
| 2009-01-22 19:18 | svnbot | svn_revision | 12153 => 12166 | ||
| 2009-04-21 11:05 | psarobe | Status | resolved => closed | ||
| 2023-09-15 12:55 | hgbot | Note Added: 0154898 | |||
| 2023-09-21 12:05 | hgbot | Note Added: 0155092 | |||
| 2023-09-21 12:05 | hgbot | Note Added: 0155097 | |||
| 2023-09-21 13:12 | hgbot | Note Added: 0155105 | |||
| 2023-09-22 08:40 | igor_trebol | Note Deleted: 0155105 | |||
| 2023-09-22 08:40 | igor_trebol | Note Deleted: 0155097 | |||
| 2023-09-22 08:40 | igor_trebol | Note Deleted: 0155092 | |||
| 2023-09-22 08:40 | igor_trebol | Note Deleted: 0154898 | |||
| 2023-09-22 12:08 | hgbot | Note Added: 0155174 | |||
| 2023-09-29 10:57 | igor_trebol | Note Deleted: 0155174 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||