Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to turn on a COBOL SQL trace in PS 7.53

How to turn on a COBOL SQL trace in PS 7.53

How to turn on a COBOL SQL trace in PS 7.53

I am using the EDI manager to upload external vouchers and the vouchers keep getting placed in a "recycle" status for the same error over and over which isn't really an error.  The error reads "TSE Prompt table edit; value not found in prompt table." for SUT_BASE_ID.  There is no place to set up SUT_BASE_ID in the system.  The prompt for this field is the SHIPTO_TBL.  The default value in the record exists actively in the SHIPTO_TBL.  So if you use Selective Line Update to view the errors, fetch the line (which has to be fetched using "Select Lines in Error" AND "Select Lines not in Error" because just the "Select Lines in Error" does not return any rows), and save, the voucher is then in postable status.  So I said all that to say this...
How do I turn on the trace for COBOL SQL programs so I can see what is being fetched and when so that I can narrow down why the program thinks this is an error?  I looked for logs on the server...none are produced for this type of COBOL process apparently.  I looked at the Message Log for the process instance...very vague.  So please, any help would be greatly appreciated.

RE: How to turn on a COBOL SQL trace in PS 7.53

Hi Jean9,

You need to turn the trace on through the use of config manager.  There is a tab called "Trace".  The Options in the left side are related to SQL trace and timings - you will also need to specify the output destination and filename otherwise it will drop it to a default filename and location (which I can't remember).

To get it to work immediately - or at the client level, you should also set the SQL trace options at the following menu path:  Go > PeopleTools > Utilities > Use > Trace SQL.

Hope that helps.

RE: How to turn on a COBOL SQL trace in PS 7.53

I set the values on the configuration manager and through the panels as you suggested.  The file produced by the trace turned on at the configuration manager was only calls to the database for when I accessed the database and calls for queries I ran.  Maybe I selected the wrong things but it did not show any of the sql executed within the cobol program I ran.  The trace turned on via the panels did not result in a trace dump of any sort that I have been able to find on my local drives or the server.  I did not see a place to set that.  Do you know what the default dump site is for the trace turned on via the panels?  I did notice that after I saved the trace settings and re-entered the panel, my trace selections were reset as though I had never set them.  Should this panel remain open during the cobol program run?

RE: How to turn on a COBOL SQL trace in PS 7.53

Hi Jean,

Every time you open the utilities/trace panel it resets to just the first tick box - but I am pretty sure it does not need to remain open.

The output file location is set in config manager on the trace panel - but I have found that it does not always start writing to this file unless you set it first in config manager and then log in to the application  - otherwise it defaults to a name and location somewhere on the app server.

I always set the trace in the utilities and config manager.

The trace created should provide all of the sql selects, followed by a series of lines showing the setting of all of the bind variables and timings for each select.  

I have not done this for a few years - so hopfully not leading you astray.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close