HPE NonStop SQL/MX Error – 4061 Rows cannot be inserted into, or updated in, an individual table partition.

In this blog post, let’s learn about the error message “4061 Rows cannot be inserted into, or updated in, an individual table partition.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4061 Rows cannot be inserted into, or updated in, an individual table partition.

Reason for the Error

You attempted to insert or update rows in an individual table partition, which is not supported.

Solution

Correct the syntax and resubmit