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

Images are broken and not displaying correctly on Cloud instance after migrating from on-premise

XMLWordPrintable

      Issue Summary

      After migrating from on-premise to Cloud, large images of more than 4,000,000px (Dimensions: 2500 × 1600) doesn't render properly in pages on Cloud.

      The error that we see on the UI for these images is:

      This image is too large to apply effects. Please make it smaller (less than 4,000,000px in total dimensions) and try again.
      

      Steps to Reproduce

      1. Migrate spaces containing pages with images of more than 4,000,000px from server to cloud.
      2. Try to open these pages on Cloud Confluence

      Expected Results

      The image should be displayed as it was being displayed on server confluence.

      Actual Results

      Large images replaced with an unreadable error message on the UI:

      If we reduce the zoom ratio of the browser, we are able to read the message as mentioned in the issue summary.

      Workaround

      Workaround 1:

      • Run below SQL on the on-premise to get all the pages in which there are large images which has effects enabled on them.
        select 
        	spaces.spacename, parent_content.title AS "Page Title", content.title AS "Image Title",
                i.height, i.width, i.height * i.width AS "Pixels Size",
               ROUND(contentproperties.longval/1024/1024, 2) AS "file_size (MB)"
        from 
        	content 
        	inner join contentproperties on content.contentid = contentproperties.contentid
        	inner join content parent_content on content.pageid = parent_content.contentid
        	inner join spaces on content.spaceid = spaces.spaceid
        	inner join bodycontent on content.pageid = bodycontent.contentid
                inner join imagedetails i on content.contentid = i.attachmentid
        where 
        	content.contenttype = 'ATTACHMENT'
        	and contentproperties.propertyname = 'FILESIZE'
        	and parent_content.content_status = 'current'
        	and content.prevver is NULL
        	and bodycontent.body like '%ac:image ac:queryparams="effects=%'
        	and contentproperties.contentid in (select contentproperties.contentid from contentproperties where stringval like 'image%')
                and i.height * i.width >= 4000000
        order by contentproperties.longval desc;
        
      • After the migration, go to Cloud instance, and open the pages in edit mode, click on the broken image in edit mode and choose "Properties" then remove the effect (change it to none instead of having a border).

      Workaround 2:
      This issue is only affecting the legacy editor. So the conversion of the page to the new editing experience would solve the issue.

      Workaround 3:
      Reduce the dimension of the image to 4,000,000px or less (ie, Dimensions: 2500 × 1600 or less) and reupload the picture on the existing editor after removing the current one. The issue won't be faced anymore.

              hyee@atlassian.com Harry Yee (Inactive)
              13f27f9b2775 Jagriti
              Votes:
              5 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: