Project:
| View Revisions: Issue #32965 | [ Back to Issue ] | ||
| Summary | 0032965: Module is not installable at all on oracle | ||
| Revision | 2016-05-17 19:42 by marvintm | ||
| 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')) |
||
| Revision | 2016-05-17 19:41 by marvintm | ||
| 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"> 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')) 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_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')) |
||
| Revision | 2016-05-17 19:40 by marvintm | ||
| 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"> |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |