Error in Backup Service. no project with this id can be found. Returning null for 'key'.

[hirok]

I see so many error messages below in my server log.
I couldn't find any solution for it and I'm stuck.
Could you give me some advice?

2017-08-11 21:07:58,923 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360952) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.
2017-08-11 21:07:58,923 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360953) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.
2017-08-11 21:07:58,923 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360954) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.
2017-08-11 21:07:58,923 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360955) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.
2017-08-11 21:07:58,923 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360956) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.
2017-08-11 21:07:58,923 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360957) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.
2017-08-11 21:07:58,923 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360958) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.
2017-08-11 21:07:58,924 Caesium-1-4 WARN anonymous Backup Service [c.a.jira.ofbiz.IssueGenericValue] Issue (id=360959) has field 'project' of value 10102, but no project with this id can be found. Returning null for 'key'.

When I access following URL, I get an error message which says "There is not a project with the specified id". I think the project was deleted.

https://www.myserver.com/jira/secure/project/EditProject!default.jspa?pid=10102

I'd like to stop those logs. My JIRA server is v7.4.2. 

[Nic Brough -Adaptavist- · Accepted solution]

I think your instinct on what is going wrong is spot on. 

It looks like you have a custom field of type "project picker" and when the project was deleted, the data was not removed

I don't think there's a fix for this without code or poking data into the database.

I'd want to read out the content of customfieldvalue for that value and the custom field, with a view to updating it to an existing project.  If you want rid of the data completely, I suspect it's safe to simply delete the offending rows, but I would take a backup first.

(For any write via SQL, you must have JIRA stopped before you do it, and re-index after restarting it)

[hirok]

Hello Nic,

Thank you for your reply.

I see there is no custom field with "project picker" type for now, but I'm not sure if it was before or not.

I tried to find the issue with that missing project id via SQL and I found there are more than 3 thouthand issues existed with that id. Most of all fields in those issues have null values and nothing updated so I've decided to remove them.

I took a backup and jira is indexing now. I hope the errors go away.

Thanks again for your advice.