SQL statements not logged in server jdedebug.log

jwright712

Member
All:
When I turn on debug logging on the enterprise server using the Server Admin Workbench, there is no SQL logging to be found anywhere in the log--but I would like there to be. I do see all the JDEBASE APIs being called that should be generating such entries in the log (e.g. JDB_SelectKeyed, JDB_DeleteTable, etc.) but the SQL statements do not appear.

For example, here is a snippet from the server's debug log:
Jun 19 12:50:17 ** 2456/2452 Entering JDB_OpenTable( Table = F0101)
Jun 19 12:50:17 ** 2456/2452 Entering JDB_FetchKeyed
Jun 19 12:50:17 ** 2456/2452 Entering JDB_CloseTable(Table = F0101)

If I run the same BSFN from a client, I get the following (which DOES have the SQL statement logged):
Jun 23 18:50:39 ** 644/812 Entering JDB_OpenTable( Table = F0101)
Jun 23 18:51:39 ** 644/812 Entering JDB_FetchKeyed
Jun 23 18:51:39 ** 644/812 ODBC:S DBInitRequest(new) conn=04121990 hd=03E01160 dr=03E008F8 JDEDB A (OWADMIN@Business Data - RF)
Jun 23 18:51:39 ** 644/812 SELECT * FROM RFDTA.F0101 WHERE ( ABAN8 = 39093.000000 )
Jun 24 10:24:50 ** 644/812 Entering JDB_CloseTable(Table = F0101)

The enterprise server's jde.ini [Debug] section looks like this:
[DEBUG]
LogErrors=FALSE
Output=NONE
Trace=FALSE
DebugFile=j:\jdedwardsoneworld\ddp\b7333\log\jdedebug.log
JobFile=j:\jdedwardsoneworld\ddp\b7333\log\jde.log
ClientLog=0
JDETSFile=j:\jdedwardsoneworld\ddp\b7333\log\JDETS.log
KeepLogs=1
RepTrace=0
TamTraceLevel=0

Again, I am turning on debug logging with SAW even though the ini file has it turned off.

Any insight would be greatly appreciated.

Thanks,
Jeff
 
Back
Top