Attachment not found error

Question

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!

Janet Albion · Answer

Eva,

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

Eva8 · Answer

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?

Janet Albion · Answer

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