I added a physical file trigger for *after and *insert. When I do an insert, the trigger does not call my program and I get a CPF502B message.

                                                                              Message ID . . . . . . :   DFU0843       Severity . . . . . . . :   40        Message type . . . . . :   Diagnostic                                         Date sent  . . . . . . :   11/16/10      Time sent  . . . . . . :   17:57:54                                                                                Message . . . . :   EXIT DFU and SIGNOFF IMMEDIATELY. To allow data base roll   back of data. CPF502B caused the problem.                                   Cause . . . . . :   A Referential Constraint Violation of Trigger program       failure occurred during a PUT by DFU to the data base. Data changes will be   rolled back once SIGNOFF from the current job is done.  DO NOT CONTINUE to    enter or change data as it will be rolled back as well once you signoff.    Recovery  . . . :   EXIT DFU and SIGNOFF IMMEDIATELY. To allow Data Base to     roll back the change to the file that resulted in the error. DO NOT CONTINUE   to make changes to the file until you have SIGNED OFF or all these changes    will be rolled back as well. Use DSPMSGD to get details about the message     listed. Then, correct the error and try again.                              Technical description . . . . . . . . :   DFU was performing a data-base     

This also happens in RPG and with SQL



Software/Hardware used:
AS400