trigger problems in some tables

[rcandeo]

I have a problem using Triggers. Some tables does not works the trigger in DELETE option.

The problem is when the system execute the AfterDelete on JDE trigger. When we use the buffer, the fields are null. An example is short item number field in F4101. We need to get this field (shortitem) to write in a table to generate a TXT with this DELETE. The problem is when we delete an item using P4101 application.

We did a sample application to delete records in F4101 and it is works fine,

There are another tables that it happens, like F0911, F7601B, F7611B.
In some tables,works normally, like F0101 when we delete records by P01012 application.

When we use the delete.<table> comand, the buffer is cleaned in beforedelete e afterdelete. If we use the delete button on an aplication the error doesn't occur.

Comparing the log of the delete command and the delete button click, the difference is that in the delete command the fields have no values:

The log from the Delete Command

Jun 16 09:40:49.638 - 3952/3224 DELETE FROM TESTDTA/F3003Z1 WHERE ( SZEDUS = 'TESTE2' AND SZEDBT = '4765744' AND SZEDTN = 'TESTE2' AND SZEDLN = 20000.000000 )
Jun 16 09:40:49.638 - 3952/3224 Entering DBPerformRequest
Jun 16 09:40:49.638 - 3952/3224 ODBC:I DBPerformRequest req=10564600 con=0702E3C0 env=02B812A0 dbc=02B850A8 BRALUX05 A (JDEOW@Business Data - TEST)
Jun 16 09:40:49.638 - 3952/3224 Exiting DBPerformRequest
Jun 16 09:40:49.638 - 3952/3224 COB00001: jdeCallObject called to launch ECTGenerationF3003Z1.
Jun 16 09:40:49.638 - 3952/3224 Entering FindObjectCache
Jun 16 09:40:49.638 - 3952/3224 Entering JDB_AuditingOn
Jun 16 09:40:49.638 - 3952/3224 Exiting JDB_AuditingOn with success
Jun 16 09:40:49.638 - 3952/3224 Calling Business function ECTGenerationF3003Z1 for 71056165. Application Name [], Version [] (BSFNLevel = 4)
Jun 16 09:40:49.638 - 3952/3224 **********************************************************************************
Jun 16 09:40:49.638 - 3952/3224 *** Start dumping data structure for business function ECTGenerationF3003Z1
Jun 16 09:40:49.638 - 3952/3224 **********************************************************************************
Jun 16 09:40:49.638 - 3952/3224 IN->[ 1] <Item>: szTableName <type>: STRING <Value>: [F3003Z1]
Jun 16 09:40:49.638 - 3952/3224 IN->[ 2] <Item>: cActionFlag <type>: CHAR <Value>: [D]
Jun 16 09:40:49.638 - 3952/3224 IN->[ 3] <Item>: szProgramId <type>: STRING <Value>: []
Jun 16 09:40:49.638 - 3952/3224 IN->[ 4] <Item>: szEdiUserId <type>: STRING <Value>: []
Jun 16 09:40:49.638 - 3952/3224 IN->[ 5] <Item>: szEdiBatchNumber <type>: STRING <Value>: []
Jun 16 09:40:49.638 - 3952/3224 IN->[ 6] <Item>: szEdiTransactNumber <type>: STRING <Value>: []
Jun 16 09:40:49.638 - 3952/3224 IN->[ 7] <Item>: mnEdiLineNumber <type>: MATH_NUMERIC <Value>: [0]
Jun 16 09:40:49.638 - 3952/3224 **********************************************************************************
Jun 16 09:40:49.638 - 3952/3224 *** End dumping data structure for business function ECTGenerationF3003Z1
Jun 16 09:40:49.638 - 3952/3224 **********************************************************************************

The log from the button click

Jun 16 09:40:14.931 - 3952/3224 DELETE FROM TESTDTA/F3003Z1 WHERE ( SZEDUS = 'TESTE1' AND SZEDBT = '4765743' AND SZEDTN = 'TESTE1' AND SZEDLN = 10000.000000 )
Jun 16 09:40:14.931 - 3952/3224 Entering DBPerformRequest
Jun 16 09:40:14.931 - 3952/3224 ODBC:I DBPerformRequest req=105FE4C8 con=0702E3C0 env=02B812A0 dbc=02B850A8 BRALUX05 A (JDEOW@Business Data - TEST)
Jun 16 09:40:14.931 - 3952/3224 Exiting DBPerformRequest
Jun 16 09:40:14.931 - 3952/3224 COB00001: jdeCallObject called to launch ECTGenerationF3003Z1.
Jun 16 09:40:14.931 - 3952/3224 Entering FindObjectCache
Jun 16 09:40:14.931 - 3952/3224 Entering JDB_AuditingOn
Jun 16 09:40:14.931 - 3952/3224 Exiting JDB_AuditingOn with success
Jun 16 09:40:14.931 - 3952/3224 Calling Business function ECTGenerationF3003Z1 for 71056165. Application Name [], Version [] (BSFNLevel = 4)
Jun 16 09:40:14.931 - 3952/3224 **********************************************************************************
Jun 16 09:40:14.931 - 3952/3224 *** Start dumping data structure for business function ECTGenerationF3003Z1
Jun 16 09:40:14.931 - 3952/3224 **********************************************************************************
Jun 16 09:40:14.931 - 3952/3224 IN->[ 1] <Item>: szTableName <type>: STRING <Value>: [F3003Z1]
Jun 16 09:40:14.931 - 3952/3224 IN->[ 2] <Item>: cActionFlag <type>: CHAR <Value>: [D]
Jun 16 09:40:14.931 - 3952/3224 IN->[ 3] <Item>: szProgramId <type>: STRING <Value>: []
Jun 16 09:40:14.931 - 3952/3224 IN->[ 4] <Item>: szEdiUserId <type>: STRING <Value>: [TESTE1]
Jun 16 09:40:14.931 - 3952/3224 IN->[ 5] <Item>: szEdiBatchNumber <type>: STRING <Value>: [4765743]
Jun 16 09:40:14.931 - 3952/3224 IN->[ 6] <Item>: szEdiTransactNumber <type>: STRING <Value>: [TESTE1]
Jun 16 09:40:14.931 - 3952/3224 IN->[ 7] <Item>: mnEdiLineNumber <type>: MATH_NUMERIC <Value>: [10,000]
Jun 16 09:40:14.931 - 3952/3224 **********************************************************************************
Jun 16 09:40:14.931 - 3952/3224 *** End dumping data structure for business function ECTGenerationF3003Z1
Jun 16 09:40:14.931 - 3952/3224 **