Summary

The following document provides guidance on migrating Questions for Confluence app using the Confluence Migration Assistant (CCMA) tool.

Background

Questions for Confluence app can be migrated using the Confluence Migration Assistant tool (CCMA). The support for this feature was introduced through MIG-106.

In cases where there is a partial or incomplete migration of this application, re-migration poses a challenge as there is no export/import tool available on the cloud. A feature request has been submitted to introduce export/import functionality for this application; however, it has not been implemented on the cloud yet.

The following runbook will help to mitigate potential issues during migration. Additionally, the knowledge base will also share some known limitations. 

Recommended Steps for Migration of App:

During the migration process, Questions for Confluence app will generate content on behalf of the end users. So users who generate Questions and Answers on the server should have permissions on the cloud side too. 

Please follow the prerequisite steps as defined below before initiating migration. 

• App re-install on cloud
  Questions for Confluence application need to be registered with the app migration platform to receive migration events. As a pre-requisite, we have to install the app in the cloud. But if the app was already installed in the past, we recommend re-installing the app. The installation/re-installation will register cloud instances with the migration platform to receive migration notifications. 

• Product access for migrated users and groups
  Make sure that migrated users and groups have proper Confluence product access. If migrated users and groups don't have valid Confluence access.

• Migrate with All Users/Groups and Spaces options.
  If you want to migrate all the questions, then make sure to initiate CQ migration with all users/groups and space options. Otherwise, CQ content will migrate for only selected users/groups and spaces. 

• Avoid cqmigrationuser
  Please DO NOT USE cqmigrationuser Make sure you de-activate/disable cqmigrationuser from the server and cloud. Going forward, CQ will use the app System account to migrate data on behalf of deactivated users.

• Migration of comments
  Make sure migrated users and groups have permission to add comments. Especially in the CQ space (Questions for confluence)

• Migration of attachments
  Make sure migrated users and groups have permission to add attachments. Especially in the CQ space (Questions for confluence)

Known issues and FAQs

These are the current known defects/limitations with migration of questions for confluence app

FAQs

WITH QUESTIONS AS (
  SELECT S.SPACEKEY AS SPACE_KEY
       , S.SPACENAME AS SPACE_NAME
       , COUNT(*) AS QUESTION_COUNT
    FROM CONTENT C
    LEFT JOIN SPACES S ON S.SPACEID = C.SPACEID
    WHERE C.PLUGINKEY = 'com.atlassian.confluence.plugins.confluence-questions:question'
    GROUP BY S.SPACEKEY, S.SPACENAME
),
ANSWERS AS (
  SELECT S.SPACEKEY AS SPACE_KEY
       , S.SPACENAME AS SPACE_NAME
       , COUNT(*) AS ANSWER_COUNT
    FROM CONTENT C
    LEFT JOIN SPACES S ON S.SPACEID = C.SPACEID
    WHERE C.PLUGINKEY = 'com.atlassian.confluence.plugins.confluence-questions:answer'
    GROUP BY S.SPACEKEY, S.SPACENAME
)
SELECT Q.SPACE_KEY, Q.SPACE_NAME, Q.QUESTION_COUNT, A.ANSWER_COUNT FROM QUESTIONS Q
LEFT JOIN ANSWERS A ON A.SPACE_KEY = Q.SPACE_KEY
GROUP BY Q.SPACE_KEY, Q.SPACE_NAME, Q.QUESTION_COUNT, A.ANSWER_COUNT
ORDER BY Q.QUESTION_COUNT DESC;