Customfield not in Jira but orphaned in database

Heiko
Contributor
July 4, 2024

Hello,

an export of "Configuration Manager for Jira" throw  errors, because customfields did not exist anymore.

- Unable to find Jira object of type 'Custom field' with identifier 'customfield_10600'
- Unable to find Jira object of type 'Custom field' with identifier 'customfield_10506'

But in table "customfield" I can find this fields 

customfield.jpg

In Jira I can find 153 custom fields, in database there are 155 customfields listed.

So, how can I delete this hidden customfields completely?

Thanks!
Heiko

1 answer

0 votes
Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 4, 2024

@Heiko 

Did you run an indexing after deleting the fields?

Best,

Fadoua

Heiko
Contributor
July 4, 2024

Yes, more than often a full-index ;-)

Like Fadoua likes this
Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 5, 2024

Did you try @Heiko  to run some JQLs to make sure that the fields are gone?I do see that you have 153 in your Jira Instance but you see 155 in the DB

Heiko
Contributor
July 5, 2024

Yes, I can't find the fields with JQL.customfields_search.jpg

 

I can list the 153 customfields 

customfields.jpg

And in database

customfields_db.jpg

So in Jira the fields seems to be hidden.

Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 5, 2024

@Heiko 

May be you will need to re-create the fields. Make them visible then run the custom fields optimizer to make sure which screens are using the 2 fields, run queries against the DB before you decide to delete them from the UI

Best,

Fadoua 

Heiko
Contributor
July 9, 2024

This does not work, because Jira set up a new field with a new ID.

And the type "ru.mail.jira.plugins.todolist:todo-list-custom-field" is not available in Jira? Maybe it is a very old field in our instance and created with a app which is not present anymore?

I want to delete the ophaned data of the two missing fields manually. Where are the data stored to this fields?

1. table customfield
2. table customfieldoption
3. customfieldvalue
4. ???

Best regards
Heiko

Like Michel KATZ likes this
Michel KATZ August 8, 2024

Hello,

Same issue for old custom fields type 'es.excentia.jira.plugins.jira-issue-picker-custom-field-type-plugin:issue-cf'.

(Jira datacenter)

I see them in the DB, but not in Jira admin.

 

Same question, how to remove  those ophaned data without risk ? (via API or in DB)

Br,

 

Michel

 

Heiko
Contributor
August 13, 2024

Hi Michel,

I removed the field in DB directly. Otherwise I could not remove the field.

Don't forget to create a backup before! ;-)

Best regards
Heiko

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
9.12.10
TAGS
AUG Leaders

Atlassian Community Events