In this blog post, let’s learn about the error message “20197 The specified index index-name is not available.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20197 The specified index index-name is not available.
Reason for the Error
The index name specified by the caller is not valid. The caller qualifying the index name with a catalog or schema is the probable cause. Catalog and schema names are not supported.
Solution
Specify a valid name, and resubmit