Issue Summary

The issues/projects are exported as CSV with attachments. However, when the CSV is imported using the "External System Import" option, the thumbnails of all the attachments fail to load even after a successful import.

This is reproducible on Data Center: (yes) / (no)

Steps to Reproduce

1. Create a test issue and add pictures as attachments. The thumbnails are shown!
2. Export this issue as CSV by using the Export option through the Issue Search page
3. Delete the issue
4. The attachments automatically be removed from storage (<Jira_home>/data/attachments) and the "fileattachment" database table.
5. Import the CSV file from the "External System Import" option under Administration > System
6. Make sure you map the "Attachment" and "Summary" fields during the import process.
7. Run through the import process. The import will be successful.
8. Check the Issues, attachments will be loaded without the thumbnails
9. The files and folder will be recreated and the thumbs folder will have the correct thumbnails.

Expected Results

1. Attachments are exported with the ID as they are numbered in the database and as well as the folder structure
2. The IDs change when they are imported to the same instance or any other
3. Jira should either use the old id that comes along with the CSV file OR map the new ID's correctly in the "fileattachment" table

Actual Results

The below exception is thrown in the atlassian-jira.log file:

2022-04-01 13:43:29,901+0530 http-nio-48204-exec-4 ERROR anonymous 823x1451x1 - 127.0.0.1 /secure/attachment/10000/WhatsApp+Image+2022-03-29+at+9.16.24+PM.jpeg [c.a.j.w.servlet.viewfile.AbstractViewFileServlet] Error finding /10000/WhatsApp+Image+2022-03-29+at+9.16.24+PM.jpeg : 10000
2022-04-01 13:43:29,902+0530 http-nio-48204-exec-4 WARN   -   [c.a.j.w.action.util.Error404] Detected anonymous access to page <http://localhost:48204/j8204/secure/attachment> redirecting to login page
2022-04-01 13:43:29,952+0530 http-nio-48204-exec-2 ERROR anonymous 823x1453x1 1xnnba0 127.0.0.1 /secure/attachment/10001/WhatsApp+Image+2022-03-29+at+9.17.37+PM.jpeg [c.a.j.w.servlet.viewfile.AbstractViewFileServlet] Error finding /10001/WhatsApp+Image+2022-03-29+at+9.17.37+PM.jpeg : 10001

Screenshot before export

Screenshot after import

Workaround

Currently, one can update the database values to the correct ids of the images. However, this seems vague while there are more images.

The article below does not help in such scenarios. Setting the "thumbnailable" to NULL will again be set to 0 when the issue is viewed in the Jira UI.

• Attachment thumbnails not displaying after Jira server migration