JDE Table Trigger (or TER) on F0006

sheeba

Reputable Poster
Hello all,

We have JDE Table Trigger (Table event rules) on F0006 ; for it to send an email when a new business unit is added.

The debug log indicates the email was sent to the correct email id. But I am not receiving any emails. It worked till end of Sept but can't figure out what would have changed for it to stop working.

I also did notice this error below in the debug log ; Is there a Real time event setting on ini that is needed for a table trigger on F0006 to work - Please let me know if you have seen any such behavior before.

**********************************************************************************
Dec 06 14:29:13.047003 - 4284/4996 WRK:Starting jdeCallObject *** Start dumping data structure for business function BusinessUnitRealTimeEventNotify
Dec 06 14:29:13.047004 - 4284/4996 WRK:Starting jdeCallObject **********************************************************************************
Dec 06 14:29:13.047005 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 1] <Item>: cEventAction <type>: CHAR <Value>: [1]
Dec 06 14:29:13.047006 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 2] <Item>: szCostCenter <type>: STRING <Value>: [ 100033]
Dec 06 14:29:13.047007 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 3] <Item>: cErrorAPIEventReturn <type>: CHAR <Value>: [1]
Dec 06 14:29:13.047008 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 4] <Item>: cErrorStatus <type>: CHAR <Value>: [2]
Dec 06 14:29:13.047009 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 5] <Item>: cErrorID <type>: CHAR <Value>: [ ]
Dec 06 14:29:13.047010 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 6] <Item>: szEventName <type>: STRING <Value>: [RTBUOUT]
Dec 06 14:29:13.047011 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 7] <Item>: szEventScope <type>: STRING <Value>: [0]
Dec 06 14:29:13.047012 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 8] <Item>: szCallingFunction <type>: STRING <Value>: [P0006]
Dec 06 14:29:13.047013 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 9] <Item>: cFutureUseFlag <type>: CHAR <Value>: [ ]
Dec 06 14:29:13.047014 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 10] <Item>: nFutureUseInteger <type>: INT <Value>: [0]
Dec 06 14:29:13.047015 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 11] <Item>: mnFutureUseMathNumeric <type>: MATH_NUMERIC <Value>: [0]
Dec 06 14:29:13.047016 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 12] <Item>: szFutureUseString <type>: STRING <Value>: [ ]
Dec 06 14:29:13.047017 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 13] <Item>: cIsAnInventoryBranchPlant <type>: CHAR <Value>: [ ]
Dec 06 14:29:13.047018 - 4284/4996 WRK:Starting jdeCallObject OUT->[ 14] <Item>: szLanguagePreference <type>: STRING <Value>: [ ]
Dec 06 14:29:13.047019 - 4284/4996 WRK:Starting jdeCallObject **********************************************************************************
Dec 06 14:29:13.047020 - 4284/4996 WRK:Starting jdeCallObject *** End dumping data structure for business function BusinessUnitRealTimeEventNotify
Dec 06 14:29:13.047021 - 4284/4996 WRK:Starting jdeCallObject **********************************************************************************
Dec 06 14:29:13.047022 - 4284/4996 WRK:Starting jdeCallObject Entering jdeCloseDictionary
Dec 06 14:29:13.047023 - 4284/4996 WRK:Starting jdeCallObject Exited jdeCloseDictionary with DDType 0
Dec 06 14:29:13.047024 - 4284/4996 WRK:Starting jdeCallObject Return value is 2 for BusinessUnitRealTimeEventNotify. (BSFNLevel = 1)
Dec 06 14:29:13.047025 - 4284/4996 WRK:Starting jdeCallObject
 
Check to see that your SMTP Mail server still accepts mail from your JDE server(s) - in other words talk to your Exchange/Notes/? administrator.
 
Yes it does - I ran an R0006P and sent an email to be with job completed successfully ; Also we have all other emails coming in from JDE except this one where the email functionality is attached to a table trigger F0006 (TER) ;

Althou the log shows email is sent it errors on the bsfn BusinessUnitRealTimeEventNotify --- Do you know if it needs a INI setup anywhere for JDE Table Triggers to work?

It was working for us uptill Sept 2013 and not sure what changed on the INI . I even build the trigger and ran it again - no success.

Any help with this will be appreciated
 
I changed the from email addr and it worked fine. Not sure why or how the system stopped liking the old from email id - which was working for the longest time. hmmm
 
Spam and intrusion prevention filters in many cases require a valid email address - in your case a valid internal email address.
 
Back
Top