Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

Does anyone know where the "Last Source File Processed" is stored?

Originally posted by Laura Garcia

3/31/2020

Does anyone know where the "Last Source File Processed" is stored? Is it possible to clear this file as a one-off? Client copied their Prod app to Dev and they are clearing out some HR data and also want to remove the last load file that contains this data too.

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    Originally posted by Ryan Connors

    A workaround to clear it out would be to just load a file with headers. This will clear out the old file and show a blank file when they click the ""Last Source File Processed"" button.

    Both the log file and the last loaded source file are stored in the application database table titled ""StageArchivesInformation"". Both the log file and source file are stored in one record in this table for a given workflow (WF Key), scenario (scenario key), and time (time key). They could run a query off this table and delete the source and log file remnants if they'd like!