RE: Trigger error

Hi,
Is it possible to get the Object Caller (or program) that originated the
updating of the file to retireved it in the program that control the trigger.

Regards,
Cesar A.

Ok, this is what happened.  A programmer has ran ADDPFTRG on the database
in question.  In their program they used the api to send an escape
message.  The id of the escape message they sent was CPF9898 which is one
of two or three generic id's that IBM has in QCPFMSG.  The text they
supplied on the message was rather crude 'Trigger error.'  Knee them in
the groin.
You should be able to do a DSPFD FILE(...) TYPE(*TRG) on that file to look
for the trigger information.  Then you can delve into that code and see
what conditions would generate that error.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

"Willie J. Moore" <WJMoore@xxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
11/25/2003 02:06 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>

To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: Trigger error

I did display the job log.  Here is what it shows:
Error found on CALL command.
Trigger error.
Function check. CPF9898 unmonitored by OPNAR at statement  .DRVRU01,
instruction X'00FD'
Willie..

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Tuesday, November 25, 2003 10:22 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Trigger error

Display the joblog.  The trigger program probably sent an escape message
to it.

Keep us posted...

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

"Willie J. Moore" <WJMoore@xxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/25/2003 01:00 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>

To
<rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Trigger error

I am trying to update the Customer PO field in the OPENAR file with
Customer PO data from another file.  When I try this, I get the following
message: RPG9998 Internal failure in compiler or subroutine.  I took the
'D' option and looked at the dump.  Under 'Message Data' is showed
'Trigger error'.
I am hopping someone can give me ideals on how to correct this.
Thanks in advance,
William Moore

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.