How to Check Whether the Mark-Deletion Job Has Finished Successfully

This article is connected to Asset Deletion which is the current default. With PostgreSQL, Asset Deletion 2 has to be used. This article does not describe Asset Deletion 2.

Short description of the following content

One part of our 3 steps deletion process is the "Mark Asset Version for Deletion". This command creates the trash symbol to the asset versions as configured in version management in censhare Admin Client.
This is a guide how to check whether the mark-deletion job has finished successfully.

Important hints

This Article is only valid for AssetDeletion2.

The command configuration for mark-deletion can be found in: 'censhare-Admin/Configuration/Modules/Asset Deletion/Mark Asset Version for Deletion (automatic)'.
The mark-deletion command by default is running daily at:
<cron pattern="0 4 * * *"/>

Step by Step guide

This check can only be done in the censhare server log.
Logon to the censhare Server via terminal.
Switch to the corpus user.
Change into the directory '~/work/logs'.
Now you can search the server logs for the "completed all" message of the mark deletion command:

CODE

grep "asset_deletion.mark-deletion completed all" server-0.*

The result of the grep-command should looks like that:

CODE

server-0.3.log:2011.11.21-14:34:12.151 INFO   : T008: CommandExecutor: tr.20111121.143412.150[system]: asset_deletion.mark-deletion completed all in 0ms
server-0.65.log:2011.10.27-05:33:55.660 INFO   : T034: CommandExecutor: tr.20111027.053354.000[system]: asset_deletion.mark-deletion completed all in 19ms
server-0.66.log:2011.10.26-23:30:56.597 INFO   : T037: CommandExecutor: tr.20111026.053526.676[system]: asset_deletion.mark-deletion completed all in 49660ms

The first entry shows a restart of the command during a refresh configuration (with censhare Admin Client).
The second entry shows the start of the command during the server startup.
The third one is the successful scheduled run. You can identify the scheduled run by the duration time.
This third entry shows that the run has finished successfully.

Check marked Assets in the database

Please note that this part needs database access and knowledge how to make SQL queries.
This SQL statement shows you the sum of all Assets, including all Versions, which are marked for deletion in your system:

CODE

select count(*) from asset where deletion = 1;