Ask Question
Help Others
Home › Blogs › Lepa's blog

Trace Application Engine Processes Using Process Definitions

Tue, 04/29/2008 - 3:31pm — Lepa
Your rating: None Average: 4.5 (11 votes)

In this post I will show you how to trace an application engine process using the Process Definitions without setting the trace in the Process Scheduler’s psprcs.cfg configuration file.

Navigate to the process definition of the application engine that you would like to trace (PeopleTools > Process Scheduler > Processes). Go to the Overrride Options tab, and from the Parameter List drop down select Append, and in the edit box next to it add the following line:

-TRACE 7 -TOOLSTRACEPC 4044

TRACE application engine using process definition

This will trace SQLs inside of your application engine as well as peoplecode. Save the process definition and go ahead and run your program. To examine the trace files, just navigate to the process monitor, click details on your process, then View Log/Trace.

-TRACE output goes into Application Engine Trace (.AET)
-TOOLSTRACEPC output goes into the PeopleTools trace file (.trc)

Bookmark/Search this post with:
  • Delicious
  • Digg
  • StumbleUpon
  • Reddit
  • Furl
  • Facebook
  • Google
  • Yahoo
  • Technorati
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Sun, 05/04/2008 - 4:18pm
#1
Guest's picture
Guest (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Hello Compshack! It is very helpful. what is -TOOLSTRACEPC and 4044 in trace options?

Top
  • reply
Mon, 05/05/2008 - 8:46am
#2
CompShack's picture
CompShack
User offline. Last seen 41 weeks 2 days ago. Offline
Joined: 12/09/2007
Posts: 167
Re: Trace Application Engine Processes Using Process Definitions

-TOOLSTRACEPC is to trace the PeopleCode inside of your application engine. The 4044 is a bit number and you set that depending on what you want to trace. PeopleSoft recommends setting this to 4044.

The following is a list of the Trace values and what they do and 4044 is combination of set of values from below.

0       Disables tracing.
1       Initiates the Application Engine step trace.
2       Initiates the Application Engine SQL trace.
4       Initiates the trace for dedicated Temp Table Allocation to AET file.
8 not yet allocated
16 not yet allocated
32 not yet allocated
64 not yet allocated
128      Initiates the statement timings trace to file, which is similar to the COBOL timings trace to file.
256      Initiates the PeopleCode Detail to the file for the Timings trace.
512 not yet allocated
1024    Initiates the statement timings trace, but, instead of writing to the trace file, this trace stores the results in the following tables: PS_BAT_TIMINGS_LOG and PS_BAT_TIMINGS_DTL.
2048    Adding this value requests a database optimizer trace file.
4096    Requests a database optimizer to be inserted in the Explain Plan Table of the current database.
8192    This value sets a trace for Integration Broker transform programs.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
  • reply
Tue, 05/13/2008 - 11:54am
#3
Guest's picture
Guest (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Hi, just curious if you know what would create the .trc file if tracing is NOT turned on by psprcs.cfg or by adding to the parameters field. We are running an AE, and it's creating a .trc file with "PeopleTools(8.44.06) AE SQL/PeopleCode Trace" heading. Regards.

Top
  • reply
Tue, 05/13/2008 - 1:07pm
#4
CompShack's picture
CompShack
User offline. Last seen 41 weeks 2 days ago. Offline
Joined: 12/09/2007
Posts: 167
Re: Trace Application Engine Processes Using Process Definitions

Hi there,
Did you check trace flags on the psappsrv.cfg file? That might be what is triggering your online trace!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
  • reply
Mon, 07/27/2009 - 10:11am
#5
Guest's picture
Guest (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Is there any reason why the trace won't get generated if I schedule the process but it gets generated when I run it manually?

Top
  • reply
Mon, 07/27/2009 - 9:43pm
#6
Lepa's picture
Lepa
User offline. Last seen 1 day 2 hours ago. Offline
Joined: 06/23/2008
Posts: 479
Re: Trace Application Engine Processes Using Process Definitions

it shouldn't - is the scheduled process has the same process definition?

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
  • reply
Mon, 06/14/2010 - 11:01am
#7
Paritosh's picture
Paritosh (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Can some attached the document how to run application engine throught frontend...............

Top
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
17 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.