HPE NonStop SQL/MX Error – 1404 The use of ALTER INDEX on metadata indexes is not permitted.

In this blog post, let’s learn about the error message “1404 The use of ALTER INDEX on metadata indexes is not permitted.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1404 The use of ALTER INDEX on metadata indexes is not permitted.

Reason for the Error

You used the ALTER INDEX statement and attempted to alter a SQL/MX metadata index.

Solution

Use ALTER INDEX with user indexes only