Clone failure due to duplicate IDP record on target instance saml2_update1_properties table. - Support and Troubleshooting

Clone failure due to duplicate IDP record on target instance saml2_update1_properties table. Issue Description

If there are any duplicate values on the saml2_update1_properties table for the IDP column on the target instance, the clone activity which checks the uniqueness of the IDP will fail and the clone will be intervened.

Example of the clone error messages on the change request:

"failure at 'areThereIDPDuplicatesInTargetInstance' activity: IDP colmun in source table saml2_update1_properties is unique and the IDP: http://adfs1.winplc.com/adfs/services/trust has duplicate records in the target instance", INT3879979 is created for this failure.

Note: For further information, please check the automated incident created for this failure.

Workaround

To resolve this issue, you have 2 options:

Remove the duplicate IDP records from the saml2_update1_properties table on the target instance.

OR

Use a unique IDP (Identity Provider URL) for each of the records on the target’s instance saml2_update1_properties table.

After completing the steps to ensure the uniqueness of the IDP, the Instance Automation team can approve the intervene so the clone can continue or a new clone will need to be requested.