My Oracle Support Banner

E-PRCS: Master Note Process Monitor (Doc ID 1266354.1)

Last updated on JULY 01, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.44 and later
Information in this document applies to any platform.
** Reviewed Currency on 14th March, 2016 **

Details

 

 

Process Scheduler Process Monitor Master Note
 

This Master Note answers the most common questions about Process Scheduler Process Monitor that we have encountered for PeopleTools 8.4x.
An additional one will be created for PeopleTools 8.50.

Understanding Process Monitor

After a job is submitted using the Process Scheduler Request page, use Process Monitor to review the status of scheduled or running processes.
All processes can be viewed to see the status of any job in the queue and control processes that user initiated.

Process Monitor consists of two pages: the Process List page and the Server List page.
1. Process Monitor - Process List
2. Process Monitor - Server List

Navigation:
PeopleTools > Process Scheduler > Process Monitor > Process List page.

Use the Process List page to monitor the process requests that one submits.
Processes that are queued to run in the future can also be viewed here.
From Process List page one can Delete, Cancel, Hold or Restart a specific process.

From this page the Process Details page can be accessed.
Click the "Details" link on the Process List page to access the Process Detail page.
Use the Process Detail page to view details, such as request parameters and message logs.
Update Process

The actions that are available in this group box depend on user's authorizations and the current status of the request (See the field Allow Process Request under User Process Profile's Permission List).
This group box is available only if the user ID is authorized to update the selected request.
The option that can be selected depends on the current run status of the process request.
For instance, a job that has already completed cannot be canceled, and a request that is currently processing cannot be put on hold.

Navigation:
PeopleTools > Process Scheduler > Process Monitor > Server List page.

Use the Server List page to view information about each of the PeopleSoft Process Scheduler Server Agents that are defined in the system.

From this page Server's status (Running, Down, or Suspended) can be seen.

If any server was configured as a Master Scheduler, this is the place where this can be checked.
If a server is designated as a Master Scheduler, then it displays Y under the Master column.
Click on "Details" link for each server to display detailed information about the selected server agent.

If a user will not be able to see the Process Schedulers listed in the Server List page, then chances are that this user does not have access to view the Process Scheduler(s) which are up, nor the status of those Schedulers.
To add, or remove access, view the 'Process Profile Permissions' for that user.
Here can be found the 'View Server Status' check box which has either to be activated or deactivated.

FAQ

1. How to disable Server Name, Recurrence, Type and Format fields?
2. How to Delete, Cancel, Hold and/or Restart a specific process from Process Monitor?
3. How to change the Time Zone displayed for users under "Run Date/Time" column in Process Monitor?
4. How to change the Server Status with Process Monitor?
5. How to delete a process scheduler server definition?

This can be achieved through Process Profile Permissions of an user.

To update a process profile:
1. Select PeopleTools > Security > Permissions & Roles > Permission Lists to open the permission list definition.
2. Select the "Process" page.
3. Click the "Process Profile Permissions" link.
4. Select the appropriate options in the "Allow Process Request" group box.
Override Server Parameters
Override Output Destination
Update Server Status
Enable Recurrence Selection
5. Save the permission list.

To assign a process profile to a user ID:
1. Select PeopleTools > Security > User Profiles > User Profiles to open the profile for a user ID.
2. Select the user ID.
3. Select the "General" page.
4. Enter the process profile for this user ID.
5. Click the "Save" button to save the changes.

The Delete, Cancel, Hold, and Restart options can be performed only on processes with specific run statuses.
Therefore, the options will only be visible when processes are filtered by a valid run status for that option.

If the PeopleSoft Administrator wants the access to DELETE users processes/reports, add the REPORTDISTADMIN role to the user, log out of the current browser session, and log back in.

Steps for changing the Time Zone that is displayed for individual users:

1. Go to the My Personalizations link on PeopleSoft home page, and click on the Personalize Options button for Internal & Regional Settings.

2. From the Override Value drop down box, change the Local Time Zone to the time zone needed to be displayed.
Click OK.
Click on the Explain link for Local Time Zone to see this explanation.

"Your local time zone. This option determines which time zone is used when the Use Local Time zone option is set to Yes.
The Local Time Zone is used in PeopleCode.
For example, %ClientDate determines the current date in the local time zone of the user."

The next few steps discuss on how to change the Use Local Time zone option to Yes.

3. Navigate to PeopleTools, Personalization, Personalization Options and click Search.
Choose PPTL.
Navigate to the Format tab. This page displays a list of user options and their default values.

4. To change the default value for Local Time zone, find the user option titled TZONE (it should be the last in the list).
Click on the link to Set Option Default Value.
From the drop down choose Yes to set the Option Default Value.
- If needed to default / change the LTZONE for the application, scroll to the right and choose the set default option value and set/change the default.

5. Click OK and Save before leaving the Personalization Options page.

Note:
For these changes to take effect, there is no need to reboot anything or log out of current PeopleSoft session. The changes should take effect immediately.

The only available options in PIA are Stop / Suspend / Restart Server from Process Scheduler > Process Monitor > Server Details page.
Stop Server (OS390 only)
Select to shut down a PeopleSoft Process Scheduler Server that is running or exhibiting problematic behavior.
Suspend Server
Select to prevent a running PeopleSoft Process Scheduler Server from accepting new process requests.Restart Server
Select to restart a PeopleSoft Process Scheduler Server that has been suspended. If a server has been stopped, it must be restarted using PSADMIN.
Note:
After selecting one of these options, click OK to run the command.

For PeopleTools 8.42 and higher, the Stop function will be disabled for NT & Unix schedulers.
It will still be available for OS/390 since Tuxedo is not used.

The option to Stop the process scheduler from Process Monitor is enabled from the Process Profile Permission list assigned to a particular user.
Go to Maintain Security and access a User Profile.
The first page that is presented is called "General."
At the bottom of this page there is a field called Process Profile.
The value in that field is a permission list that controls certain process scheduler permissions.
Go to Permission Lists and search for this permission list.
Click on the Process tab and then click on the Process Profile Permissions link.
The check box for Update Server Status is what controls the ability to use this function.

There is no way to delete a process scheduler server definition from the PeopleSoft online system.
Process Scheduler Server Definition may be removed using SQL from PeopleSoft system tables. This is not a supported method.

Only to remove it from Process Monitor, use the following SQL:
delete from PSSERVERSTAT where SERVERNAME = ;

 

If the server definition was not used and it has to be removed entirely, then use the following SQL:
DELETE FROM PS_SERVERCLASS WHERE SERVERNAME= ;
DELETE FROM PS_SERVEROPRTN WHERE SERVERNAME= ;
DELETE FROM PS_SERVERDEFN WHERE SERVERNAME= ;

To remove a definition that has been used, remove it from the following tables as well:
PS_SERVERACTVTY
PS_SERVERMESSAGE
PS_SERVERNOTIFY
PS_SERVERPURGLIST
PSPRCSQUE
PS_CDM_TRANSFER
PSPRCSRQST

Known Issues

1. Not all servers defined can be seen under Server List of the Process Monitor.
2. Process Scheduler Status shows DOWN in Process Monitor when it is actually up and running.

A user may notice that not all servers are listed in the Server List of the Process Monitor.
However, the Search dialog of the Servers menu can display that there are more servers available, meaning not all servers defined can be seen under Server List of the Process Monitor.

Checkpoints
-----------
1. OPRID may not have Process Profile Permissions to "View Server Status".
(Process Profile Permissions - View Server Status)
Chances are this user does not have access to view the Process Scheduler(s) which are up, nor the status of those Schedulers.

To add, or remove access, go through the following steps:

a. Find out the Process Profile Permission list used by the user by navigating to the following (For PT 8.4):
PeopleTools > Security > User Profiles > choose affected user profile (for instance VP1) > and look at the bottom of the page for the "Process Profile" Permission List.
Make a mental note of that Permission List and move to #b.
b. Navigate to:
PeopleTools > Security > Permission Lists & Roles and insert that Permission List.
Go to the 'Process' tab and view the 'Process Profile Permissions' for that user.
Here can be found the "View Server Status" check box which has either to be activated or deactivated.

2. Server must be successfully booted in this environment to add its status information.

3. Run the SQL below and check if the rows of data returned do include SERVERNAME field called PSNT, for example.
select * from PSSERVERSTAT
Chances are that the PSNT was never started.
Once it will be started, it will be listed in the Server List of the Process Monitor.
As many server names can be basically defined in the Server definition.
However, that doesn't mean that these server names should get listed on the Process Monitor Server List unless the server was started from the PSADMIN utility or Windows services.

4. The server name which got added to the Server definition needs to be the same as the PrcsServerName parameter in the psprcs.cfg.

5. Check if PSNT is configured to run on the same database as the rest of the servers.
This can be done by opening PSNT psprcs.cfg file and verify the DBName value is the same as other servers.

Checkpoints
------------
1. Check the PSPRCSLOCK table for aging locks.

2. Query the PSSERVERSTAT table checking for Status and heartbeat timestamp comparing it to the system clock.

3. Check the amount of records in the PSPRCSRQST table for performance issues.

4. Set LogFence=5 and TraceSQL=127, reproduce the issue and analyze the generated Log and Trace files.

5. Focus on the following solutions:
E-PRCS: Process Scheduler is running on Server but Process Monitor shows Down (Doc ID 610115.1)
E-PRCS: Process Scheduler DOWN in Process Monitor Server List tab (Doc ID 608637.1)

Reference

PeopleBooks:

Enterprise PeopleTools 8.4x PeopleBook: PeopleSoft Process Scheduler > Using Process Monitor

Enterprise PeopleTools 8.4x PeopleBook: PeopleSoft Process Scheduler > Setting Up PeopleSoft Process Scheduler Security

KEYWORDS:

PROCESS SCHEDULER, SCHEDULER, PROCESS MONITOR, SERVER, SERVER LIST

 

 

Actions

 

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
Actions
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.