Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009000Openbravo ERPA. Platformpublic2009-05-12 09:162009-06-04 00:00
mtaal 
mtaal 
normalmajoralways
closedfixed 
5
pi 
pi 
Core
No
0009000: References in the database without using foreign keys can go wrong in import:
There are a number of tables in the database which store references to other tables without a foreign key constraint. This because one foreign key column can point to multiple other tables.

See also issue:
https://issues.openbravo.com/view.php?id=8509 [^]

This was solved for AD_Tree/AD_TreeNode but also needs to be solved for:
AD_Alert, AD_Attachement and Fact_Acct

See attached xls.
250mp2
xls DynamicReferences.xls (17,920) 2009-05-12 09:16
https://issues.openbravo.com/file_download.php?file_id=1296&type=bug
Issue History
2009-05-12 09:16mtaalNew Issue
2009-05-12 09:16mtaalAssigned To => mtaal
2009-05-12 09:16mtaalFile Added: DynamicReferences.xls
2009-05-12 09:16mtaalRegression testing => No
2009-05-14 17:58psarobeTag Attached: 250mp2
2009-05-14 17:58psarobeStatusnew => scheduled
2009-05-14 17:58psarobefix_in_branch => pi
2009-05-18 16:36hgbotCheckin
2009-05-18 16:36hgbotNote Added: 0016430
2009-05-18 16:36hgbotStatusscheduled => resolved
2009-05-18 16:36hgbotResolutionopen => fixed
2009-05-18 16:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3dac42f312310165bda6712500c20d2d7bfff89c [^]
2009-06-03 17:35psarobeStatusresolved => closed
2009-06-04 00:00anonymoussf_bug_id0 => 2800781

Notes
(0016430)
hgbot   
2009-05-18 16:36   
Repository: erp/devel/pi
Changeset: 3dac42f312310165bda6712500c20d2d7bfff89c
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Mon May 18 16:35:00 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3dac42f312310165bda6712500c20d2d7bfff89c [^]

fixes issue 9000: 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/dal/xml/EntityXMLConverter.java
M src/org/openbravo/service/db/DataImportService.java
A src/org/openbravo/dal/xml/PrimitiveReferenceHandler.java
---