Tracing online People Code and SQL
1. Select Trace at the login screen or add “&trace=Y” to the login URL OR - To set trace flags, click here (use this link.
1. Select Trace at the login screen or add “&trace=Y” to the login URL OR - To set trace flags, click here (use this link.
Mohit Jain Tracing in PeopleSoft Applications. The FMS EX team's Mohit Jain has consolidated some of the most frequently used tracing methods that are used within PeopleSoft Applications, covering Application Engine, PeopleCode, Integration Broker, nVision, Cobol & SQR tracing. Application Engine Trace.
2. Choose the options in the tracing screen and login.3. Perform the actions you wish to record.
4. Once complete logout and retrieve the file from the
The trace file name will include your login name.
Tracing online PeopleCode and SQL (Alternative)
1. Login to PeopleSoft and navigate to PeopleTools > Debug.
2. Choose the options and save.
3. Perform the actions you wish to record.
4. Once complete logout and retrieve the file from the
file name will include your login name.
Application Engine Tracing
1. Open the process definition
2. Select the overrides tab.
3. Select Append on the parameters field.
4. Enter -TRACE 131 -TOOLSTRACEPC 3596 -TOOLSTRACESQL
143
5. Save the record.
SQR Tracing
1. Open the process definition
2. Select the overrides tab.
3. Select Append on the parameters field.
4. Enter –DEBUG[ABC]… (replace ABC with the debug letters
provided in the sqr, sqc source).
5. Save the record.
Cobol Tracing
1. Open the Cobol SQL process type for the platform you are running on.
2. Enter 255 in the command line field between two forward slashes “//”.
3. Save the record.
%%PRCSNAME%% %%DBTYPE%%/%%DBNAME%%/%%OPRID%%/%%OPRPSWD%%/%%RUNCNTLID%%/%%INSTANCE%%/255/%%DBFLAG%%
4. Run the process and retrieve the COBOL sqltrace from the process monitor.
Tracing Settings
1. Both the process scheduler (psprcs.cfg) and application server (psappsrv.cfg) config files allow for permanent tracing settings as well as setting up trace Masks. psprcs.cfg -
2. Trace Masks are setup to limit the amount of tracing allowed when a user wants to trace through the front end package (see all methods
above).
3. LogFence allows for lower and higher detail tracing with regards to application server standard logging. This is ideal for identifying problems on the application server.
4. To enable the trace link in the Sign on page.
People-tools > Web-profile.
Web profile > Debugging Tab -> Check the Option - Show Trace Link at Signon
Users ran custom SQR process from windows PSNT scheduler and it is going ERROR and POSTED.
Error from Message Log:
********************
Process Request shows status of 'INITIATED' or 'PROCESSING' but no longer running
Error from View Log Trace File:
*************************
PeopleTools 8 - PSSQR
Copyright (c) 1988-2007 PeopleSoft, Inc.
All Rights Reserved
Database Type: Oracle
Database Name: FSDEV10
Report Name: XRFWIN
Process Instance: 3457710
Run Control ID: 1
Language Code: ENG
Output Destination Type: WEB
Output Destination Format: PDF
Output Destination: E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710
Output Directory (SQOT): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710
Log Directory (SQLG): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710
SQR Flags: -ZIFE:peoplesoftfsdevSQRPSSQRENG.INI
Log File (SQLF): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.out
Include File (SQIN): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710;E:peoplesoftfsdevuesqr;E:peoplesoftfsdevsqr;;
File (FILE_1): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.PDF
SQR Command = E:PeopleSoftfsdevbinsqrORABINWsqrw E:peoplesoftfsdevsqrXRFWIN.sqr */*@FSDEV10 -oE:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.out -xmb -xcb -xi -iE:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710;E:peoplesoftfsdevuesqr;E:peoplesoftfsdevsqr;; -zifE:peoplesoftfsdevSQRPSSQR.INI '-fE:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.PDF' -PRINTER:PD FSDEV10 3457710 VP1 1
Error! SQR Failed To Process
-- Started validating the issue by running sample SQR process from PSNT process scheduler and issue persist by going to ERROR and POSTED.
-- Tried running Sample process ran from PSUNX process scheduler and it went to SUCCESS and POSTED.
Solution:
1. Stop the process scheduler on PSNT scheduler.
2. Clear the Cache.
3. Re-boot the Windows server on which Process scheduler is running.
4. Start the process scheduler on PSNT scheduler.
5. Ran sample SQR process and it went to SUCCESS and POSTED.
Error from Message Log:
********************
Process Request shows status of 'INITIATED' or 'PROCESSING' but no longer running
Error from View Log Trace File:
*************************
PeopleTools 8 - PSSQR
Copyright (c) 1988-2007 PeopleSoft, Inc.
All Rights Reserved
Database Type: Oracle
Database Name: FSDEV10
Report Name: XRFWIN
Process Instance: 3457710
Run Control ID: 1
Language Code: ENG
Output Destination Type: WEB
Output Destination Format: PDF
Output Destination: E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710
Output Directory (SQOT): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710
Log Directory (SQLG): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710
SQR Flags: -ZIFE:peoplesoftfsdevSQRPSSQRENG.INI
Log File (SQLF): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.out
Include File (SQIN): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710;E:peoplesoftfsdevuesqr;E:peoplesoftfsdevsqr;;
File (FILE_1): E:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.PDF
SQR Command = E:PeopleSoftfsdevbinsqrORABINWsqrw E:peoplesoftfsdevsqrXRFWIN.sqr */*@FSDEV10 -oE:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.out -xmb -xcb -xi -iE:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710;E:peoplesoftfsdevuesqr;E:peoplesoftfsdevsqr;; -zifE:peoplesoftfsdevSQRPSSQR.INI '-fE:peoplesoftfsdevappservprcsFSDEV10log_outputSQR_XRFWIN_3457710XRFWIN_3457710.PDF' -PRINTER:PD FSDEV10 3457710 VP1 1
Error! SQR Failed To Process
-- Started validating the issue by running sample SQR process from PSNT process scheduler and issue persist by going to ERROR and POSTED.
-- Tried running Sample process ran from PSUNX process scheduler and it went to SUCCESS and POSTED.
Solution:
1. Stop the process scheduler on PSNT scheduler.
2. Clear the Cache.
3. Re-boot the Windows server on which Process scheduler is running.
4. Start the process scheduler on PSNT scheduler.
5. Ran sample SQR process and it went to SUCCESS and POSTED.