Cisco Cisco Workload Automation 6.3 User Guide

Page of 54
45
Cisco Systems, Inc.
www.cisco.com
4
Troubleshooting and Maintenance
Overview
This chapter covers various topics that can help you maintain, use best practices, and troubleshoot the PeopleSoft 
Adapter including:
Performing Recommended Maintenance
Request records are created in the 
PSRCSRQST
 table(s) each time a process in a PeopleSoft job is submitted by CWA. 
Gradually, these records may accumulate. Periodically, you may want to delete these old request records from the 
PSPRCSRQST
 and related tables as a routine maintenance task.
PeopleSoft provides an application engine process called 
PRCSYSPURGE
 to purge Process Scheduler tables and 
process files. You can configure this process to run on a regular basis within PeopleSoft from the 
System Purge 
Options
 tab displayed by selecting 
PeopleTools>Process Scheduler>System Settings
. You can also schedule the 
process to run as a job in CWA.
Best Practices
The following is a list of recommendations for maximizing your success with the PeopleSoft module:
Choose the PeopleSoft database owner as the database user discussed in 
.
Create a PeopleSoft operator called 
Batch
 (or some other identifier no more than 8 characters in length). Then, add 
this PeopleSoft operator ID to CWA and have 
Batch
 as the runtime user for all CWA PeopleSoft jobs. This will make 
it easy to identify jobs originating from CWA in the PeopleSoft environment.
Note: 
Ensure that this new PeopleSoft operator ID has the rights to run all of the processes you would like it to 
manage via CWA.