Trying to commit an Edit Set after selecting the File>> Update External Fields option on 2 External Profiles. During the commit the following error is received:
Cannot insert duplicate key row in object 'HEATXFld' with unique index 'HEATXFld0'.
The HEATXFld0 index is a compound primary key between the TableName/TableType/FLDName fields. There cannot be a duplicate instance between these combinations of Fields.
External Profiles that were being updated were pointing to views that also had fields named CustType and CustID.
1. Altered the views to select the fields with alias names (CustID AS HATCustID, CustType AS HATCustType.
2. Rebuilt the external Profiles and Subsets and re-committed the Edit Set without errors.