Debug Toggle and resulting log

[chigrrl]

I have set up the bsfn to toggle debug on the fly. It does update jde.ini. However, if I do the following in order:
1. log on to JDE
2. run toggle to turn debug on
3. submit local UBE - click 'logging' and set level to 6
4. job finishes, in printqueue .txt log exists BUT for the sql commands the values are missing. Ex: SELECT * FROM OBJ7333.F9860 WHERE (SIOBNM = '?').
5. log off
6 log back on - jde.ini still says Debug=FILE
7. resubmit job with logging level = 6
8. NOW I get what I expect in jdedebug.log: Ex: SELECT * FROM OBJ7333.F9860 WHERE (SIOBNM = 'R42520').

So the 1st time all of my sql statements had '?' and after logging off/on they had the real values. My toggle works, I can verify by looking at the jde.ini and by the fact that the .txt file generates in printqueue AND jdedebug'log populates. Only problem is the values in the sql statements.

chigrrl
B7333
SP22
Rev 6
NT/SQL

 

[Alex_Pastuhov]

I was looking at the same or similar problem with our freeware OWDLC (OW Debug Log Commander) tool.

A fix is now available for download (along with some additional instructions) from our WEB Page.

Regards,
Alexander Pastuhov
Pastuhov Consulting Pty. Ltd.
E-Mail: [email protected]
Mobile: 0414 453 433
WWW: http://www.pastuhov.com.au/index.htm
CNC Consulting and Software Tools for OneWorld®
Check out our Special Offers at:
http://www.pastuhov.com.au/special_offers.htm


PS: Jolly, it wasn't my question either ;-)

 

[jolly]

PPS: Never in a million years would I have thought it was! 8^D

 

[chigrrl]

Thank you Alex. I will use your tool when I can but the client that I am at doesn't want me to download it. Is there any way I can fix my bsfn to correct the issue?

Thanks.

 

[Alex_Pastuhov]

Not necessarily, but you can try the workaround I found - it's on the OWDLC WEB Page. Works for me.

Regards,
Alexander Pastuhov
Pastuhov Consulting Pty. Ltd.
E-Mail: [email protected]
Mobile: 0414 453 433
WWW: http://www.pastuhov.com.au/index.htm
CNC Consulting and Software Tools for OneWorld®
Check out our Special Offers at:
http://www.pastuhov.com.au/special_offers.htm