0021591: AD_Module_Id column in AD_Ref_data_loaded should not have reference tabledir

Description

Currently, the AD_Module_Id column in the AD_Ref_Data_Loaded table has reference tabledir.

This is wrong, because that column sometimes doesn't point to an existing record (so reference integrity sometimes is not maintained for it), for example, in case a module was uninstalled from the system.

This in turn means that if a valid .xml file generated through an "export client" execution contains ad_ref_data_loaded records, the process to import it will fail if the data points to non-installed modules, which is not correct.

Steps To Reproduce

- Create an Openbravo instance.
- Import a dataset (for example, the spanish taxes dataset)
- Do export client.
- Import the client in a different instance. The import process will fail.

Proposed Solution

The reference of the column should be changed to String. Although this is an API change, it is done to fix an inconsistency, and it's worth to take into account that even if the methods to retrieve the module exist, they would fail in the case a module was uninstalled, so the API was actually "broken".

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0021259

3.0MP16

closed

marvintm

export.sample.data/export-client fails with ad_ref_data* having rows pointing to no longer installed modules.

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2012-09-10 17:07	marvintm	New Issue
2012-09-10 17:07	marvintm	Assigned To	=> marvintm
2012-09-10 17:07	marvintm	Modules	=> Core
2012-09-11 12:36	AugustoMauch	Relationship added	duplicate of 0021259
2012-09-11 12:36	AugustoMauch	Status	new => closed
2012-09-11 12:36	AugustoMauch	Resolution	open => duplicate