Duplicate ActivityDefinition Resources Prevent Processes From Being Executed

[hhund]

Description

Duplicate ActivityDefinition resources (as in the same url and version) prevent processes from being executed. Task resources with status requested can not be created, if a corresponding ActivityDefinition resource exists with the same url and version more than once.

Effected DSF Version

• 1.6.0

Expected Behavior

Duplicate ActivityDefinition resources (as in the same url and version) should not exists on the DSF FHIR server.

Logs

FHIR:

2024-10-22 13:10:08,638 [jetty-server-715] WARN  dev.dsf.fhir.service.ReferenceResolverImpl - Found 2 matches for reference at Task.instantiatesCanonical with url '<some url>|<some version>'
2024-10-22 13:10:08,638 [jetty-server-715] WARN  dev.dsf.fhir.help.ResponseGenerator - Reference target <some url>|<some version> of reference at Task.instantiatesCanonical in resource of type Task with id null not found
2024-10-22 13:10:08,638 [jetty-server-715] INFO  dsf-audit-logger - Create of resource Task for user '<some user>' failed, status: 403 Forbidden

with for example:
<some url> = http://medizininformatik-initiative.de/bpe/Process/feasibilityExecute
<some version> = 1.0

Workaround

To check if there are duplicate ActivityDefinition resources in the DSF FHIR server database execute in /opt/fhir:

docker compose exec db psql -U liquibase_user fhir -c "select concat(activity_definition->>'url','|',activity_definition->>'version') as url, count(concat(activity_definition->>'url','|',activity_definition->>'version')) from current_activity_definitions group by url having count (concat(activity_definition->>'url','|',activity_definition->>'version')) > 1;"

To delete duplicate ActivityDefinition resources from the DSF FHIR server database execute in /opt/fhir:

docker compose exec db psql -U liquibase_user fhir -c "delete from activity_definitions where activity_definition_id in (select a.activity_definition_id from current_activity_definitions a, current_activity_definitions b where concat(a.activity_definition->>'url','|',a.activity_definition->>'version') = concat(b.activity_definition->>'url','|',b.activity_definition->>'version') and a.activity_definition_id > b.activity_definition_id);"