In this blog post, let’s learn about the error message “11029 Attempt to change the value of column column-name of a given row more than once in the same statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11029 Attempt to change the value of column column-name of a given row more than once in the same statement.
Reason for the Error
You attempted to change a column of a particular row from a particular table to two different values at two different instances. You have designed a set of triggers that can result in nondeterministic behavior.
Solution
None. Redesign the triggers in such a way that this condition is not raised. This usually involves following the cascading of triggers and identifying when the column is being modified more than once. From error 11028, which was raised along with this error, you can identify the trigger that made the second change to the same column of a given row
