HPE NonStop SQL/MX Error – 1121 Partitions cannot be added or dropped on table table-name. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY.

In this blog post, let’s learn about the error message “1121 Partitions cannot be added or dropped on table table-name. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1121 Partitions cannot be added or dropped on table table-name. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY.

Reason for the Error

You attempted to do an invalid ADD, DROP, or MODIFY of a partition.

Solution

None