Process Scheduler

The following table describes the audit queries and resolutions for this area:

Query Description Resolution

PRCSSCHED-01

SQR-Related Process Definitions (PS_PRCSDEFN) that override the PARMLIST field from the Process Type Definition (PS_PRCSTYPEDEFN).

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Override Options. Remove the value that is assigned to the Parameter List field.

Note: The PRRSCHED-01 query is intended to be a warning. If the override of the parameter list that is specified in the process type definition is intentional, then the above action can be bypassed.

PRCSSCHED-03

Process Definitions (PS_PRCSDEFN), where the OUTDESTTYPE should be set to NONE.

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Destination. In the Output Destination Options group, set the Type option to (None).

PRCSSCHED-04

Process Definitions, where the API AWARE should be set to true.

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Process Definition.Select the check box that reads API Aware.

If API Aware is not marked, this process gets an incorrect run status when it's viewed from Process Monitor. For additional information, please refer to the product documentation for PeopleSoft Process Scheduler.

PRCSSCHED-05

Process Definitions, where process type is not found in the Process Type Definition .

This occurs when a Process Definition is copied from another PeopleSoft database by using project upgrade. However, the Process Type definition that is associated with this Process Definition is not copied into the database. Review the project upgrade that is used to create the Process Definition. Create another project upgrade to copy Process Type definition from the database where the Process Definition originated.

PRCSSCHED-06

Process Job Item (PS_PRCSJOBITEM), where Process Type is listed as a job item, but is not found in the Process Definition (PS_PRCSDEFN).

This occurs when a PSJob is copied from another PeopleSoft database by using a project upgrade. However, the Process Definition for one or more job items in the PSJob is not copied from the database. Review the project upgrade that is used to create the PSJob. Create another project upgrade to copy the Process Definitions that are identified in this report from the database where the PSJob originated.

PRCSSCHED-07

Server Class List (PS_SERVERCLASS), where Process Type is not found in the Process Type Definition (PS_PRCSTYPEDEFN).

This occurs when a Server Definition is copied from another database by using a project upgrade. However, a process type in the Server Class list is not found in the Process Type Definition. Create another project upgrade to copy the Process Type definition from the database where the Server Definition is created.

PRCSSCHED-08

Process Definitions, where the process category is invalid

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Process Definition. Correct the Process Category.

PRCSSCHED-09

Job Definitions, where the process category is invalid.

For the listed jobs, select PeopleTools, and then Process Scheduler, and then Process Scheduler Jobs, and then Job Definition. Correct the Process Category.

PRCSSCHED-10

Process Definitions, where the process category is missing.

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Process Definition. Specify a Process Category.

PRCSSCHED-11

Job Definitions, where the process category is missing.

For the listed jobs, select PeopleTools, and then Process Scheduler, and then Process Scheduler Jobs, and then Job Definition. Specify a Process Category.

PRCSSCHED-12

Server Categories, where a category defined for a server does not exist in process category definition.

For the listed servers, select PeopleTools, and then Process Scheduler, and then Process Scheduler Servers, and then Server Definition. Remove the invalid Process Category.

PRCSSCHED-13

Server Categories, where a server is missing a process category definition.

For the listed servers, select PeopleTools, and then Process Scheduler, and then Process Scheduler Servers, and then Server Definition.

A warning message appears when you open the page, and the missing Process Category is added to the server when the page is saved.

PRCSSCHED-14

Process Scheduler Queue, where a queued/pending request specifies a category that does not exist in process category definition.

Run the following SQL:

DELETE FROM PSPRCSQUE S
WHERE S.RUNSTATUS IN
 ('5', '16') AND
 S.SERVERNAMERQST <> ''
 AND S.PRCSCATEGORY NOT IN
 (SELECT PRCSCATEGORY
  FROM PS_SERVERCATEGORY
  WHERE SERVERNAME =
  S.SERVERNAMERQST AND
  MAXCONCURRENT > 0)

PRCSSCHED-15

Process Definitions, where a process specifies an invalid destination folder.

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Destination. Correct the Destination Folder or blank it out.

PRCSSCHED-16

Process Definitions, where a process definition specifies a recovery process that does not exist.

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Process Definition Options. Correct the recovery process or blank it out.

PRCSSCHED-17

Job Definitions, where a job definition specifies a recovery process that does not exist.

For the listed jobs, select PeopleTools, and then Process Scheduler, and then Process Scheduler Jobs, and then Job Definition Options. Correct the recovery process or blank it out.

PRCSSCHED-18

There are queued processes in tables used by Process Scheduler (PSPRCSPARMS and PSPRCSRQST) containing a DBNAME different than the current database name.

This situation can occur when a database has been renamed.

To resolve the database name, shut down the Process Scheduler server(s), and run the MGRPRCSTBL Application Engine program from the command line.

See Application Engine: Running Application Engine Programs.

PRCSSCHED-19

Process definitions, where a process definition specifies a run time parameter record that does not exist.

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Runtime Parameters, and perform one of the following:

  • select the correct runtime parameter record.

  • remove the incorrect parameters.

PRCSSCHED-20

Process definitions, where a process definition specifies a run time parameter field that does not exist.

For the listed processes, select PeopleTools, and then Process Scheduler, and then Process Scheduler Processes, and then Runtime Parameters, and perform one of the following:

  • select the correct runtime parameter field.

  • remove the incorrect parameters.