FilesystemMgt Deleter issues

Simple query: (select of all FS groups!)

SELECT * FROM study_on_fs WHERE access_time < (sysdate - <NUM_DAYS>) AND rownum < 10;

Query of studies stored on ONLINE_STORAGE Filesystems:

SELECT * FROM study_on_fs, filesystem WHERE filesystem.pk = study_on_fs.filesystem_fk
AND filesystem.fs_group_id = 'ONLINE_STORAGE'
AND access_time > (sysdate - <NUM_DAYS>) AND rownum < 10;

As used by deleter:

SELECT * FROM STUDY_ON_FS t0_sof, SERIES t2_s, FILESYSTEM t1_sof_fileSystem, STUDY t7_sof_study
WHERE ((t1_sof_fileSystem.fs_group_id = 'ONLINE_STORAGE' AND t1_sof_fileSystem.fs_status IN (0, 1)
AND t2_s.series_status = 0 AND t0_sof.filesystem_fk=t1_sof_fileSystem.pk))
AND t7_sof_study.pk=t2_s.study_fk AND t0_sof.study_fk=t7_sof_study.pk AND t0_sof.access_time < (sysdate - <NUM_DAYS>);

Study External retrieveable:

• Check configuration: Forward service, StorageCommitment activated (RequestStorageCommitFromAETitles attribute in QueryRetrieveScp service).
• Look for Exceptions, check C_MOVE, C_STORE and N_ACTION if all worked as expected.
• Check in DB:
  All Instances of study must be external retrieveable:

  Selected attributes: DeleteStudyOnlyIfExternalRetrieveable=true

  SELECT COUNT(i.pk) FROM instance i, series, study
  WHERE i.series_fk = series.pk AND series.study_fk = <STUDY_PK> AND i.ext_retr_aet IS NOT NULL;
  

  must be equal to

  SELECT num_instances FROM study WHERE pk = <STUDY_PK>;
  

Copy of Study available on Filesystemgroup:

• Check configuration: Copy service, (HSM if archived status is needed).
• Look for Exceptions
• Check in DB:

  All Instances of study must be also available on NEARLINE_STORAGE: Selected attributes: DeleteStudyOnlyIfCopyOnFileSystemOfFileSystemGroup=NEARLINE_STORAGE SELECT count(DISTINCT t0_i.pk) FROM instance t0_i, files t3_f, series t5_i_series, study t1_i_series_study, filesystem t2_f_fileSystem WHERE (((t1_i_series_study.pk=<STUDY_PK>) AND t2_f_fileSystem.fs_group_id = 'NEARLINE_STORAGE' AND t0_i.series_fk=t5_i_series.pk AND t5_i_series.study_fk=t1_i_series_study.pk AND t3_f.filesystem_fk=t2_f_fileSystem.pk)) AND t0_i.pk=t3_f.instance_fk;

  All Instances of study must be also available on NEARLINE_STORAGE Filesystem group with ARCHIVED status: Selected attributes: DeleteStudyOnlyIfCopyOnFileSystemOfFileSystemGroup=NEARLINE_STORAGE DeleteStudyOnlyIfCopyArchived=true SELECT count(DISTINCT t0_i.pk) FROM instance t0_i, files t3_f, series t5_i_series, study t1_i_series_study, filesystem t2_f_fileSystem WHERE (((t1_i_series_study.pk=<STUDY_PK>) AND t2_f_fileSystem.fs_group_id = 'NEARLINE_STORAGE' AND t3_f.file_status = 2 AND t0_i.series_fk=t5_i_series.pk AND t5_i_series.study_fk=t1_i_series_study.pk AND t3_f.filesystem_fk=t2_f_fileSystem.pk)) AND t0_i.pk=t3_f.instance_fk;

  All Instances of study must be also available on a read-only Filesystem in READONLY_STORAGE Filesystem group: Selected attributes: DeleteStudyOnlyIfCopyOnFileSystemOfFileSystemGroup=READONLY_STORAGE DeleteStudyOnlyIfCopyOnReadOnlyFileSystem=true SELECT count(DISTINCT t0_i.pk) FROM instance t0_i, files t4_f, series t3_i_series, study t1_i_series_study, filesystem t2_f_fileSystem WHERE (((t1_i_series_study.pk=<STUDY_PK>) AND t2_f_fileSystem.fs_group_id = 'READONLY_STORAGE' AND t2_f_fileSystem.fs_status = 2 AND t0_i.series_fk=t3_i_series.pk AND t3_i_series.study_fk=t1_i_series_study.pk AND t4_f.filesystem_fk=t2_f_fileSystem.pk)) AND t0_i.pk=t4_f.instance_fk

  must be equal to

  SELECT num_instances FROM study WHERE pk = <STUDY_PK>;
  

Copy of Study available on Media (CD / DVD / ...):

• Check configuration: Media Creation Managment Service (MCMScu) .
• Look for Exceptions, check C-STORE, N_CREATE and N_ACTION communication with Media Creation SCP if all worked as expected.
• Check in DB:
  All Instances of the study must be also available on Media with media status COMPLETED(4):

  Selected attributes: DeleteStudyOnlyIfCopyOnMedia=true

  SELECT count( t0_i.pk) FROM instance t0_i, series t3_i_series, study t1_i_series_study, media t2_i_media 
  WHERE (t1_i_series_study.pk = <STUDY_PK> AND t2_i_media.media_status = 4 
  AND t0_i.series_fk=t3_i_series.pk AND t3_i_series.study_fk=t1_i_series_study.pk 
  AND t0_i.media_fk=t2_i_media.pk)
  

  must be equal to

  SELECT num_instances FROM study WHERE pk = <STUDY_PK>;