My Oracle Support Banner

E-FTP: PSPTFILE_PRCS Table Not Getting Purged (Doc ID 2276330.1)

Last updated on JUNE 15, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, File Attachments

PSPTFILE_PRCS table not getting purged after upgrading to 8.55.12 and Purge orphan files Job Failed with below errors and reported in APPSRV.log

PSAPPSRV.4584 (1240) [FileAttach](3) File: /vob/peopletools/src/pspcm/pcmeweb.cppSQL error. Stmt #: 22268 Error Position: 0 Return: 1795 - ORA-01795: maximum number of expressions in a list is 1000

Failed SQL stmt: DELETE FROM PSPTFILE_PRCS WHERE GUID IN (

PSAPPSRV.8623 (396) 1-260139 10.05.02 0.065194 CheckAndPurgeForPSPTFILE_PRCS (error): SamExec failed while getting count of orphan rows in table, "PSPTFILE_PRCS", before purge.

PSAPPSRV.11999 (885) [FileAttach] 5Bohpb04SSGj2g - EXPLOIT (1)CheckAndPurgeForPSPTFILE_PRCS (error): SamExec failed for purge of orphan files from table, "PSPTFILE_PRCS".

PSAPPSRV.11999 (885)  [FileAttach] 5Bohpb04SSGj2g - EXPLOIT (1) PcmPurgeOrphans (error): attempt to purge orphan files (files over 20 minutes old) from temporary storage table was failed.

PSAPPSRV.8623 (396) 1-260141 10.05.02 0.000015 PcmPurgeOrphans: attempt to purge orphan files (files over 20 minutes old) was completed but was only partially successful.

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
Cause
Solution
References


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