My Oracle Support Banner

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

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


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