Simple Table Trigger Not Working - Why ??

I am putting a simple OW trigger on F41021 and it just refuse to work. Can some one pl. comment as to what could be the problem.
Following are the details :-
File - F41021
I am adding trigger Before record is added and Before record is updated. The trigger is a simple IF statement:-
IF LILOCN = "INSP" then LILOTS = "H"
- I had build the triggers succesfully
- I logged out and logged back in
- I checked the F41021.C program and it shows the trigger logic
- I am using a small UBE running locally to update a field(LIUSER) in F41021 so that the trigger is activated

Anything am I missing ??
Pl. advise
jdeman
OW XE SP-22 Update 7, ES-AS400

There can be more than one reason that caused this but I will start up with the full debug log and the job log to see any helpful messages.

1) Are you performing table updating within the table trigger ER or simply move the data to the db field to be updated?

2) Are you validating and updating the right variables?

3) Have you tried to comment out the If statement and just go ahead update the field to narrow down the problem?

4) Is your UBE trying to update F41021 while the table trigger is trying to update the table itself? Incursive update is not supported based on my past experience.

Can you copy and paste your trigger codes here as well as the UBE event rule so I can take a look at it?

I have a couple of questions for you.

1) What is the value "Default Pathcode=" set to in your jde.ini?

2) What Environment/Pathcode are you using to test the trigger?

I have seen some bizarre behavior with OneWorld triggers. In the past I have seen OneWorld look for triggers based on the Default Pathcode parameter in the jde.ini. I'm not sure if this is your problem, but it may be worth looking at.

I=92ve juste a little question. Do you have try to suppress global table
before relogging to oneworld ?

Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 63
GSM : 06 92 26 41 56
E-mail : [email protected]

_____=20

De : [email protected] [mailto:[email protected]] De la
part de paul_ross
Envoy=E9 : vendredi 3 septembre 2004 17:35
=C0 : [email protected]
Objet : Re: Simple Table Trigger Not Working - Why ??



I have a couple of questions for you.

1) What is the value "Default Pathcode=3D" set to in your jde.ini?

2) What Environment/Pathcode are you using to test the trigger?

I have seen some bizarre behavior with OneWorld triggers. In the past I have
seen OneWorld look for triggers based on the Default Pathcode parameter in
the jde.ini. I'm not sure if this is your problem, but it may be worth
looking at.

Paul Ross Independent CNC/Developer Consultant Phone: 513-276-0969 E-mail:
HYPERLINK "mailto[email protected]"[email protected]

_____=20


The HYPERLINK "http://www.jdelist.com/ubb/showflat.php?Cat=3D&Board=3D"enti re
JDELIST thread is available for viewing.


This is the JDELIST EnterpriseOne Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available HYPERLINK "http://www.jdelist.com/unsubscr.shtml"here.
JDELIST is not affiliated with JDEdwards=AE.

I confirmed the Path Code and Env setting in the jde.ini and look fine
I removed the IF condition and just put a simple assignment still did not work
I confirmed the variables are right
I tried to update a different field in the Trigger still same problem.
IS there any way to debug Trigger code ??

Following is the only code in the "Before Record is Updated Event"
TK LotStatusCode = "H"
TK UserReservedReference = "NP"


Following is the only Update statement in jdedebuglog. Clearly it does not show any trigger related changes on the table

UPDATE C0058CRPD/F41021
SET LIITM=2026.000000,LIMCU=' FLOR',LILOCN='INSP',LILOTN=SPACE,
LIUSER='HHH',
LITDAY=93731.000000
WHERE ( LIITM = 2026.000000 AND LIMCU = ' FLOR' AND
LILOCN = 'INSP' AND LILOTN = SPACE )

This thing is driving me crazy

jdeman

It is not working for me either.

I would suggest you to open a case at PS GSC. May be there is something we do not know about or it is simply not working!!!

Please keep us update when you find out something from PS GSC.

It's not working for me on any tables not just F41021. This should not be a general problem. Will check though with PSFT

Any one having problem...should not ....since there are tons of Triggers on JDE files all over.

Are you seeing any messages in QSYSOPR message queue when the trigger program is executed? Any joblogs?

Friends,
I tested and found any OW trigger on F41021 does not work. I called up PSFT but they are as usual of no help mentioning it should work.

I have a request for you guys, can you pl. check you are able to update ANY field through trigger on F41021. I want to absolutely make sure that this is not general but specific to issue to me. I tried triggers on other (custom tables) and it work. It's just this F41021 that does not work.

Thanks
jdeman