Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005039 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-09-12 13:39 | 2009-03-18 11:02 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 121 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| 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 [^] | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files |  03build.log [^] (458,934 bytes) 2008-09-12 13:39 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0009016) svnbot (reporter) 2008-09-15 10:42 |
Repository: dbsourcemanager Revision: 121 Author: marvintm Date: 2008-09-15 10:42:44 +0200 (Mon, 15 Sep 2008) Fixed bug 5039. Now rows that invalidate an ON DELETE CASCADE foreign key will be deleted while updating the database. --- U branches/r0.7x/src/org/apache/ddlutils/Platform.java U branches/r0.7x/src/org/apache/ddlutils/platform/PlatformImplBase.java U branches/r0.7x/src/org/openbravo/ddlutils/task/AlterCustomizedDatabaseData.java U branches/r0.7x/src/org/openbravo/ddlutils/task/AlterDatabase.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=121&sc=1 [^] |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |