Friday, February 10, 2006

Trace Unique PeopleSoft Session

If you want to generate trace for your own PeopleSoft Session (8.x) and not for everybody else, you can append trace=y to the login URL. For e.g. if the login URL is
http://yourwebserver.com/psp/ps/?cmd=login adding &trace=y at the end will show you special trace settings you can enable. The url will look like
http://yourwebserver.com/psp/ps/?cmd=login&trace=y

3 comments:

zuke said...

Hey, you have a great blog, check out mine when you get a chance , its about related stuff

Vivek Panikulam said...

Below method from customer connection gives a more precise trace..

1. Navigate to the page where the problem exists and be ready to click on the button. In this example, we want to get an Online Trace for the time we Add a new Journal.
2. In the right corner of your screen, click on 'New Window' to open a new window. On the new window, navigate to the following menu: PeopleTools > Utilities > Debug. Under this menu, there are several options for the tracing:-Trace SQL-Trace PeopleCode-Trace Page.
3. For our example, we will create an online trace for SQL as we want to see what the table is being selected and updated. In most cases, selecting 'Trace SQL Statement' and 'Trace SQL Bind' will be sufficient. For PeopleCode, usually, all the 'Show' options are the selection that we need. Save the page, and do not close it.
4. Now, check for the existing trace file. The trace will be created in Logs folder on your Application Server.[PS_HOME]\appserv\[domain]LOGS. For example: E880G71P\appserv\E880G71P\LOGS.
5. The online trace filename will be similar to [user name]_[machine name].tracesql. For example: VP1_FLINAN12345.tracesql. If you find an existing one, rename or delete it.
6. Now go back to your original page. And click on 'ADD' button.
7. When the process is finished, it should create the trace file on the Logs directory. Copy the file to your workstation as it will be appended with new information everytime you turn on the online trace.
8. Don't forget to turn off the tracing.
9. HAPPY TRACING!

Ketan Kothari said...

We cannot use this method, if PeopleSoft Administrator disables New Window link.
This method is useful only if you know exactly where you want to generate the trace. Sometimes developer may not have an idea where to enable the trace. In this case, the entire session based trace is useful, instead of turning the domain wide trace. While developing applications in dev environment, you can even use PeopleCode SetTraceSQL and SetTracePC to enable the trace for a specific section of code only. All the tracing methods, Session Based Trace, Using the Trace Page and PeopleCode trace functions allows you to generate trace based on your situation.