Trace Application Engine Processes Using Process Definitions

Your rating: None Average: 4.5 (39 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)

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.
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?

CompShack's picture
User offline. Last seen 3 years 12 hours 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

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.

CompShack's picture
User offline. Last seen 3 years 12 hours 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

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?

Lepa's picture
User offline. Last seen 7 weeks 3 days ago. Offline
Joined: 06/23/2008
Posts: 590
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

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...............

Vikas Bhardwaj's picture
Vikas Bhardwaj (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Beautiful article..

Thanks a lot..

Regards,
Vikas Bhardwaj

vikram's picture
vikram (not verified)
Re: Trace Application Engine Processes Using Process Definitions

thanks a lot

Guest's picture
Guest (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Hi,
Please share the above doc,

Guest's picture
Guest (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Anyone knows how to apply this to a PS TASK ?
I have a task with 3 app engines and I dont know which is at fault ?

Lepa's picture
User offline. Last seen 7 weeks 3 days ago. Offline
Joined: 06/23/2008
Posts: 590
Re: Trace Application Engine Processes Using Process Definitions

You mean PS Job? Anywho, you need to apply it to each AE. You can't trace a task or PS Job.

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

Alok's picture
Alok (not verified)
Re: Trace Application Engine Processes Using Process Definitions

Thanks for all the above comments it looks so nice....
I am having a issue... when i run a process with admin id like security admin it shows me three out put file View Log/Trace
as for example .AET, .stdout and .trc but when i am trying to run the same process with another id, i am not getting the .trc file. i have changed as per the article
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. But still i cant find the .trc file. I would like to know if there is any setting missing from permission list or any where. Thanks in advance for your help

weilies's picture
User offline. Last seen 5 years 11 weeks ago. Offline
Joined: 03/10/2010
Posts: 1
Re: Trace Application Engine Processes Using Process Definitions

i tried

-Trace 0 -TOOLSTRACEPC 0 -TOOLSTRACESQL 0

put it still generate thae trace, how can i disable it?

Guest's picture
Guest
Re: Trace Application Engine Processes Using Process Definitions

yo utilizo este:

-TRACE 7 -TOOLSTRACEPC 3596 -TOOLSTRACESQL 31

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
12 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.