|
Michael, I am confused. Why does the same program work on any green screen function. Qry,Dfu,G/L audit, G/L account edit. We even downloaded the GELMAS file to our PC FRx package. They all work fine. So I don't see how it can be a recursive call. AM+ is a read only which is what my trigger is set for. And I don't do anything else to the Gelmas file in my program. Pete ----- Original Message ----- From: <michael.franchino@xxxxxxxxxx> To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx> Sent: Wednesday, June 18, 2003 6:26 PM Subject: Re: Trigger pgm - SQL errors > That's an easy one - that message is issued for a recursive trigger call. > In other words the trigger program modifies the file that caused the > trigger to fire which causes the trigger to fire again... and again... and > again. > > Michael Franchino > Custom Systems Corporation > http://www.cussys.com > (973) 726-0202 X214 (Phone) > (973) 726-4552 (Fax) > > > > > Ron Hankey <Ron.Hankey@xxxxxxxxxxx> > Sent by: mapics-l-bounces@xxxxxxxxxxxx > 06/18/2003 11:53 AM > Please respond to MAPICS ERP System Discussion > > > To: mapics-l@xxxxxxxxxxxx > cc: > Subject: Re: Trigger pgm - SQL errors > > > Is it possible for your trigger to submit a job to batch OR send the entry > > to a data queue to perform the update of the log file? > We use this method quite often to prevent possible trigger failures from > hanging a job. > > Is it possible your trigger is performing some operation to the GELMAS > file causing it to fire the trigger again? > (From the message it sounds like this is a possibility.) > Are there other triggers on GELMAS other than the one you added? > > Is the GELMAS file journaled for both before/after images? > Does AM+ use commitment control? > > Since the error only occurs when AM+ is used it's method of accessing the > file is causing your trigger or another trigger to be invoked multiple > times until it reaches the 200 invocation limit. > > Some good tips for SQL can be found at: http://www.as400pro.com/tips.htm > > Pete wrote: > >Basically the joblog pointed to error message CPF523D Too many triggers > called. Max 200. > <SNIP> > >Is there a way to tailor SQL to slow down without affecting the other > browser apps' or any other tricks not to get >the trigger pgm to fire????? > <SNIP> > > Ron Hankey - CPIM > Applications Programmer > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > > > > _______________________________________________ > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list > To post a message email: MAPICS-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/mapics-l. > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.