0027153: AD dataset can't define several times the same table

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027153

Openbravo ERP

Y. DBSourceManager

public

2014-07-22 12:55

2022-02-01 08:05

Reporter

alostale

Assigned To

Triage Platform Base

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0027153: AD dataset can't define several times the same table

Description

If 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

Tags

No tags attached.

Relationships

related to

defect

0027152

3.0PR14Q4

closed

alostale

can't export to dataset tree nodes defined in new trees