Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0032965 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Loyalty Management for Retail | major | have not tried | 2016-05-16 14:03 | 2016-06-23 19:40 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shivum039 | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 4b87a0e16980 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | marvintm | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0032965: Module is not installable at all on oracle | |||||||
| Description | This 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 Reproduce | Try to install it on oracle. | |||||||
| Proposed Solution | Rename the 2nd constraint according to naming rules | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
Notes |
|
|
(0086509) shuehner (administrator) 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 (developer) 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 (developer) 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 (developer) 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 (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-05-16 14:03 | shuehner | New Issue | |
| 2016-05-16 14:03 | shuehner | Assigned To | => Retail |
| 2016-05-16 14:03 | shuehner | Triggers an Emergency Pack | => No |
| 2016-05-16 14:06 | shuehner | Relationship added | related to 0032966 |
| 2016-05-17 19:40 | shuehner | Note Added: 0086509 | |
| 2016-05-17 19:41 | marvintm | Description Updated | View Revisions |
| 2016-05-17 19:42 | marvintm | Description Updated | View Revisions |
| 2016-06-21 11:04 | marvintm | Status | new => scheduled |
| 2016-06-21 11:04 | marvintm | Assigned To | Retail => shivum039 |
| 2016-06-21 16:49 | hgbot | Checkin | |
| 2016-06-21 16:49 | hgbot | Note Added: 0087744 | |
| 2016-06-21 16:49 | hgbot | Status | scheduled => resolved |
| 2016-06-21 16:49 | hgbot | Resolution | open => fixed |
| 2016-06-21 16:49 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.loyalty/rev/14325804afdf6a9446b88c7a1e2d80da8b5ba210 [^] |
| 2016-06-21 17:43 | hgbot | Checkin | |
| 2016-06-21 17:43 | hgbot | Note Added: 0087750 | |
| 2016-06-21 17:43 | hgbot | Fixed in SCM revision | http://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:20 | hgbot | Checkin | |
| 2016-06-21 18:20 | hgbot | Note Added: 0087757 | |
| 2016-06-21 18:20 | hgbot | Fixed in SCM revision | http://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:31 | hgbot | Checkin | |
| 2016-06-22 10:31 | hgbot | Note Added: 0087783 | |
| 2016-06-22 10:31 | hgbot | Fixed in SCM revision | http://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:40 | marvintm | Review Assigned To | => marvintm |
| 2016-06-23 19:40 | marvintm | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |