In this blog post, let’s learn about the error message “20196 The specified index index-name contains user data.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20196 The specified index index-name contains user data.
Reason for the Error
The index name specified by the caller should not contain data. Data was found to exist, most likely because a previous POPULATE INDEX command failed.
Solution
Execute the RECOVER command to clean up the previously failed command and resubmit