Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009650 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-06-26 10:07 | 2009-08-19 00:00 | |||
| Reporter | joan | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 53b560533be1 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.5.0_14-b03 | |||
| OS Version | Debian Etch | Database version | 8.3 | Ant version | 1.6.5 | |||
| Product Version | 2.40 | 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 | 0009650: Upgrade from 2.40 to 2.50MP1, foreign key changes update problem. | |||||||
| Description | When you changed in ob.2.40 a foreign key for instance you create an on update cascade in any of the existing foreign-key references when you do the upgrade to 2.50MP1 following the documentation on http://wiki.openbravo.com/wiki/ERP/2.50/Upgrading_From_2.40 [^] and you reach the step ant export.database export.config.script -Dforce=true when it is doing ant export.config.script -Dforce=true after do the ant export.database -Dforce=true It fails throwing Loading model for module. Path: /opt/upgrade/ob250up/modules/org.openbravo.upgrade.template/src-db/database/model [exportconfigscript] org.apache.ddlutils.model.ModelException: There are multiple foreign keys in table AD_MODEL_OBJECT with the name MODELOBJECT_FK_REFERENCE [exportconfigscript] at org.apache.ddlutils.model.Database.initialize(Database.java:786) [exportconfigscript] at org.openbravo.ddlutils.task.DatabaseUtils.readDatabase(DatabaseUtils.java:74) [exportconfigscript] at org.openbravo.ddlutils.task.ExportConfigScript.doExecute(ExportConfigScript.java:106) ... The problem is the foreign key already exists on the database, and there is no update constraint, so it should drop the existing foreign key and add the new one instead of give the error. | |||||||
| Steps To Reproduce | Install ob240 DROP MODELOBJECT_FK_REFERENCE reference from table AD_MODEL_OBJECT ADD new MODELOBJECT_FK_REFERENCE with a "on update cascade" Try to upgrade from ob240 to ob250 folllowing the wiki http://wiki.openbravo.com/wiki/ERP/2.50/Upgrading_From_2.40 [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0017702) iciordia (manager) 2009-06-30 21:44 |
Joan, thanks for reporting this issue. The problem is that your change in the constraint is identified and included in your module (using ad_exception store since you are not following naming convention). But then DBSourceManager does not manage it properly and tries to create this constraint twice instead of ignoring core one (module exceptions are meant to replace core components). Furthermore, it would be better managed as a change included in the configuration script of your customization (right now this kind of change is not supported by configuration scripts). I am changing the severity to urgent since you can easily work around the problem: remove the constraint from db xml files in core and build your system again, your customized constraint will be kept. The fix for this bug will be planned for next sprint. Ismael |
|
(0017714) joan (reporter) 2009-07-01 09:35 |
ok, thanks for the response :) I will use the workaround until it is solved Thanks :) |
|
(0018648) hgbot (developer) 2009-07-28 11:14 |
Repository: erp/devel/pi Changeset: 53b560533be192e152b871dcc8e0da951a78796b Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Tue Jul 28 11:13:27 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/53b560533be192e152b871dcc8e0da951a78796b [^] Fixed issue 9650. Now if several foreign keys with the same name for the same table are found when doing a model merge, the last one 'prevails' (the previous ones are overwritten). --- M src-db/database/lib/dbsourcemanager.jar --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-26 10:07 | joan | New Issue | |
| 2009-06-26 10:07 | joan | Assigned To | => rafaroda |
| 2009-06-30 21:44 | iciordia | Note Added: 0017702 | |
| 2009-06-30 21:44 | iciordia | Assigned To | rafaroda => marvintm |
| 2009-06-30 21:44 | iciordia | Priority | normal => urgent |
| 2009-07-01 09:35 | joan | Note Added: 0017714 | |
| 2009-07-01 11:11 | iciordia | Severity | critical => major |
| 2009-07-13 13:30 | psarobe | Relationship added | blocks 0009776 |
| 2009-07-20 22:18 | psarobe | Status | new => scheduled |
| 2009-07-20 22:18 | psarobe | fix_in_branch | => pi |
| 2009-07-28 11:14 | hgbot | Checkin | |
| 2009-07-28 11:14 | hgbot | Note Added: 0018648 | |
| 2009-07-28 11:14 | hgbot | Status | scheduled => resolved |
| 2009-07-28 11:14 | hgbot | Resolution | open => fixed |
| 2009-07-28 11:14 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/53b560533be192e152b871dcc8e0da951a78796b [^] |
| 2009-08-18 10:16 | plujan | Status | resolved => closed |
| 2009-08-19 00:00 | anonymous | sf_bug_id | 0 => 2839882 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |