HPE NonStop SQL/MX Error – 1403 The use of CREATE INDEX on metadata tables is not permitted.

In this blog post, let’s learn about the error message “1403 The use of CREATE INDEX on metadata tables 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

1403 The use of CREATE INDEX on metadata tables is not permitted.

Reason for the Error

You used the CREATE INDEX statement and attempted to create an index on a SQL/MX metadata table.

Solution

Use CREATE INDEX with user tables only