Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032965Retail ModulesLoyalty Management for Retailpublic2016-05-16 14:032016-06-23 19:40
Reportershuehner 
Assigned Toshivum039 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032965: Module is not installable at all on oracle
DescriptionThis module fails to install on oracle.

As it has 2 fk-constraints with identical name which is not allowed on oracle.

Cause apparently -> copy'n'paste to create 2nd fk-constraint and never tested on oracle.

./org.openbravo.retail.loyalty/src-db/database/model/tables/OBLOY_ACCUMULATEDPOINTS.xml: <foreign-key foreignTable="AD_ORG" name="OBLOY_LOYALTYSPONSORSHIP_ORG">
./org.openbravo.retail.loyalty/src-db/database/model/tables/OBLOY_LOYALTYSPONSORSHIP.xml: <foreign-key foreignTable="AD_ORG" name="OBLOY_LOYALTYSPONSORSHIP_ORG">


Apart from these, the following names should also be fixed:

SQL Command failed with: ORA-02264: name already used by an existing constraint

-- END
ALTER TABLE OBLOY_ACCUMULATIONRULES
    ADD CONSTRAINT OBLOY_ACCUMULATION_ACTIVE_CHK CHECK (ISACTIVE IN ('Y', 'N'))


SQL Command failed with: ORA-02264: name already used by an existing constraint

-- END
ALTER TABLE OBLOY_LOYALTYSPONSORSHIP
    ADD CONSTRAINT OBLOY_SPONSORSHIP_ACTIVE_CHK CHECK (ISACTIVE IN ('Y', 'N'))
SQL Command failed with: ORA-02264: name already used by an existing constraint

-- END
ALTER TABLE OBLOY_REDEEMEDPOINTS
    ADD CONSTRAINT OBLOY_REDEEMED_ACTIVE_CHK CHECK (ISACTIVE IN ('Y', 'N'))
Steps To ReproduceTry to install it on oracle.
Proposed SolutionRename the 2nd constraint according to naming rules
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0032966 new Triage Platform Base Openbravo ERP Add module validation to verify no 2 foreign keys have identical name in a table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-16 14:03shuehnerNew Issue
2016-05-16 14:03shuehnerAssigned To => Retail
2016-05-16 14:03shuehnerTriggers an Emergency Pack => No
2016-05-16 14:06shuehnerRelationship addedrelated to 0032966
2016-05-17 19:40shuehnerNote Added: 0086509
2016-05-17 19:41marvintmDescription Updatedbug_revision_view_page.php?rev_id=12142#r12142
2016-05-17 19:42marvintmDescription Updatedbug_revision_view_page.php?rev_id=12143#r12143
2016-06-21 11:04marvintmStatusnew => scheduled
2016-06-21 11:04marvintmAssigned ToRetail => shivum039
2016-06-21 16:49hgbotCheckin
2016-06-21 16:49hgbotNote Added: 0087744
2016-06-21 16:49hgbotStatusscheduled => resolved
2016-06-21 16:49hgbotResolutionopen => fixed
2016-06-21 16:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/14325804afdf6a9446b88c7a1e2d80da8b5ba210 [^]
2016-06-21 17:43hgbotCheckin
2016-06-21 17:43hgbotNote Added: 0087750
2016-06-21 17:43hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/14325804afdf6a9446b88c7a1e2d80da8b5ba210 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/e773a46d5d572d4aa4fadab6ec6fe3167b3b917b [^]
2016-06-21 18:20hgbotCheckin
2016-06-21 18:20hgbotNote Added: 0087757
2016-06-21 18:20hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/e773a46d5d572d4aa4fadab6ec6fe3167b3b917b [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/3976b1abcb04bc1c05b7facfa595ba61beb50307 [^]
2016-06-22 10:31hgbotCheckin
2016-06-22 10:31hgbotNote Added: 0087783
2016-06-22 10:31hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/3976b1abcb04bc1c05b7facfa595ba61beb50307 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/4b87a0e1698061d0b969f032269cf074f849c4c6 [^]
2016-06-23 19:40marvintmReview Assigned To => marvintm
2016-06-23 19:40marvintmStatusresolved => closed

Notes
(0086509)
shuehner   
2016-05-17 19:40   
3 more issues in apparently same module:

SQL Command failed with: ORA-02264: name already used by an existing constraint

-- END
ALTER TABLE OBLOY_ACCUMULATIONRULES
    ADD CONSTRAINT OBLOY_ACCUMULATION_ACTIVE_CHK CHECK (ISACTIVE IN ('Y', 'N'))

SQL Command failed with: ORA-02264: name already used by an existing constraint

-- END
ALTER TABLE OBLOY_LOYALTYSPONSORSHIP
    ADD CONSTRAINT OBLOY_SPONSORSHIP_ACTIVE_CHK CHECK (ISACTIVE IN ('Y', 'N'))
SQL Command failed with: ORA-02264: name already used by an existing constraint

-- END
ALTER TABLE OBLOY_REDEEMEDPOINTS
    ADD CONSTRAINT OBLOY_REDEEMED_ACTIVE_CHK CHECK (ISACTIVE IN ('Y', 'N'))
(0087744)
hgbot   
2016-06-21 16:49   
Repository: erp/pmods/org.openbravo.retail.loyalty
Changeset: 14325804afdf6a9446b88c7a1e2d80da8b5ba210
Author: Shivanand Madiwalar <shivanand.madiwalar <at> promantia.com>
Date: Tue Jun 21 20:18:49 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/14325804afdf6a9446b88c7a1e2d80da8b5ba210 [^]

Fixes Issue 32965 : Definition Of Constarints Changed To Match Compatibility .

---
M src-db/database/model/tables/OBLOY_ACCUMULATEDPOINTS.xml
M src-db/database/model/tables/OBLOY_ACCUMULATIONRULES.xml
M src-db/database/model/tables/OBLOY_CANCELREDEMPTION.xml
---
(0087750)
hgbot   
2016-06-21 17:43   
Repository: erp/pmods/org.openbravo.retail.loyalty
Changeset: e773a46d5d572d4aa4fadab6ec6fe3167b3b917b
Author: Shivanand Madiwalar <shivanand.madiwalar <at> promantia.com>
Date: Tue Jun 21 21:12:46 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/e773a46d5d572d4aa4fadab6ec6fe3167b3b917b [^]

Fixes Issue 32965 : Definition Of Constarints Changed To Match Compatibility .

---
M src-db/database/model/tables/OBLOY_ACCUMULATEDPOINTS.xml
---
(0087757)
hgbot   
2016-06-21 18:20   
Repository: erp/pmods/org.openbravo.retail.loyalty
Changeset: 3976b1abcb04bc1c05b7facfa595ba61beb50307
Author: Shivanand Madiwalar <shivanand.madiwalar <at> promantia.com>
Date: Tue Jun 21 21:50:20 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/3976b1abcb04bc1c05b7facfa595ba61beb50307 [^]

Fixes Issue 32965 : Definition Of Constarints Changed To Match Compatibility .

---
M src-db/database/model/tables/OBLOY_CANCELREDEMPTION.xml
---
(0087783)
hgbot   
2016-06-22 10:31   
Repository: erp/pmods/org.openbravo.retail.loyalty
Changeset: 4b87a0e1698061d0b969f032269cf074f849c4c6
Author: Shivanand Madiwalar <shivanand.madiwalar <at> promantia.com>
Date: Wed Jun 22 14:01:18 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/4b87a0e1698061d0b969f032269cf074f849c4c6 [^]

Fixes Issue 32965 : Definition Of Constarints Changed To Match Compatibility .

---
M src-db/database/model/tables/OBLOY_CANCELREDEMPTION.xml
---