Why I cannot preview but only download pdf file?

Nicolas Casel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 2, 2016

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?

4 answers

1 accepted

1 vote
Answer accepted
Damien Braz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 2, 2016

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%20To%20Code%20In%20Java.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.

2 votes
TimC May 11, 2018

Hmmm... just ran into this error in the Cloud instance of Confluence for PNG images that were working fine, but after I did an in-place update to one image ("Edit with... Preview (the Mac App). Make a change. Save. Update Confluence. See it on the page. Click PNG to see it larger... and boom. Error. 

In fact, now all images on the page are not preview capable and must download. That's crappy. 

I'm certainly not able to run SQL to check the DB for Cloud Confluence... and all steps I did were above...nothing crazy. 

 

My Answer: Atlassian needs to review the process with us to find the regression bug that's causing the problem and fix Confluence.

genevievecory August 1, 2018

Same issue, also in a Cloud Confluence. I don't know who changed what but it's everywhere.

Like # people like this
samuelcenaokediji January 13, 2020

 I experience this same issue myself. 

0 votes
Robert Ortner June 3, 2016

try a different browser

 

Nicolas Casel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 3, 2016

Same result on IE, FF and Chrome.

Like Deleted user likes this
0 votes
Rodney Hughes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 2, 2016

apart from checking the file type itself, I think it is MUCH simpler than all that....

in edit mode of the page, as you hover your mouse over the link text, you will see it gives a pop up that says "show as thumbnail"  - that toggles to "show as link"

Nicolas Casel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 3, 2016

I do not want to display the file 'thumbnail' but some text (pdf file name let's say).

By the way, this workaround does not work, the thumbnail is empty and clicking on it displays the same "error" message.

Rodney Hughes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 3, 2016

it should work - contact your system admin?!?!?! - here is a test page on our system with two PDF tests

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

Rodney Hughes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 3, 2016

and here is another "interactive" PDF page using "Insert>Other Macros> PDF   you can click the arrows at the bottom to move through the PDF smile or click the download button bottom left

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

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

 

 

Nicolas Casel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 5, 2016

Thanks @Rodney Hughes

However, the PDF macro displays the  content of the PDF file (like your 2nd screenshot), and in my case I want to display a link like this:

pdf-text.png

Rodney Hughes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 5, 2016

when you insert a link to a file (not the interactive PDF macro), you can choose whether to display the file as a link or as a thumbnail

In the Edit mode, if it is showing as a thumbnail, just click or hover the mouse over the thumbnail and a pop up box will appear which toggles as below

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

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

 

 

Nicolas Casel
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 5, 2016

Ok, but as I've already written above:

the thumbnail is empty and clicking on it displays the same "error" message.

Rodney Hughes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 6, 2016

try another PDF - you may have a corrupt file format

Like Deleted user likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events