In this blog post, let’s learn about the error message “20724 Audit fixup process process name found a violation of the uniqueness constraint while populating a unique index.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20724 Audit fixup process process name found a violation of the uniqueness constraint while populating a unique index.
Reason for the Error
A record with a duplicate key from the audit trail was found while populating the index.
Solution
Recover the index file, remove conflicting records from base table and retry