Cannot see SQL statments generated by an APPL's FIND button

  • Thread starter Frosty the Coder
  • Start date

Frosty the Coder

Legendary Poster
Cannot see SQL statments generated by an APPL\'s FIND button

I cannot see, in jdedebug.log nor jde.log, the SQL statement generated by an APPL's FIND button.

I can see other SQLs which were generated from FETCH.SINGLEs.

The APPL happens to be a headerless detail. JDE.INI has
LEVEL=BSFN,EVENTS,SF_CONTROL,SF_GRID,SF_PARENT_CHILD,SF_GENERAL,SF_MESSAGING,SF_WORKFLOW,SF_WORKFLOW_ADMIN,SF_MEDIA_OBJ

My coworkers agree that this is something we used to be able to do.
We're trying to figure out at what point we lost this ability, and how do we get it back.

Might this be a "feature" that was enabled when our tools upgrade happened?
 
Re: Cannot see SQL statments generated by an APPL\'s FIND button

Assuming you're running your APPL's on the local web server, you should be able to see the SQL's in the jas logs. Unfortunately, I don't know off the top of my head in which folder you can find those. Someone else may chime in with that or you can go searching ...somewhere under the OC4J folder, I believe.
 
Re: Cannot see SQL statments generated by an APPL\'s FIND button

Try <JDE Install>\system\OC4J\j2ee\home\log
jas_yyyymmdd_0 contains web logs.
 
Re: Cannot see SQL statments generated by an APPL\'s FIND button

Also it 'could be' your ini settings too...?

We can set the level of detail logged.
To capture everything ensure this line

BSFN,EVENTS,SF_CONTROL,SF_GRID,SF_PARENT_CHILD,SF_GENERAL,SF_MESSAGING,SF_WORKFLOW,SF_WORKFLOW_ADMIN,SF_MEDIA_OBJ

Is fully enabled
 
Re: Cannot see SQL statments generated by an APPL\'s FIND button

Ladies and Gentlemen, we have a winner!

I'd completely forgotten about the JAS logs.
blush.gif

Thank you all for jogging my memory!
 
Re: Cannot see SQL statments generated by an APPL\'s FIND button

Bad thing about the JAS logs is you get a parameterized query and you have to manually figure out which values go in which query parameter - you can't simply cut and paste into a query analyzer like you can with the jdedebug.log. Really wish they could find a way to log the final resulting SQL statement in the JAS log.
 
Re: Cannot see SQL statments generated by an APPL\'s FIND button

Brian,

Give JDETrace a try. It will put that SQL back into readable form. Just do File Open on any JAS debug file.

Craig
 
Re: Cannot see SQL statments generated by an APPL\'s FIND button

Thanks for the tip. Will look into using that tool more.
 
Back
Top