Where do trigger failures get logged

[Paul Hammond]

I have triggers that are failing periodically. Where can I track down why they're failing I do not see logging options for the trigger itself.

[Motsu Aboshi]

Triggers have no logging options per se - unless you specifically use the log functions available to you in a custom function trigger. The other option here would be to enable trigger debugging in the log4j.properties file (search for trigger). This may or may not provide useful information for the failures in question.

Barring any manual logging design for your trigger, you should treat this like any other failure:

- check the events log for the start/end time (look for a trigger event with the same trigger name)

- correlate to timestamped errors in the server log: you may see mention of a trigger worker, but it's also possible, depending on the error, for it to look like any other failure