My Oracle Support Banner

E-FTP: Receiving error "DoPurgeOrphans (error): no row found in last purge datetime table" on PT 8.54 (Doc ID 1949098.1)

Last updated on DECEMBER 14, 2021

Applies to:

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


Issue statement:

User gets kicked out when trying to view or upload file attachment. The session ends and the user receives a new tab stating: "An error has occurred".

Tools version:
PT 8.54


1) Signon to the PIA
2) Navigate to People Tools>Utilities>Debug>People Tools Test Utilities page
3) Try to add and then view a file.
4) The session ends.

This can also be reproduced using a FTP server

When running a PeopleCode and SQl trace the following error will appear inside the trace:

0621 04.28.18    0.000000 Cur#1.1884.FSDV1 RC=0 Dur=0.000000 COM Stmt=SELECT LASTUPDDTTM FROM PSPTFX_LSTPURGE
PSAPPSRV.1884 (825)      1-320622 04.28.18    0.001000 DoPurgeOrphans (error): no row found in last purge datetime table.


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

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