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 vote
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 vote
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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

77 views 0 5
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