HPE NonStop SQL/MX Error – 20339 Indexes index-list on table table did not populate successfully.

In this blog post, let’s learn about the error message “20339 Indexes index-list on table table did not populate successfully.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20339 Indexes index-list on table table did not populate successfully.

Reason for the Error

One of more indexes did not populate correctly, probably because of uniqueness violations when loading unique indexes.

Solution

For unique indexes, remove conflicting records from the base table and retry the populate operation. For non-unique indexes, do not attempt recovery