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!
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:
Note
icon
false
title
Selected attributes:
DeleteStudyOnlyIfExternalRetrieveable=true
Code Block
sql
sql
SELECT COUNT(i.pk) FROM instance i, series, study
WHERE i.series_fk = series.pk AND study_fk = study.pk AND series.study_fk = <STUDY_PK> AND i.ext_retr_aet IS NOT NULL;
must be equal to
Code Block
sql
sql
SELECT num_instances FROM study WHERE pk = <STUDY_PK>;
Panel
Copy of Study available on Filesystemgroup:
Check configuration: Copy service, (HSM if archived status is needed).
Look for Exceptions
Check in DB:
Info
icon
false
title
All Instances of study must be also available on 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;
Info
icon
false
title
All Instances of study must be also available on NEARLINE_STORAGE Filesystem group *with* _ARCHIVED_ status:
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;
Info
icon
false
title
All Instances of study must be also available on a *read-only* Filesystem in READONLY_STORAGE Filesystem group:
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
Code Block
sql
sql
SELECT num_instances FROM study WHERE pk = <STUDY_PK>;
Panel
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):
Note
icon
false
title
Selected attributes:
DeleteStudyOnlyIfCopyOnMedia=true
Code Block
sql
sql
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
Code Block
sql
sql
SELECT num_instances FROM study WHERE pk = <STUDY_PK>;