attachments metadata are missing from db after merging two jiras

Younes Ouchtouban

Hi,

i had two jira instances (A is running under postgres , B is running under mysql)

i've succeded to  merge  project by project from A to B 

and copied the atachments of A in jira-home/data/attachments of B

the thing is some issues are missing attachments, even though they are existing in file system

i run this sql cmd :

select fa.id, fa.filename, ji.issuenum, p.pkey from fileattachment fa join jiraissue ji on ji.id= fa.issueid join project p on p.id = ji.project WHERE p.pkey = 'project X';

and it was empty

 

any ideas how to make jira recognize (store in db) the attachment refs in the filesystem?

 

Thank you

 

 

Andy Heinzer

How did you import the issues in this case?  Did you use the Jira Project import?  Or did you using another method such as the external CSV import method?

 

Both of these can also import attachments, but there is an expectation that when the Jira issues are imported, that these attachments be in a specified location such as $JIRAHOME/import/ at the time these issues are imported.

Moving the files over into the $JIRAHOME/data/attachments/ directory after the issues are imported won't usually work.

 

If you used the Project import tool in Jira, then step 4 of the import instructions in https://confluence.atlassian.com/adminjiraserver071/restoring-a-project-from-backup-802592982.html#Restoringaprojectfrombackup-projectimportProjectImport

explains that the attachments are expected to be in a certain path at the time of import.

 

I hope this helps.

Andy