Deletion of old studies - Successfully delete "null" on Storage

[Jose Manuel Rodriguez]

Hi,
We have configured one of our dcm4chee Pacs (release 5.31.1) to purge studies 95 days after they are archived but the studies aren't purged.

We use a S3 storage system (Scality).

There are no errors in the purge logs but we find a lot of "Successfully delete null on Storage" messages.

Normally, we should see a study identifier to be purged butd not the "null" value.

Purge logs,

2024-01-04 08:26:51,462 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,463 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,463 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,464 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,464 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,465 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,467 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,467 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
2024-01-04 08:26:51,468 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]

Our settings,
"No Deletion Constraint" is False
"Deletion Threshold" is empty
"Delete Studies Received Before" is set to P95D
"Purge Storage Polling Interval" is set to PT5M
"Storage Duration" is set to TEMPORARY

Is there something wrong with the configuration?

Could the problem be due to the use of S3 storage?

Thank you for your help

[Jose Manuel Rodriguez]

Problem solved!

Several old studies were inconsistent. Deleting these studies (Reject Study + Permanent Delete) has unblocked the purging mechanism which was looping indefinitely on these studies.

I identified the studies concerned by temporarily setting the log level of the org.dcm4chee.arc.delete package to DEBUG via the wildfly console.

It was thanks to these logs that I realised that the purge mechanism was looping indefinitely on 9 studies.

Here is an example of the logs for one of these studies (study.pk=37400),

2024-01-09 06:43:21,184 DEBUG [org.dcm4chee.arc.delete.impl.DeletionServiceEJB] (EE-ManagedExecutorService-default-Thread-28) Query for objects of Study[pk=37400]
2024-01-09 06:43:21,184 DEBUG [org.dcm4chee.arc.delete.impl.DeletionServiceEJB] (EE-ManagedExecutorService-default-Thread-28) No objects of Study[pk=37400] found
2024-01-09 06:43:21,184 INFO [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-28) Successfully delete null on Storage[id=scality, uri=...]
...


Best regards

[Marius S]

Hello,

I have the same problem with dcm4chee-arc-psql:5.31.2-secure

I have identified the Study pk=xx, it seems there are two studies.

I have found studies using Study Instance UID in DCM4CHEE UI and selected Reject Study, then Permanently delete Rejected Studies.

I have restarted DCM4CHEE arc, however it still finds these studies and tries to delete them in the loop..

2024-06-27 14:44:46,297 DEBUG [org.dcm4chee.arc.delete.impl.DeletionServiceEJB] (EE-ManagedExecutorService-default-Thread-20) Query for objects of Study[pk=291]
2024-06-27 14:44:46,300 DEBUG [org.dcm4chee.arc.delete.impl.DeletionServiceEJB] (EE-ManagedExecutorService-default-Thread-20) No objects of Study[pk=291] found
2024-06-27 14:44:46,301 INFO  [org.dcm4chee.arc.delete.impl.PurgeStorageScheduler] (EE-ManagedExecutorService-default-Thread-20) Successfully delete null on Storage[id=fs1, uri=file:///storage/fs1/]

There are some records in series and instance tables by this study_fk=xx

Do I need to manually delete all entries in database?

Thanks,

M.