Confluence pages cannot be copied, if it contains a Comala document management workflow
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
If a Confluence page contains a workflow created using Comala document management workflow, the copy operation of this page might throw an error and the operation will fail.
Environment
Confluence 8.5.7
Diagnosis
During the copy operation, the server will log the following errors in the logs.
1
2
3
4
5
6
7
8
9
2024-03-21 10:37:42,209 ERROR [http-nio2-8090-exec-1274 url: /confluence/500page.jsp; user: xxxxx] [atlassian.confluence.status.SystemErrorInformationLogger] logException Unhandled exception d32c3044-9aac-455d-a8ca-8bf594bf72cb: Cannot create new content property: JsonContentProperty{id='null', key='comalaworkflowparameters', content=CollapsedReference{idProperties={version=CollapsedReference
{idProperties=\{number=1}, referentClass=class com.atlassian.confluence.api.model.content.Version}, status=draft, id=ContentId{id=2918226095}}, referentClass=class com.atlassian.confluence.api.model.content.Content}, version=null}
-- traceId: ad835ad6d9959d94
com.atlassian.confluence.api.service.exceptions.ConflictException: Cannot create new content property: JsonContentProperty{id='null', key='comalaworkflowparameters', content=CollapsedReference{idProperties={version=CollapsedReference{idProperties={number=1}
, referentClass=class com.atlassian.confluence.api.model.content.Version}, status=draft, id=ContentId{id=xxxx}}, referentClass=class com.atlassian.confluence.api.model.content.Content}, version=null}: [SimpleMessage
{key='jsonproperty.duplicate.key', args=\[], translation='null'}Cause
This is due to a duplication of some rows in the database in the content tables, related to the Comala app.
Solution
Disable “Comala Document Management WorkflowParameters JCP Updater“ scheduled job (only if CDM version is lower than 7.3.0 or CDC and CDA versions are lower than 2.1.0)
Running the following SQL query will get you the ids of all the affected pages by this problem (in the PAGEID column, but some might appear more than once):
1
2
3
4
5
6
7
8
9
10
11
SELECT *
FROM content AS c
JOIN bodycontent AS b ON c.contentid = b.contentid
WHERE c.contenttype = 'CUSTOM' AND c.title = 'comalaworkflowparameters' and c.pageid in (
SELECT c.pageid
FROM content AS c
JOIN bodycontent AS b ON c.contentid = b.contentid
WHERE c.contenttype = 'CUSTOM' AND c.title = 'comalaworkflowparameters'
GROUP BY c.pageid
HAVING COUNT(*) > 1
)For each of the different page ids retrieved from the SQL before you must execute the following 2 curl commands (or call to that REST endpoint using another method) taking into account they have to replace the following elements:
USER → user name to login and perform the action
PASSWORD → user password to login and perform the action
CONFLUENCE_HOST → the hostname of your Confluence instance
PAGE_ID → the page id where to perform the action
1
2
curl -i -u USER:PASSWORD -X DELETE "http://CONFLUENCE_HOST/rest/api/content/PAGE_ID/property/comalaworkflowparameters"
curl -i -u USER:PASSWORD -X DELETE "http://CONFLUENCE_HOST/rest/api/content/PAGE_ID/property/comalaworkflowsworkflowparameterscurrentmodelversion"Was this helpful?