Owdlc - JDE.ini - SQL's Commands

[Uzeda]

Owdlc - JDE.ini - SQL\'s Commands

Hi.
I always work with Owdlc to get jdedebug.log and jde.log and I never seen problems (working with Oracle DB).
Now, I am working with SQL Server 2005 and I am trying to verify SQl's commands but I CAN'T.
Example:
I am trying to find select F0411 and i found.
" ODBC:S DBResetRequest conn=03161590 hd=03861768 dr=067DD2E0 SRV-E1-DBP A (JDEDBUSER@System - B7333) "

My jde.ini is:

[DB SYSTEM SETTINGS]
Version=43
Default User=JDE
Default Env=PY7333
Default PathCode=PY7333
Base Datasource=System - B7333
Object Owner=SYS7333
Server=SRV-E1-DBP
Database=System - B7333
Load Library=JDBODBC.DLL
Decimal Shift =Y
Julian Dates=Y
Use Owner=Y
Secured=Y
Type=S
Library List=
TDSError=1
ConnectionPooling=0
Default Pwd=_

[DB SYSTEM SETTINGS - SECONDARY]
Base Datasource=Access32
Object Owner=
Server=
Database=Access32
Load Library=JDBODBC.DLL
Decimal Shift =N
Julian Dates=N
Use Owner=N
Secured=N
Type=A
Library List=
Library=

I think that problem is security BUT I am not sure.

Please answer me.
thanks

 

[kerzenlicht]

Re: Owdlc - JDE.ini - SQL\'s Commands

hi Uzeda.. Did you get an answer to your question? I'm having same issue. Not able to see SQLs in jdedebug.log file.

 

[Alex_Pastuhov]

Re: Owdlc - JDE.ini - SQL\'s Commands

Check OWDLC WEB page - it has an explanation and a workaround there...

 

[Uzeda]

Re: Owdlc - JDE.ini - SQL\'s Commands

I read the manual but It is not explain about this problem.
I am using version OWDLC 8.0.
Thanks.

 

[Adrian_Chimirel]

Re: Owdlc - JDE.ini - SQL\'s Commands

Alex suggested you to check the "OWDLC WEB page", not the Manual

Here it is the excerpt you wanted to read:
<<Known Issues:
From about SP21, toggling debuglog ON using OWDLC makes OneWorld/EnterpriseOne® to log everything, except the SQL statements. This is caused by the new threading implementation in OW Middleware - it now stores a thread-safe copy of the logging flag for each thread (or open datasource?), ignoring the current global value.
The work-around is to start OW with "Output" setting in the "[DEBUG]" section of the JDE.INI file set to "FILE" (no quotes), then toggle DebugLog OFF using OWDLC after starting JDE Client up and truncate the JDEDEBUG.LOG. Now, turning the logging ON and OFF will work just as it used to, before SP21.>>
Warm regards,

 

[Uzeda]

Re: Owdlc - JDE.ini - SQL\'s Commands

I checked before.
I said manual because the web page is explanning the application.
I know use JDE.INI

, I never had that problem before.
The real problems is: when I am checking the jdedebug.log one time shows me the SQL and after doesn't.