In this blog post, let’s learn about the error message “1252 The existing index index-name to be used by a unique or primary constraint has not been populated. Please populate the index and then try to add the constraint again.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1252 The existing index index-name to be used by a unique or primary constraint has not been populated. Please populate the index and then try to add the constraint again.
Reason for the Error
An existing index that is not populated has been chosen for a unique or primary constraint, which is not allowed.
Solution
Populate the index and resubmit
