E-FTP: PSPTFILE_PRCS Table Not Getting Purged
(Doc ID 2276330.1)
Last updated on AUGUST 03, 2023
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
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.
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