E-AUT-003-004 Trigger \%0s\: recursive raise detected. Aborting execution

Explanation

The following example shows how this message is written to the log:
2012-04-13T21:12:28: Error: E-AUT-003-004:
 Trigger "test_correlation": recursive raise 
 detected. Aborting execution

This error indicates that the affected trigger is performing an action that might lead to the trigger being executed recursively, thereby degrading ObjectServer performance. When the ObjectServer detects that it is recursively invoking a trigger, it prevents execution of the trigger and returns this error message.

In the example message, a custom database trigger, test_correlation, fires on an update to the alerts.status table. However, the trigger itself performs an update to alerts.status, thus starting a recursive loop.

System action

Not applicable.

User response

Not applicable.

Administrator response

The response to this error will depend on your system configuration. The solution to the problem in the example is to either alter the trigger to prevent recursion, or to use a temporal trigger instead of a database trigger.