My Oracle Support Banner

E-PRCS: Master Solution for Process Scheduler Purge (PRCSYSPURGE) Issues (Doc ID 634792.1)

Last updated on DECEMBER 10, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.40 to 8.51 [Release 8.4]
Information in this document applies to any platform.

It applies to PeopleTools releases 8.40-8.50. For a similar document about PeopleTools 8.10-8.22 refer to <>


Checked for relevance on 04-MAR-2013

Symptoms

This is a master resolution for a variety of different issues. Below are listed several scenarios and their corrective actions.

Cause

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
Symptoms
Changes
Cause
Solution
 Case 1: Purge does not remove any rows from the Process Monitor
 Case 2:  Reports are not removed from Report Repository
 Case 3:  Database error encountered: SELECT DAYSBEFOREPURGE FROM PS_PRCSPURGELIST WHERE RUNSTATUS = '9'
 Case 4: PRCSYSPURGE process does not run and the Process Scheduler throws a dump file
 Case 5: Delete is not made to PS_MESSAGE_LOG and PS_MESSAGE_LOGPARM
 Case 6:  Purge is not running
 Case 7:  Process ends in 'No Success'
 Case 8:  Process fails with "No such file or directory" message
 Case 9:  Files not deleted after changing Retention Days value
 Case 10:  Process runs to No Success with "Failed to Initialize JNI" error
 Case 11:  Process runs and contents removed, but not the folder
References

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