Re: Triggers not always executing.

[Evan Harris <spanner@xxxxxxxxxx>]

Hi Gerald

it seems from this and some of the other replies that the major problem is 
being able to recreate the error in order to understand it. If the file is 
journalled cany you recreate the error scenario by applying the journal 
entries to a copy of the file file in another environment  ?

Regards
Evan Harris

> Does anyone know of any type of DB commands/utilities that could be used
> to diagnose trigger processing?
>
> I have a situation where record updates should trigger a program to
> execute but for some reason the trigger doesn't always execute. Almost all
> of the time (99.9%) of the time the trigger appears to work.
>
> I wrote the trigger program, and included code in it to log triggered
> update requests to a logfile. Other than logging the trigger requests, is
> there anything else I can do to monitor the triggers?
>
> Regards,
>
> Gerald Kern