Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008509 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2009-04-08 15:46 | 2009-05-05 00:00 | |||
| Reporter | mtaal | View Status | public | |||||
| Assigned To | mtaal | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | c4c962d260f7 | ||||
| Projection | none | ETA | none | Target Version | pi | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | 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 | 0008509: References in the database without using foreign keys can go wrong in import | |||||||
| Description | The issue the training people are having is related to the >>> ad_treenode.node_id column. The following situation occurs: >>> - a dataset contains both normal objects and a set of treenodes >>> - the node_id in the treenodes contain id's of the other objects in >>> the import dataset (they refer to them) >>> - when importing, the id's of the objects change >>> - the node_id of the treenode instances (in the imported dataset) is >>> not updated >>> - the import process creates treenodes which refer to other objects >>> (or even non-existing objects) >>> >>> In the case of the training people this resulted in an invalid >>> organisation structure. | |||||||
| Tags | 250MP1 | |||||||
| Attached Files |  DynamicReferences.xls [^] (17,920 bytes) 2009-04-08 15:47 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0015287) mtaal (manager) 2009-04-08 15:47 |
-Add new column: AD_Table.TreeType (VARCHAR2(60), nullable, unique, reference list "ad_tree_type"(120)) and add values for tables defined below by Martin -Fix four cases in DAL: AD_Alert, AD_Attachement, AD_TreeNode and Fact_Acct -Send the fix to Training team if needed (Martin decides) -For 2.60 solve AD_PInstance |
|
(0015620) hgbot (developer) 2009-04-23 14:08 |
Repository: erp/devel/pi Changeset: c4c962d260f70b4dd8e9f71364b0be636eef7882 Author: Martin Taal <martin.taal <at> openbravo.com> Date: Thu Apr 23 14:08:14 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/c4c962d260f70b4dd8e9f71364b0be636eef7882 [^] Fixes issue 8509: References in the database without using foreign keys can go wrong in import --- M src-test/org/openbravo/test/xml/ClientExportImportTest.java M src/org/openbravo/base/model/Entity.java M src/org/openbravo/base/model/ModelProvider.java M src/org/openbravo/base/model/Table.hbm.xml M src/org/openbravo/base/model/Table.java M src/org/openbravo/dal/xml/EntityXMLConverter.java M src/org/openbravo/service/db/DataImportService.java --- |
|
(0016024) psarobe (manager) 2009-05-04 18:32 |
Not able to test by QA |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-08 15:46 | mtaal | New Issue | |
| 2009-04-08 15:46 | mtaal | Assigned To | => rafaroda |
| 2009-04-08 15:46 | mtaal | Regression testing | => No |
| 2009-04-08 15:46 | mtaal | Assigned To | rafaroda => mtaal |
| 2009-04-08 15:47 | mtaal | Note Added: 0015287 | |
| 2009-04-08 15:47 | mtaal | File Added: DynamicReferences.xls | |
| 2009-04-22 18:45 | psarobe | Priority | normal => urgent |
| 2009-04-22 18:45 | psarobe | Status | new => scheduled |
| 2009-04-23 14:08 | hgbot | Checkin | |
| 2009-04-23 14:08 | hgbot | Note Added: 0015620 | |
| 2009-04-23 14:08 | hgbot | Status | scheduled => resolved |
| 2009-04-23 14:08 | hgbot | Resolution | open => fixed |
| 2009-04-23 14:08 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c4c962d260f70b4dd8e9f71364b0be636eef7882 [^] |
| 2009-04-23 18:24 | psarobe | Tag Attached: 250MP1 | |
| 2009-05-04 18:32 | psarobe | Status | resolved => closed |
| 2009-05-04 18:32 | psarobe | Note Added: 0016024 | |
| 2009-05-05 00:00 | anonymous | sf_bug_id | 0 => 2786894 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |