As discussed with James.
I have added work item content to CR1925 in dev and clicked Save:
When I go back into the item, there is no work item profile:
If I try to add the information again, an error is displayed:
Server Error
We're sorry, but the server responded with an error message.
Details
{
"headers": {
"normalizedNames": {},
"lazyUpdate": null
},
"status": 500,
"statusText": "Internal Server Error",
"url": "https://mauro.dev.dataproducts.nhs.uk/api/versionedFolders/e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa/profile/uk.nhs.datadictionary.services.profiles/DDWorkItemProfileProviderService/1.0.0",
"ok": false,
"name": "HttpErrorResponse",
"message": "Http failure response for https://mauro.dev.dataproducts.nhs.uk/api/versionedFolders/e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa/profile/uk.nhs.datadictionary.services.profiles/DDWorkItemProfileProviderService/1.0.0: 500 Internal Server Error",
"error": {
"message": "Internal Server Error",
"_links": {
"self": {
"href": "/api/versionedFolders/e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa/profile/uk.nhs.datadictionary.services.profiles/DDWorkItemProfileProviderService/1.0.0",
"templated": false
}
},
"_embedded": {
"errors": [
{
"message": "Internal Server Error: Error executing PERSIST: Error executing batch SQL UPDATE: Batch entry 0 INSERT INTO \"core\".\"metadata\" (\"date_created\",\"last_updated\",\"created_by\",\"multi_facet_aware_item_domain_type\",\"multi_facet_aware_item_id\",\"namespace\",\"key\",\"value\",\"version\") VALUES (('2026-04-07 11:20:22.521133+00'),('2026-04-07 11:20:22.521133+00'),(NULL),('VersionedFolder'),('e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa'::uuid),('uk.nhs.datadictionary.workItem'),('type'),('Data Dictionary Change Notice'),('0'::int4))\nRETURNING * was aborted: ERROR: duplicate key value violates unique constraint \"idx_metadata_multi_facet_aware_item_id_namespace_key\"\n Detail: Key (multi_facet_aware_item_id, namespace, key)=(e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa, uk.nhs.datadictionary.workItem, type) already exists. Call getNextException to see other errors in the batch."
}
]
}
}
}The work item profile does appear after a while.
James thinks this has something to do with the cache and will investigate.
As discussed with James.
I have added work item content to CR1925 in dev and clicked Save:
When I go back into the item, there is no work item profile:
If I try to add the information again, an error is displayed:
Server Error
We're sorry, but the server responded with an error message.
Details
{ "headers": { "normalizedNames": {}, "lazyUpdate": null }, "status": 500, "statusText": "Internal Server Error", "url": "https://mauro.dev.dataproducts.nhs.uk/api/versionedFolders/e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa/profile/uk.nhs.datadictionary.services.profiles/DDWorkItemProfileProviderService/1.0.0", "ok": false, "name": "HttpErrorResponse", "message": "Http failure response for https://mauro.dev.dataproducts.nhs.uk/api/versionedFolders/e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa/profile/uk.nhs.datadictionary.services.profiles/DDWorkItemProfileProviderService/1.0.0: 500 Internal Server Error", "error": { "message": "Internal Server Error", "_links": { "self": { "href": "/api/versionedFolders/e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa/profile/uk.nhs.datadictionary.services.profiles/DDWorkItemProfileProviderService/1.0.0", "templated": false } }, "_embedded": { "errors": [ { "message": "Internal Server Error: Error executing PERSIST: Error executing batch SQL UPDATE: Batch entry 0 INSERT INTO \"core\".\"metadata\" (\"date_created\",\"last_updated\",\"created_by\",\"multi_facet_aware_item_domain_type\",\"multi_facet_aware_item_id\",\"namespace\",\"key\",\"value\",\"version\") VALUES (('2026-04-07 11:20:22.521133+00'),('2026-04-07 11:20:22.521133+00'),(NULL),('VersionedFolder'),('e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa'::uuid),('uk.nhs.datadictionary.workItem'),('type'),('Data Dictionary Change Notice'),('0'::int4))\nRETURNING * was aborted: ERROR: duplicate key value violates unique constraint \"idx_metadata_multi_facet_aware_item_id_namespace_key\"\n Detail: Key (multi_facet_aware_item_id, namespace, key)=(e6863b3c-4b2f-4daf-bfc8-63dcd997d7fa, uk.nhs.datadictionary.workItem, type) already exists. Call getNextException to see other errors in the batch." } ] } } }The work item profile does appear after a while.
James thinks this has something to do with the cache and will investigate.