HPE NonStop SQL/MX Error – 20262 Online operation is not supported on unpopulated indexes.

In this blog post, let’s learn about the error message “20262 Online operation is not supported on unpopulated indexes.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20262 Online operation is not supported on unpopulated indexes.

Reason for the Error

You attempted a MODIFY operation WITH SHARED ACCESS on an unpopulated index.

Solution

Populate the index using the POPULATE INDEX command and then retry the operation