0042265: Config Script problems on SQL Constraint

Description

I have a module with type "Industry Template".
I need the following change:

from:
<unique name="OBMUPC_P_MULTIUPC_CLIENT_UPC">
<unique-column name="AD_CLIENT_ID"/>
<unique-column name="UPC"/>
</unique>
to:
<unique name="OBMUPC_P_MULTIUPC_CLIENT_UPC">
<unique-column name="AD_ORG_ID"/>
<unique-column name="UPC"/>
</unique>

During the export.config.script command I got the following error:

Changes that couldn't be exported to the config script:
*******************************************************
RemoveUniqueChange. Name: OBMUPC_P_MULTIUPC_CLIENT_UPC
AddUniqueChange. Name: OBMUPC_P_MULTIUPC_CLIENT_UPC

Steps To Reproduce

1) Create a Module with type Industry Template
2) Launch scripts :
ALTER TABLE obmupc_prod_multiupc DROP CONSTRAINT obmupc_p_multiupc_client_upc;
ALTER TABLE obmupc_prod_multiupc
ADD CONSTRAINT obmupc_p_multiupc_client_upc UNIQUE(ad_org_id, upc);
3) Run script task "ant export.config.script"

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2019-11-13 11:07	nicola_uva	New Issue
2019-11-13 11:07	nicola_uva	Assigned To	=> platform
2019-11-13 11:07	nicola_uva	OBNetwork customer	=> No
2019-11-13 11:07	nicola_uva	Web browser	=> Google Chrome
2019-11-13 11:07	nicola_uva	Modules	=> Core
2019-11-13 11:07	nicola_uva	Triggers an Emergency Pack	=> No
2019-11-13 11:09	guillermogil	OBNetwork customer	No => Gold
2019-11-13 11:09	guillermogil	Web browser	Google Chrome => Google Chrome
2019-11-13 11:09	guillermogil	Severity	major => minor
2020-03-23 12:26	martinsdan	Issue Monitored: martinsdan
2022-02-01 08:07	alostale	Assigned To	platform => Triage Platform Base