CDM Data Center | Error when accessing Workflow Template due to duplicate workflow IDs

Problem

When accessing the Workflow Template screen via Space Tools > Document Management > Document Management Dashboard, users encounter the following error:

A metric named type=metrics,category00=bandana,name=persister,tag.contextKey=_GLOBAL,tag.key=com.comalatech.workflow.template.<WORKFLOW_ID_NAME>,tag.operation=retrieve already exists

This issue occurs because two workflow templates were created with the same ID, resulting in duplicate entries in the bandana table. This corrupts the workflow retrieval process and prevents access to the affected templates.

Solution

Take a full database backup before making any changes.

Follow these steps to resolve the issue:

Step 1: Identify corrupted workflow entries

Run the following SQL query on your Confluence database:

select * from BANDANA b where BANDANAKEY = 'com.comalatech.workflow.template.<WORKFLOW_ID_NAME>'

Review the results.
If any rows return WORKFLOW_MARKUP as <null/>, they are corrupted entries.

Step 2: Delete the corrupted entries

Use the following SQL command for each corrupted record:

DELETE FROM bandana
WHERE bandanakey = 'com.comalatech.workflow.template.<WORKFLOW_ID_NAME>'
  AND bandanacontext = '_COMALATECH';

Step 3: Restart and verify

Restart the Confluence Data Center instance.
Verify that the Document Management Dashboard loads successfully.