FilesystemMgt Deleter issues

Deleter configured to work automatically?

Either ScheduleStudiesForDeletionInterval not NEVER and/or ScheduleStudiesForDeletionOnSeriesStored = true.

Deleter will check free disk space?

DeleterThresholds must not be NONE and have an adequate value.

Study ONLINE Lifetime?

DeleteStudyOnlyIfNotAccessedFor attribute is responsible for how long a study have to be ONLINE.
The value is dependent on online disk space and expected data volume.

Deleter criterias?

Which criterias are enabled? (all enabled criteria must be fulfilled)
Are all basic conditions for the criterias configured correctly?
(e.g. DeleteStudyOnlyIfExternalRetrieveable: Forward Service, Storage Commitment)

Logger level must be INFO

Ensure that 'org.dcm4chex.archive.mbean' and/or 'org.dcm4chex.archive.mbean.FileSystemMgt2Service' has at least INFO level
org.dcm4chex.archive
org.dcm4chex.archive.mbean
org.dcm4chex.archive.mbean.FileSystemMgt2Service

A 'Operation completed successfully without a return value.' result message means, that no logger level is set for this category and the level of the parent will be applied!

Message 'Check file system group .. for deletion of studies' does not exist?

Check ScheduleStudiesForDeletionInterval attribute in ONLINE_STORAGE FilesystemMgt service to be not NEVER.

Message 'Try to free ... of disk space on file system group ... ' does not exist?

Most likely the UsableDiskSpace is NOT below CurrentDeleterThreshold.
Set DeleterThreshold according to your needs.

Message 'Scheduled ... studies for deletion on file system group ...' does not exist?

• Any Transaction / Rollback Exceptions ?
  Try to reduce batch size (ScheduleStudiesForDeletionBatchSize) and/or increase DeleteStudyOnlyIfNotAccessedFor (to limit DB query)

• DCMEE-1275 (Deleter stops processing when the first collection of studies doesnt match delete criteria.) Issue?

SQL examples shown here are for oracle DBS!

By enabling DEBUG logger level for 'org.jboss.ejb.plugins.cmp' (log4j service in jmx-console) you can find the queries of the deleter in server.log,

Find studies on filesystemgroup not accessed since NUM_DAYS

Set NUM_DAYS to corresponding value of DeleteStudyOnlyIfNotAccessedFor (one hour can be expressed as 1/24)

Result of last statement is empty?

• Check configuration values

• Simply all studies are to young to die!

• STUDY_ON_FS entries are missing!
  This may happen if a study is scheduled for deletion but not deleted (Deletion and all subsequent retries failed or DeleteOrders are removed from deleter queue (e.g. removeAllMessages() )

  SELECT DISTINCT study.pk, files.filesystem_fk FROM study, series, instance, files WHERE study.pk=series.study_fk AND series.pk=instance.series_fk AND instance.pk=files.instance_fk AND NOT EXISTS(SELECT study_on_fs.pk FROM study_on_fs WHERE study_on_fs.study_fk=study.pk);

  In this case the missing STUDY_ON_FS entries must be added manually:

  INSERT INTO study_on_fs (PK, STUDY_FK, FILESYSTEM_FK, ACCESS_TIME) VALUES (<PK>,<STUDY_PK>,<FILESYSTEM_FK>,(sysdate - <NUM_DAYS>));

  <PK>...new study_on_fs.pk using auto numbering! e.g. Oracle: study_on_fs_pk_seq.nextval

Check deleter criteria

In general all combinations of deleter criteria can be configured and act in conjunction (logical AND).
There is one exception: DeleteStudyOnlyIfStorageNotCommited and DeleteStudyOnlyIfExternalRetrieveable are mutually exclusive!