5 Replies Latest reply on Oct 27, 2016 9:41 AM by Bill Robinson

    Delete depot_object

    Laurent Noel

      We are in 8.2
      We executed the job "Cleanup_Database_Weekly" and we thought that the job had deleted the rows in the table "depot_object" where the column "is_deleted" is 1.

      ADM-Cleanup_Retention-S1F0

       

      • Delete executeRetentionPolicy

       

      ADM-Cleanup_Database_Weekly-S1F0

       

      • Delete cleanupDatabase

       

      ADM-Cleanup_HardDeleteAll-S1F0

       

      • Delete hardDeleteAllSharedObjects

       

      ADM-Cleanup_FileServer-S1F0

      • Delete cleanupFileServer

       

      But unfortunately the rows are always in the database.

      For example :

       

      select name, is_deleted from depot_object where name = 'PA-S2I-FABI21-G01R00C10.tar';

       

      NAME       IS_DELETED
      ---------------------------------------------
      PA-S2I-FABI21-G01R00C10.tar         1
      PA-S2I-FABI21-G01R00C10.tar         1
      PA-S2I-FABI21-G01R00C10.tar   1

       

      Have you got an idea ?

       

      Thanks