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

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, let’s learn about the error message “1104 Default value string is too long for column column-name.”...
  • Data
  • December 3, 2024
In this blog post, let’s learn about the error message “3165 The precision or exponent value specified in value was...
  • Data
  • December 3, 2024
In this blog post, let’s learn about the error message “2051 Either control optionoption name or value ‘value’is not valid.”...
  • Data
  • December 3, 2024