Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Failed to read (x) attachments while migrating from Server to Cloud

Hello Everyone,

I am creating this article to address a very common issue related to the migration of spaces using Confluence Cloud Migration Assistant aka CCMA: Failed to read XYZ attachments.

You might have come across an issue when migrating spaces from Server/DC to Cloud using CCMA, where some attachments are failing to read and the migration of space fails.

Very common reasons why attachments cannot be found in server/DC:

  • Either the file has been deleted manually OR,

  • There was an error in removing the record of the attachment from Confluence.

 

Here are some of the steps you should follow after a failed migration because of missing attachments:

Option 1:

  • You can follow this article to resolve missing attachments before doing another migration.
  • It may happen that there are no results of the script following the above step, in that case, move to option 2.

 

Option 2:

  • Verify if there attachments that are causing the missing attachment issue but can’t be found in the pages. These are attachments that were deleted in confluence and the files are not physically found in the system.

-- -- Select attachments with 'DELETED' in CONTENT_STATUS column

SELECT CONTENTID FROM CONTENT INNER JOIN SPACES ON CONTENT.SPACEID = SPACES.SPACEID WHERE SPACES.SPACEKEY = 'YOUR_SPACE_KEY' AND CONTENTTYPE = 'ATTACHMENT' AND CONTENT_STATUS = 'DELETED')

If there are any results to the above query, run the below query to delete those missing attachments:

DELETE FROM MIG_ATTACHMENT WHERE ATTACHMENTID IN (SELECT CONTENTID FROM CONTENT INNER JOIN SPACES ON CONTENT.SPACEID = SPACES.SPACEID WHERE SPACES.SPACEKEY = 'YOUR_SPACE_KEY' AND CONTENTTYPE = 'ATTACHMENT' AND CONTENT_STATUS = 'DELETED')

You will need to delete attachments from previously failed migration. CCMA adds an entry in the MIG_ATTACHMENT table but sets the mediaId to NULL Those entries need to be deleted. Use the query below.

DELETE FROM MIG_ATTACHMENT WHERE mediaId IS NULL and cloudId = 'XXXXX’

If still, you run into the same issues, raise a support ticket with the Migrations team from https://support.atlassian.com

3 comments

Is there a similar procedure for Jira migration to Cloud?

Like Saif likes this
Saif Atlassian Team Apr 14, 2021

Hi @Rodolfo Romero ,

Regarding attachments failure with the plugin Jira Cloud Migration Assistant, it could be any reason and cannot be concluded without checking logs

For a detailed investigation, I would recommend creating a ticket with us from https://support.atlassian.com and we will surely help you solve the issue. Make sure you provide us the logs generated by the plugin and the support zip filesmile

Thanks,

Saif

Like SriKumar P likes this
SriKumar P Atlassian Team Apr 26, 2021

Good Article @Saif , It really helps customers to self serve themselves. 

 

Thank you,
- Sri 

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Atlassian Cloud Migration

Cloud migration resources roundup: April 2021

...enefit is best! And don’t forget about the tried and true! Cloud Migration Center   - central hub for all things Atlassian Migration Program. Includes links to our full resources page, s...

392 views 3 10
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you