HPE NonStop SQL/MX Error – 1006 Index index-name does not exist.

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