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.
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.