If you have worked with Oracle Support for any appreciable amount of time, you have probably been asked to get a trace of a failing process.  You may have been told how to get the trace since this is not something that our customers would do on a routine basis, or you may have known exactly what to do to get it.   When it comes to actually reading and interpreting the trace, however, many people just pass the file along to someone who understands it.  If this describes your situation, or if you really want to know and understand how a process works, then you’re in luck.

 

We have an existing library of video instruction that teaches our customers how to acquire various traces, about the contents of a trace and how to interpret them, and we’ve added a new series on Application Engine Tracing and Troubleshooting.  In this series, we explain how to acquire a trace of any App Engine process, what the different traces consist of and how you can use them to see how a process uses your data.  We’ve also included a video on the use of cursors in PeopleSoft applications that helps you understand traces for any process, including Cobol and online activity.  This training is not for the technical crowd, though it may certainly help out that constituency, but is instead geared towards functional folks and people who would like to expand their understanding of PeopleSoft processes and develop their troubleshooting skills.

 

The new training videos for Application Engine Troubleshooting and Problem Diagnosis are:

 

How to Acquire an Application Engine Trace - <Note 1094728.1>

Interpreting the .AET Trace for an Application Engine Process [Video] - <Note 2092052.1>

Interpreting the .stdout Log File Trace for an Application Engine Process [Video] - <Note 2092093.1>

Interpreting the PeopleCode and SQL Trace for an Application Engine Process [Video] - <Note 2092097.1>

Understanding Cursors in PeopleSoft Applications, Cobol and App Engine Processes - <Note 2092074.1>

Diagnosing Performance Problems With Application Engine Processes [Video]- <Note 2092088.1>

 

But there are more than just these available to you.  The following is a listing of our series for troubleshooting assistance.  If you would like help in understanding the content of any of these videos, you can leave a comment on the document that contains the video.  If you would like us to develop training on other subjects, please just drop a comment on to this blog post and we’ll see what we can do.

 

Cobol Problem Diagnosis and Tracing Assistance

 

How to Acquire a Cobol SQL Trace - <Note 1092955.1>

Elements and Interpretation of a Cobol SQL Trace - <Note 1102782.1>

Understanding Cursors in PeopleSoft Applications, Cobol and App Engine Processes - <Note 2092074.1>

Diagnosing Functional Problems with a Cobol SQL Trace - <Note 1119500.1>

How to Diagnose Performance Problems with a Cobol SQL Trace - <Note 1109345.1>

Diagnosing Common Problems that Occur During the Execution of a PeopleSoft Cobol Job - <Note 2017882.1>

How to Diagnose Error 153 (Subscript Out of Range or Array Size Exceeded) in a Cobol Job - <Note 1153577.1>

Understanding the Cobol Compile Process and TroubleShooting Problems Compiling Cobol - <Note 1099163.1>

 

 

Page, PeopleCode and Online SQL Tracing and Troubleshooting

Introduction to TroubleShooting Problems with the PeopleSoft Page Processor - <Note 1581575.1>

Acquiring and Interpreting a PeopleCode Trace - <Note 1581649.1>

Acquiring and Interpreting an Online SQL Trace - <Note 1581652.1>

How to Acquire a Combined PeopleCode SQL Trace - <Note 1083800.1>

Interpreting a Combined PeopleCode and Online SQL Trace - <Note 1581653.1>

The Value of "Show Each Statement" and Diagnosing Problems on a Page - <Note 1581654.1>

Understanding Cursors in PeopleSoft Applications, Cobol and App Engine Processes - <Note 2092074.1>

 

 

Application Engine Tracing and Troubleshooting


How to Acquire an Application Engine Trace - <Note 1094728.1>

Interpreting the .AET Trace for an Application Engine Process [Video] - <Note 2092052.1>

Interpreting the .stdout Log File Trace for an Application Engine Process [Video] - <Note 2092093.1>

Interpreting the PeopleCode and SQL Trace for an Application Engine Process [Video] - <Note 2092097.1>

Understanding Cursors in PeopleSoft Applications, Cobol and App Engine Processes - <Note 2092074.1>

Diagnosing Performance Problems With Application Engine Processes [Video]- <Note 2092088.1>

 

 



Take a look at them, use them to learn more, and let us know what you think.