How do I create a trace file?

How do I create a trace file?

Creating a trace file is useful when troubleshooting database-related issue.

1. Run the MS SQL Server Management Studio.
2. Go to Tools > SQL Server Profiler.
3. Provide a name under Trace name.
4. Use the “Standard (default)” template.
5. Click Save to File.
6. Provide the path and filename for the file to be saved.

How do you trace a page in PeopleSoft?

(b) Trace SQL Page. Once you’re logged into the system, go to PeopleTools -> Utilities -> Debug -> Trace SQL. This will set up a trace from the moment you click ‘Save’. The trace will end by either (i) returning to the page, unchecking the flags and clicking ‘Save’, or (ii) logging out of the session entirely.

How do you debug an app engine in PeopleSoft?

To enable the PeopleCode debugger for Application Engine:

1. Sign on to PeopleTools using the same user ID that you will use to invoke the Application Engine program.
2. Open Application Designer.
3. Select Debug, PeopleCode Debugger Mode.
4. Select Debug, Break at Start.

How do you do a trace without Profiler?

You can create traces without Profiler’s user interface by executing system stored procedures. First, you must create a trace using sp_trace_create, then add events using sp_trace_setevent, and set filters using sp_trace_setfilter.

How do you debug an application in PeopleSoft?

Debugging Your Application

1. Access the PeopleCode debugger.
2. Use PeopleCode debugger features.
3. Use PeopleCode debugger options.
4. Set up the debugging environment.
5. Compile PeopleCode programs at once.
6. Set PeopleCode debugger log options.
7. Interpret the PeopleCode debugger log file.
8. Use application logging.

How to enable signon tracing option in PeopleSoft?

How to enable Signon Tracing option in PeopleSoft 1 Enable the Sign on trace options 2 Sign in and do the same transaction 3 Retrieve the trace file generated in the app server 4 Look for the place where the error/warning message has been produced

Why is OEM not capturing SQL in PeopleSoft?

You may face an issue where users are complaining of slow performance and OEM is not capturing the SQL – you have two options: Find the SQL using PeopleSoft trace or enable a database trace. You should first try to do PeopleSoft trace. Also, you need to understand what all is in the trace without getting confused.

How do I delete a trace that has been created?

Once you have generated the traces, if you are working with Global Support Center, you can send the zipped trace file to the analyst working your case. Now log in to the application and reach the page/menu where the problem lies and go and delete the trace that is created thus far (for location of trace see below).

How to set application engine program trace parameters?

The normal application trace (*.tracesql) will not contain the Application Engine Program traces. For that AE Trace parameters (TraceAE, TracePC and TraceSQL) are to be set differently. You can set them either in the configurations files or from PIA.