Page Comparison

...

Tip

title	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!

Panel

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:

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:

Note

icon	false
title	Selected attributes:

DeleteStudyOnlyIfCopyOnFileSystemOfFileSystemGroup=NEARLINE_STORAGE

Code Block

	sql
	sql

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:

Note

icon	false
title	Selected attributes:

DeleteStudyOnlyIfCopyOnFileSystemOfFileSystemGroup=NEARLINE_STORAGE
DeleteStudyOnlyIfCopyArchived=true

Code Block

	sql
	sql

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:

Note

icon	false
title	Selected attributes:

DeleteStudyOnlyIfCopyOnFileSystemOfFileSystemGroup=READONLY_STORAGE
DeleteStudyOnlyIfCopyOnReadOnlyFileSystem=true

Code Block

	sql
	sql

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>;

Versions Compared

Old Version 30

New Version 31

Key

Study External retrieveable:

Copy of Study available on Filesystemgroup:

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