HPE NonStop SQL/MX Error – 4177 Update of name1 column name2 is not permitted on rollback.

In this blog post, let’s learn about the error message “4177 Update of name1 column name2 is not permitted on rollback.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4177 Update of name1 column name2 is not permitted on rollback.

Reason for the Error

You attempted to update clustering key components or columns associated with referential integrity constraints during a rollback.

Solution

Modify the statement and resubmit