Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0005039 | Openbravo ERP | Y. DBSourceManager | public | 2008-09-12 13:39 | 2009-03-18 11:02 |
|
| Reporter | psarobe | |
| Assigned To | marvintm | |
| Priority | urgent | 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 | 0005039: Upgrader MP4-MP5- Some contrainst missed after the running the upgrader |
| Description | The problem arises when you import a language in MP4 different than Spanish language and in some trl tables the parent is missed so PostgreSQL remove those contraints.
The cause of the problem is that when a record is removed from AD_ELEMENT, for example, its child it is not removed.
The tables that we have found this are: AD_ELEMEN, AD_PROCESS_PARA, AD_TEXTINTERFACES
For the AD_TEXTINTERFACES table there is a collateral problem due to this. If you add custom code in srcClient just before running the upgrade and this code has new labels, when launching the translate process it will insert in table AD_TEXTINTERFACES new entries but it will crash. SEE ATTACH for this
These are the constraints:
Table AD_ELEMENT_TRL. Referential integrity with its parent (AD_ELEMENT_ID)
Table AD_PROCESS_PARA_TRL. Referential integrity with its parent (AD_PROCESS_PARA_ID)
Table AD_TEXTINTERFACES_TRL. Referential integrity with its parent (AD_TEXTINTERFACES_ID)
|
| Steps To Reproduce | http://wiki.openbravo.com/wiki/Upgraders_Testing [^]
|
| Proposed Solution | |
| Additional Information | |
| Tags | dbsm_migrate |
| Relationships | |
| Attached Files |  03build.log (458,934) 2008-09-12 13:39
https://issues.openbravo.com/file_download.php?file_id=251&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2008-09-12 13:39 | psarobe | New Issue | |
| 2008-09-12 13:39 | psarobe | Assigned To | => marvintm |
| 2008-09-12 13:39 | psarobe | File Added: 03build.log | |
| 2008-09-12 19:14 | psarobe | Status | new => scheduled |
| 2008-09-12 19:14 | psarobe | fix_in_branch | => trunk |
| 2008-09-15 10:42 | svnbot | Checkin | |
| 2008-09-15 10:42 | svnbot | Note Added: 0009016 | |
| 2008-09-15 10:42 | svnbot | Status | scheduled => resolved |
| 2008-09-15 10:42 | svnbot | Resolution | open => fixed |
| 2008-09-15 10:42 | svnbot | svn_revision | => 121 |
| 2008-10-07 11:33 | psarobe | Status | resolved => closed |
| 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 => 2691352 |