I have a table that has a trigger to capture old and new details for every field in the table every time an application user makes an update. A SP is then executed to capture details (user ID, session ID, old and new values, etc) and send an alert email to anyone who may need to know of any changes. The trigger/SP works most of the time. Occasionally a user tries to update a field in the table (via application) and encounters an error and cannot complete the update. When I try to update the field manually I get an sql error 127. I then need to disable the trigger, make the update, then reenable the trigger. The same update to the table by a user (different values for the fields, but generally the same update) can work multiple times but only occasionally fails. What should I be looking for in terms of cause? This is on Infx V12.10.FC10, but the trigger was written when it was on V11, not sure if that make a difference.
Only way I can seem to circumvent the issue is to disable the trigger, make the udpate manually, then reenable the trigger.