Cisco Cisco Workload Automation 6.3 User Guide
46
Troubleshooting and Maintenance
Troubleshooting
A CWA PeopleSoft job should optimally contain only one PeopleSoft process. This allows CWA to control all
dependencies, and allows greater visibility and control via CWA.
dependencies, and allows greater visibility and control via CWA.
Perform maintenance on your PeopleSoft database by running the Application Engine process,
PRCSYSPURGE
, to
purge old request records that accumulate in the database. You can configure the Peoplesoft Process Scheduler
server to run the
server to run the
PRCSYSPURGE
on a regular basis.
Troubleshooting
This section lists some error conditions and how to determine possible causes and remedies for the conditions:
If the master cannot connect to the PeopleSoft database
CWA checks the installed version number of PeopleSoft. If the version does not match one of the supported PeopleSoft
releases, specified in “Configuring the Adapter”, you will be unable to connect. The connection status light will be red.
You can check CWA’s logs or the
releases, specified in “Configuring the Adapter”, you will be unable to connect. The connection status light will be red.
You can check CWA’s logs or the
Event
log for error messages. In this case, the error message will specify “invalid
version.”
If you cannot see the output from a CWA PeopleSoft job
If you cannot see the output from a CWA PeopleSoft job, verify that the
Save Output
option on the
Options
tab of the
Job Definition
dialog is set to either the
Append
or
Replace
option.
Another possibility when you cannot see output from a CWA PeopleSoft job is that the master service is configured as
the local system account. This is a problem if a mapped drive is used to specify the location of PeopleSoft job output
and the master service on Windows does not have access to that path. In this case, you must add the drive, by mapping
from the CWA master machine and setting the master service to logon to an account with access to the same drive letter
as specified in the output location path.
the local system account. This is a problem if a mapped drive is used to specify the location of PeopleSoft job output
and the master service on Windows does not have access to that path. In this case, you must add the drive, by mapping
from the CWA master machine and setting the master service to logon to an account with access to the same drive letter
as specified in the output location path.
Frequently Asked Questions
How do you specify locations in the Default Output Location field?
You can use UNC conventions and mapped drives to specify shared locations on remote machines. Do not include the
filename. Note that the full path is needed; a full path is a designation of the location of a file which includes the root
directory and the descending series of subdirectories leading to the end file.
filename. Note that the full path is needed; a full path is a designation of the location of a file which includes the root
directory and the descending series of subdirectories leading to the end file.
What is UNC?
UNC stands for Uniform Naming Convention or Universal Naming Convention. UNC is a way of specifying directories,
servers, and other resources on a network, indicating path or directory levels within the computer. For example:
\\computer_name\directory_name.
servers, and other resources on a network, indicating path or directory levels within the computer. For example:
\\computer_name\directory_name.
Why is the connection status light red/yellow?
The
Connections
pane shows the PeopleSoft adapter along with all of the other defined CWA agents. If the PeopleSoft
connection is not available to the master, the connection status light in the first column of the display will be red. This
light is relative to the CWA master.
light is relative to the CWA master.
PeopleSoft Tables Used by CWA
CWA reads from the following PeopleSoft tables but only updates those tables indicated by **.
Caution:
Be sure that the database user specified in the connection definition can read from all of the following
PeopleSoft data tables. Only the tables marked by a ** require write access.