HPE NonStop SQL/MX Error – 4178 Update of variable length column name is not permitted on rollback.

In this blog post, let’s learn about the error message “4178 Update of variable length column name 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

4178 Update of variable length column name is not permitted on rollback.

Reason for the Error

You attempted to perform a rollback that included an update of a variable length column.

Solution

Modify the statement and resubmit