E-FTP: File Attachment PurgeOrphans job failed with 'ORA-00001: unique constraint' error

(Doc ID 2368230.1)

Last updated on MARCH 01, 2018

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

Files are not getting purged from PSPTFILE_PRCS table during Purge orphan files Job run. Appsrv log reported below errors.

FileAttach] - - - (3) File: /vob/peopletools/src/pspcm/pcmeweb.cppSQL error. Stmt #: 23449 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PSSYS.PS_PSPTFX_LSTPURGE) violated
Failed SQL stmt: UPDATE PSPTFX_LSTPURGE SET LASTUPDDTTM = TO_TIMESTAMP(:1,'YYYY-MM-DD-HH24.MI.SS.FF')
FileAttach] - - - (1) PcmPurgeOrphans (error): update of last purge datetime table failed.
PcmPurgeOrphans (error): update of last purge datetime table failed.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms