0042056: Error installing loyalty Loyalty Programs module without Retail Configuration module

Description

Error installing loyalty Loyalty Programs module without Retail Pack

OBLP_Earn_Rule_Org.AD_Org_ID column in Loyalty Programs module is using a reference that belongs to Retail Configuration module, but Loyalty Programs only depends on Core.

Steps To Reproduce

In a OB instance without any external module, install Loyalty Programs module: https://code.openbravo.com/erp/pmods/org.openbravo.loyalty.programs [^]

Following error is shown:
SQL Command failed with: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_reference_columnvalue"
Detail: Key (ad_reference_value_id)=(7E5BA22863C446E89403D51F3F157738) is not present in table "ad_reference".

Proposed Solution

Change reference of OBLP_Earn_Rule_Org.AD_Org_ID column from "Store Organization Selector" to a similar reference in Core that doesn't filter by store.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0115184) inigo_lerga (viewer) 2019-10-21 14:29	Test Plan: Install or clone the Loyalty Programs module. Realize that the module gives a compilation error due to dependencies to retail modules that should not be there. Following error is shown: SQL Command failed with: ERROR: insert or update on table "ad_column" violates foreign key constraint "ad_reference_columnvalue" Detail: Key (ad_reference_value_id)=(7E5BA22863C446E89403D51F3F157738) is not present in table "ad_reference".

Issue History
Date Modified	Username	Field	Change
2019-10-17 13:23	aferraz	New Issue
2019-10-17 13:23	aferraz	Assigned To	=> Triage Finance
2019-10-17 13:23	aferraz	OBNetwork customer	=> No
2019-10-17 13:26	Sandrahuguet	Assigned To	Triage Finance => inigo_lerga
2019-10-18 11:03	inigo_lerga	Status	new => scheduled
2019-10-21 14:29	inigo_lerga	Note Added: 0115184