It would be helpful, if the error message that appears when you try to save a duplicate value into a table with a unique index could use lookups for the duplicate value Ids. Modify the index field so that it enables the selection of lookup.
Implementation note: TransactionId must be used when looking up the values in order to prevent deadlocks.