Cannot insert duplicate key row in object 'HEATXFld' with unique index 'HEATXFld0'.

Version 1

    Details

    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'.


    Resolution

    Cause
    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.


    Resolution
    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.