Why I cannot preview but only download pdf file?

Nicolas Casel

In a wiki page, when I click on a link to a PDF file, the preview is not working:

pdf-preview.png

 

However, I can download the PDF file and it is available in the page attachments list.

Any idea about how to restore the preview?

image2016-6-4 6:16:57.png

image2016-6-4 6:22:39.png

image2016-6-4 6:23:13.png

image2016-6-6 18:3:2.png

pdf-text.png

image2016-6-4 6:21:37.png

pdf-preview.png

image2016-6-6 18:4:13.png

Damien Braz

Hi Nicolas,

 

Here is Confluence Doc:

 

Observed issues are with PDF type attachments, JPEG and PNG images

The following appears in the atlassian-confluence.log

 

 

2015-02-17 07:48:56,813 ERROR [conversion-thread-3-internal] [conversion.impl.runnable.ConversionRunnable] doWork Format cannot be converted


 -- referer: http://testserver:8090/display/TS/Incident+and+Problemmanagement?preview=/17663912/17795772/How To Code In Java.pdf | url: /rest/documentConversion/0.1/conversion/convert/17795772/1 | userName: tester

 

Diagnosis

1. A newly inserted attachments can be previewed by clicking on its link.
2. The file itself is downloadable

Diagnostic Steps

• Try to replicate this in all browsers
  1. Navigate to an existing page that has PDF Attachment link embedded
  2. Click on the PDF link
• Generate a HAR file and check when clicking on the old attachment link. Instead of getting the 'Resource', a 'HEAD' is returned when the command "byAttachmentIds" and "minusAttachmentIds" are sent

• Run the following SQL query:
  • If there are rows returned, please continue to the Resolution section. If it returns empty result, you are not being affected by the issue in this article. Please contact Atlassian Support to assist you.
    

 

SELECT * FROM CONTENTPROPERTIES WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%pdf%';

SELECT * FROM CONTENTPROPERTIES WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%pjpeg%';

SELECT * FROM CONTENTPROPERTIES WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%x-png%';

 

Cause

The Content Type of the attachments are wrong

• PDF Attachment isnot 'application/pdf' as how it should be, instead the Content Type is either in one of this format; 'pdf', 'image/pdf' or 'application/x-pdf'. 
• JPEG images isnot 'image/jpeg' as how it should be, instead the Content Type is either in one of this format; 'image/pjpeg'. 
• PNG images isnot 'image/png' as how it should be, instead the Content Type is either in one of this format; 'image/x-png'. 

These values are already invalid before performing the upgrade.

For more information please refer to  CONF-36666 - Unable to Preview PDF Attachment Link Due to Wrong MEDIA_TYPE After Upgrade RESOLVED .

Resolution

Run the following SQL query:

• For issues with PDF:

   

  UPDATE contentproperties SET STRINGVAL = 'application/pdf' WHERE PROPERTYNAME = 'MEDIA_TYPE' AND STRINGVAL LIKE '%pdf%';

   

• For issues with JPEG images:

   

  UPDATE contentproperties SET stringval = replace(stringval, 'image/pjpeg', 'image/jpeg') WHERE PROPERTYNAME = 'MEDIA_TYPE';

   

   

• For issues with PNG images:

   

  UPDATE contentproperties SET stringval = replace(stringval, 'image/x-png', 'image/png') WHERE PROPERTYNAME = 'MEDIA_TYPE';

• Flush your Confluence caches by navigating through Confluence Administration Panel >> Cache Management >> Flush All.

 

Best Regards, Damien.