11/14/11

PeopleSoft Purge Process for Process Scheduler

What does PRCSYSPURGE process do? 
The PRCSYSPURGE application engine program is run on the master Process Scheduler server.
Updates statistics and purges process request tables.
  1. Cleans up Report Manager Repository and purges Report Repository tables.
  2. If more than one Process Scheduler server exists, the application engine program PRCSRVCLN is scheduled to run. This program cleans up the Report Repository tables for a specific server.
  3. The application engine program PSXPARCHATTR gets run to archive BI Publisher report-related metadata and the URLs of the report files.

What tables are affected by PRCSYSPURGE?
The purge process updates the statistics of the following tables before deleting entries from them:
This step removes all expired entries from the process request tables. These tables include:
  1. PSPRCSRQST - Process Request table
  2. PSPRCSQUE - Process Request Queue
  3. PSPRCSCHLDINFO
  4. PSPRCSPARMS - Process Request Parameters
  5. PS_MESSAGE_LOG - Message Log Table
  6. PS_MESSAGE_LOGPARM - Message Log Parameter Table
  7. PSPRCSRQSTXFER
  8. PSPRCSRQSTTEXT
  9. PSPRCSRQSTFILE
  10. PSPRCSRQSTMETA
  11. PSPRCSRQSTSTRNG
  12. PSPRCSRQSTTIME
  13. PS_PRCSRQSTNOTIFY
  14. PS_PRCSRQSTURL
  15. PS_PRCSFILE
  16. PSPRCSJOBSTATUS
  17. PSNVSBATCHRSTRT
  18. PS_PRCSRQSTDIST - Content Distibution Manager
  19. PS_CDM_LIST - Content Distribution Manager - Content List
  20. PS_CDM_AUTH - Content Distribution Manager - User Access
  21. PS_CDM_FILE_LIST - Report Manager - File List
  22. PS_CDM_TRANSFER
  23. PSRF_RATTR_TBL
  24. PSRF_RSCRTY_TBL
  25. PSRF_RDESC_TBL
  26. PSRF_RDESC_LANG
  27. PSRF_RINFO_TBL
  28. PSPRCSRQSTARCH.
  29. Clean the archive table PS_CDM_LIST_PURGE
The option to enable or disable updating statistics is set in the process scheduler configuration file - psprcs.cfg. In the [Process Scheduler] section in psprcs.cfg file, check the value for 'Update Table Stats on Purge'. A value of 0 disables updating of the table statistics while value of 1 enables updating of table statistics.

In the [PSTOOLS] section, check the value for 'DbFlags'. A value of 0 issue a command to issue the update table statistics to the database while a value of 1 will not update statistics. It is essential to set DBFlags to 0 while setting Update Table Stats on Purge to 1. Because only if the DbFlags allows statistics update, the purge process can update statistics.


At what frequency PRCSYSPURGE process runs?
PRCSYSPURGE process runs based upon the frequency and options set in the below navigation:
PeopleTools > Process Scheduler > System Settings > System Purge Options


Security Setup required to run PSRCSYSPURGE Process:
  1. The PRCSYSPURGE program is delivered with the TLSALL process group. The user running the purge process must have access to the process group TLSALL within the primary process profile.
  2. The user running the process is attached to the 'ProcessSchedulerAdmin' role.
  3. The user running the process is attached to the 'ReportDistAdmin' role.
  4. The Oprid must have the "Can start Application Server" permission assigned i.e. this permission list along with the TLSALL process group be attached to the user through any of the roles assigned to him/her.
  5. The Oprid must have a valid Process Profile and Primary Permission List.

To find out all the OPRIDs having access to run PRCSYSPURGE program, use the below SQL statement:
SELECT c.oprid
FROM   ps_prcsdefngrp a,
       psauthprcs b,
       psoprcls c
WHERE  a.prcstype = 'Application Engine'
       AND a.prcsname = 'PRCSYSPURGE'
       AND a.prcsgrp = b.prcsgrp
       AND b.classid = c.oprclass


Security Setup to run PRCSYSPURGE process:
1)      Navigate to PeopleTools -> User Profiles
2)      Search and Select the Oprid for which access needs to be given.
3)      Navigate to the Roles tab and add a new row.
4)      Assign the "ProcessSchedulerAdmin" role.
5)      Add another new row and assign the "ReportDistAdmin" role.
6)      Add another new row and assign the "PeopleSoft User" role.
7)      Add another new row and assign the "PeopleTools" role.
8)      Now go to the General tab and note the Process Profile value.
9)      Save the component.
10)  Now go to the navigation: PeopleTools > User Profiles > Permissions & Roles
11)  Select Permission Lists and search for the Permission List noted in Step 8.
12)  On the General tab, select the "Can Start Application Server?" checkbox.
13)  Select the Process tab and in the "Process Group" link enter a new value: "TLSALL".
14)  Hit Ok to return to the previous page and Save.

Configuration Steps to run PRCSYSPURGE purge program:
  1. Define report nodes for all active process schedulers.
  2. Configure Master Scheduler as a Master Scheduler must run for the purge process to run.
  3. Ensure that the user ID that starts the process scheduler is included in a process group for PRCSYSPURGE. The PRCSYSPURGE program is delivered with the process group TLSALL.
  4. Configure the System Purge Options page.
  5. Enable Purge.

1 comment:

  1. Hi, I want to delete PSREOPRTS Older than 1 Year , What retention days should I specify and where ?
    As I see there is hierarchy how this Expiration Days are selected.

    ReplyDelete

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month