HPE NonStop SQL/MX Error – 20121 Partition is not the last in a table that is not key-sequenced. PURGEDATA cannot be performed.

In this blog post, let’s learn about the error message “20121 Partition is not the last in a table that is not key-sequenced. PURGEDATA cannot be performed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20121 Partition is not the last in a table that is not key-sequenced. PURGEDATA cannot be performed.

Reason for the Error

The table being purged has multiple partitions and is not key-sequenced. This type of table is not supported.

Solution

None. This is an internal error. Contact your service provider