When using Retrospective template, the Retrospective index page is duplicated.
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
When deploying a retrospective page from the Retrospective template, a duplicated index page is created.
Environment
Confluence Data Center
Diagnosis
When using the template for the first time in a space, Confluence creates the index page and adds a hidden system tag called blueprint-index-page to the page.
To check if the tag is missing, please run the following query:
select * from label a, content_label b
where a.labelid=b.labelid
and b.contentid='<PAGE-ID>' and namespace='com.atlassian.confluence.plugins.confluence-software-blueprints:retrospectives-blueprint';ℹ️ Remember to change the <PAGE-ID> to match the page-id of your Retrospectives page. Please check this KB for info on how to find your page id.
Cause
This usually happens when the index page was copied over from another space or was manually created.
Solution
Solution 1 - Recommended
To fix this, we need to keep the page created by the template, this should have the right tags to avoid future duplicates in this space.
Deploy a new retrospective from the template.
Instead of deleting the duplicated "Retrospectives (2)" page, keep it.
Rename/delete the old "Retrospectives" page.
Rename the new duplicated one "Retrospectives (2)" to Retrospectives.
Solution 2
If you can not change the original page you can manually add the tag to the database.
⚠️ This solution is not supported.
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Go to your Retrospectives page and write down its "Pageid" number.
Now, manually add a label called "blueprint-index-page"
Shutdown Confluence.
Run the following query to update it.
update label set namespace='com.atlassian.confluence.plugins.confluence-software-blueprints:retrospectives-blueprint' from content_label where label.labelid=content_label.labelid and label.name='blueprint-index-page' and content_label.contentid='<PAGE-ID>';Start Confluence
Was this helpful?