Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008509Openbravo ERPA. Platformpublic2009-04-08 15:462009-05-05 00:00
Reportermtaal 
Assigned Tomtaal 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionpiFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008509: References in the database without using foreign keys can go wrong in import
DescriptionThe 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.
Steps To Reproduce
Proposed Solution
Additional Information
Tags250MP1
Relationships
Attached Filesxls DynamicReferences.xls (17,920) 2009-04-08 15:47
https://issues.openbravo.com/file_download.php?file_id=1149&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-04-08 15:46mtaalNew Issue
2009-04-08 15:46mtaalAssigned To => rafaroda
2009-04-08 15:46mtaalRegression testing => No
2009-04-08 15:46mtaalAssigned Torafaroda => mtaal
2009-04-08 15:47mtaalNote Added: 0015287
2009-04-08 15:47mtaalFile Added: DynamicReferences.xls
2009-04-22 18:45psarobePrioritynormal => urgent
2009-04-22 18:45psarobeStatusnew => scheduled
2009-04-23 14:08hgbotCheckin
2009-04-23 14:08hgbotNote Added: 0015620
2009-04-23 14:08hgbotStatusscheduled => resolved
2009-04-23 14:08hgbotResolutionopen => fixed
2009-04-23 14:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c4c962d260f70b4dd8e9f71364b0be636eef7882 [^]
2009-04-23 18:24psarobeTag Attached: 250MP1
2009-05-04 18:32psarobeStatusresolved => closed
2009-05-04 18:32psarobeNote Added: 0016024
2009-05-05 00:00anonymoussf_bug_id0 => 2786894

Notes
(0015287)
mtaal   
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   
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   
2009-05-04 18:32   
Not able to test by QA