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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,917 views 19 22
Read article

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