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 MAY 17, 2017

Applies to:

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

Symptoms


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

Steps:
---------

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.

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