In this blog post, let’s learn about the error message “1006 Index index-name does not exist.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1006 Index index-name does not exist.
Reason for the Error
The operation you attempted requires the existence of an index named index-name.
Solution
Check that an index named index-name exists. If you did not fully qualify the name, check that the defaults generate the correct qualified name