>>>>Very simple. Add for now updating one of the fields that doesn't allow NULL with NULL.
>>>
>>>Thank you for your help. This makes sense.
>>
>>Ok, what are your findings?
>
>It looks like the error in the trigger rolls back changes done to other tables.
Ok, great, exactly as I was thinking.
If it's not broken, fix it until it is.
My Blog 
