Attachment not found error

On the ticket itself, I am seeing two attachments but yet when I click on the attachment, it's no longer there. I checked teh file system and confirm that those 2 folders are not there but I cannot find anything in the activity stream that someone remove those 2 files. The admins on the FS is limited to me and my supervisor, and we clearly did not know how this happened.

The question I have is why the files are showing up on the ticket when the file is no longer there. Is the only possible reason is due to someone manually removing the file?

Any help is greatly appreciated!

2 answers

0 votes
Janet Albion Atlassian Team Jun 19, 2012

Hi Eva,

If the files does exist in the JIRA_HOME/data/attachments/PROJECT_KEY/ISSUE_KEY , it is expected for JIRA to throw error since it can't find it. To confirm if the database is indeed correct, you can run SQL query to double confirm if the issue has attachment associated to it :

SELECT * FROM fileattachment where issueid in (SELECT ID FROM jiraissue where pkey='ISSUE_KEY');

If the association does exist, I do suspect that the files are removed manually.

Good Luck.

-Janet

I already use that SQL before posting the question and saw that there is connection to that ticket with that attachment. The only thing I can think of is that this ticket had been moved by someone before, from one project to another. Would moving ticket cause this problem to occur?

0 votes
Janet Albion Atlassian Team Jun 20, 2012

Eva,

Moving issue normally not causing this problem. The attachment normally moved together with the issue to another ticket.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,075 views 13 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot