Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Application Engine PeopleSoft is a powerful tool that can help automate business processes and improve efficiency in your organisation. However, like any software program, it can sometimes encounter issues or performance bottlenecks that need to be resolved. One way to identify these issues is by generating a trace file, which contains detailed information about the program’s execution. In this blog post, we’ll walk you through the steps to generate a trace in the Application Engine PeopleSoft.
Step 1: Open the Application Engine PeopleSoft program that you want to trace.
Navigation: Main Menu > Peopletools > Process Scheduler > Processes
Step 2: In the “Override Options” section, select the “Parameter list” tab. This is where you can configure the trace options for your program.
Table to refer trace codes
| 0 | Disables tracing. |
| 1 | Initiates the Application Engine step trace. |
| 2 | Initiates the Application Engine SQL trace. |
| 4 | Initiates the trace for dedicated temporary table allocation to an Application Engine trace (AET) file. You can trace how the system allocates, locks, and releases temporary tables during program runs. |
| 128 | Initiates the statement timings trace to a file, which is similar to the COBOL timings trace to a file. |
| 256 | Initiates the PeopleCode detail to the file for the timings trace. |
| 1024 | Initiates the statement timings trace and stores the results in the PS_BAT_TIMINGS_LOG and PS_BAT_TIMINGS_DTL tables. |
| 2048 | Requests a database optimizer trace file. |
| 4096 | Requests a database optimizer to be inserted in the Explain Plan table of the current database. |
| 8192 | Sets a trace for PeopleSoft Integration Broker transform programs. |
| 16384 | Initiates a SQL timings trace and stores the results in the PS_AE_TIMINGS_LG and PS_AE_TIMINGS_DT tables. |
Step 3 : Select ” Append”option we need to add “-trace 7 –toolstracepc3596 –toolstracesql 3 ” Click the “Save” button to save the process request. This will save your trace options and create a process request for the program.
-trace 7 –toolstracepc3596 –toolstracesql 3
If you want to capture bind variables then you can use
-trace 7 –toolstracepc4404
Step 4: Go to the Process Scheduler page and create a new process request for the program. This will allow you to run the program and generate a trace file.
Navigation: Main Menu > Peopletools > Process Scheduler > System Process Request
Step 5: Submit the process request to the Process Scheduler. This will start the program and generate the trace file if the process is successful. Wait for the process to complete. Depending on the size and complexity of your program, this may take some time.
Step 6: Retrieve the trace file by clicking the “view Log/Trace” field.
Step 7: Open the trace file in a text editor or trace viewer to analyze the information. This is where you can review the trace information and identify any issues or performance bottlenecks in your program.
In conclusion, Generate trace in peoplesoft file using Application Engine PeopleSoft can be a valuable tool for troubleshooting issues and improving performance. By following these steps, you can configure the trace options for your program and generate a trace file that contains detailed information about its execution. Once you have the trace file, you can use a text editor or trace viewer to analyze the information and identify any issues that need to be addressed
