Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042056ModulesLoyalty Programspublic2019-10-17 13:232019-10-21 14:29
Reporteraferraz 
Assigned Toinigo_lerga 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0042056: Error installing loyalty Loyalty Programs module without Retail Configuration module
DescriptionError 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 ReproduceIn 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 SolutionChange 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.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-10-17 13:23aferrazNew Issue
2019-10-17 13:23aferrazAssigned To => Triage Finance
2019-10-17 13:23aferrazOBNetwork customer => No
2019-10-17 13:26SandrahuguetAssigned ToTriage Finance => inigo_lerga
2019-10-18 11:03inigo_lergaStatusnew => scheduled
2019-10-21 14:29inigo_lergaNote Added: 0115184

Notes
(0115184)
inigo_lerga   
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".