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

hirok August 11, 2017

 

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. 

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 11, 2017

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 August 11, 2017

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.

Suggest an answer

Log in or Sign up to answer