After upgrade the embedded images are missing ???

[Tushar Mohite]

After Upgrade of Confluence Version from 4.2.3 to 5.4.4. manually the images attached to particular page of particular space is not visible .

Before upgrade 

image2015-9-14 16:22:29.png

As shown in above screen the images are attached to the page .

After Upgrade :

image2015-9-14 16:21:28.png

As shown in the above screen the attached image is not available .

When clicked on that image get following error :

image2015-9-14 16:28:51.png

Note : Attachment Storage Location is Confluence configured database (MS SQL)

I checked using <confluence-home>/admin/findspaceattchments.jsp , it is showing the path of <confluence-home>/attachment/... but if i check the attachment folder it is found to be empty??

image2015-9-14 16:42:39.png

As per the above screen image is visible.But download/attachment folder it is found to be empty .

Due To Missing images

image2015-9-14 16:40:56.png

How to find and recover the attachment stored in the Database???

How to resolve this issue ??

Reply as soon as possible .

[lavitz slambert]

If you have a backup of your database prior the upgrade, yes (would involve some database sorcery as described in the guide eduardo provided), if you don't have that then nope as those lines containing the information might be corrupted or lost during the upgrade process  (sorry for delivering the bad news).

What I would advise you is to migrate the attachments to file system instead using the database storage that was decommissioned by atlassian.

Thanks and Regards,

Lavitz - the guy that uses Confluence on Windows as a Hobby!

[Mallmann]

Hi Tushar,

In case of missing attachments we can start by trying two things:

1. Re-indexing of the instance from scratch: https://confluence.atlassian.com/display/CONFKB/Rebuild+the+Content+Indices+from+Scratch
2. Following this KB about missing attachments: https://confluence.atlassian.com/display/CONFKB/How+to+resolve+missing+attachments+in+Confluence

Can you please try the first solution to see if that helps, and if it doesn't, try the second one?

Let us know if you can see any improvement in there afterwards.

Eduardo

[Tushar Mohite]

Is there any way resolve missing attachments with database Storage????