No errors or failures are given to indicate data preserver import errors when a column is not unique in the target instance and has duplicate values. One common example of this is the IDP (Identity Provider URL) column on the saml2_update1_properties table.
Steps to Reproduce
- Set the Unique flag of the IDP (Identity Provider URL) column in saml2_update1_properties to false
- Create records on the sso_properties table with duplicate values in the IDP field
- Clone over this instance from another instance
- One of the duplicate records will become corrupt
In order to prevent serious issues after cloning when duplicate values exist, the clone engine will stop execution when duplicate values are detected. Support will then be tasked to intervene via an automatically-generated incident. The solution is to remove or update the records so that there are no longer duplicate values. For example, in the case of the IDP (Identity Provider URL) column on saml2_update1_properties table, the duplicate IDP (Identity Provider URL) value must be changed to another unique value, or the duplicate record must be removed completely.
Related Problem: PRB1183030