Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-76467

After migration, LiveSearch Macro/ Search by label on the Cloud cannot get the expected pages

XMLWordPrintable

      Issue Summary

      After migration, LiveSearch Macro/ Search by label on the Cloud cannot get the expected pages with labels

      Steps to Reproduce

      1. Migrate a tenant from server to cloud
      2. Open a page with Macro "search by label". The macro isn't show all pages with the labels in the cloud as compared to server/dc.
      3. Run the following SQL query on the tenant. The "owner" fields in the "CONTENT_LABEL" table are null for the migrated labels. 
        select cl.owner, l.name, cl.contentid from CONTENT_LABEL as cl join LABEL as l on cl.labelid=l.labelid where l.name='<label_name>'

      Expected Results

      Macro search by label should show the same number of pages on cloud as compared to server/dc

      Actual Results

      Macro search by label isn't showing all pages with labels in the cloud as compared to server/dc.

      For example, the label "test-label" is not showing list of pages as compared to dc.

      Error message : There is more than one label named 'test-label' in the 'global' namespace.

      Workaround

      There are two workarounds :

      • One workaround is support run a SQL script to set the "owner" field in "CONTENT_LABEL" table after migration.
      • The other workaround is user manually remove the label from the page and add the label back to the page.

       

              tmahule@atlassian.com Tushar Mahule
              ywang2@atlassian.com Ying Wang
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated: