Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027153Openbravo ERPY. DBSourceManagerpublic2014-07-22 12:552022-02-01 08:05
Reporteralostale 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027153: AD dataset can't define several times the same table
DescriptionIf AD dataset contains more than one entry for the same table, update.database fails because it tries to create duplicate records.

Having this configuration can make sense in some scenarios where a module defines data stored in a mixed sourcedata-referencedata table and wants to define rules to partially export it. This is the case of ad_tree_node table, which part is exported as source data (menu tree) and part as referenced data.
Steps To Reproduce-Create a new tree with nodes
-Add to AD dataset a new AD_Tree_Node to export nodes in new tree
-export database -> nodes are correctly exported to modules based on rules defined in the previous step
-create database with this modules -> works fine
-update database -> it fails trying to insert duplicate entries in ad_tree_node

an example of this case can be found in
https://code.openbravo.com/erp/mods/org.openbravo.util.performance.bigdb/ [^] @9a68d694a196
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00271523.0PR14Q4 closed alostale can't export to dataset tree nodes defined in new trees 
Attached Filesdiff issue-27153.diff (1,934) 2014-07-22 12:57
https://issues.openbravo.com/file_download.php?file_id=7073&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-07-22 12:55alostaleNew Issue
2014-07-22 12:55alostaleAssigned To => AugustoMauch
2014-07-22 12:55alostaleOBNetwork customer => No
2014-07-22 12:55alostaleModules => Core
2014-07-22 12:55alostaleTriggers an Emergency Pack => No
2014-07-22 12:56alostaleRelationship addedrelated to 0027152
2014-07-22 12:57alostaleFile Added: issue-27153.diff
2014-07-22 12:58alostaleNote Added: 0068802
2014-07-22 12:59alostaleRelationship deletedrelated to 0027152
2014-07-22 12:59alostaleRelationship addeddepends on 0027152
2014-07-22 12:59alostaleRelationship replacedrelated to 0027152
2015-03-11 11:25alostaleStatusnew => acknowledged
2015-03-17 14:38alostaleAssigned ToAugustoMauch => platform
2022-02-01 08:05alostaleAssigned Toplatform => Triage Platform Base

Notes
(0068802)
alostale   
2014-07-22 12:58   
Attached partial fix (not yet working)