Default custom field types disapeared

Hello,

Yesterday I upgraded Jira from 6.0.4 to 6.0.6., and for some reason there was a corruption in the DB. If I enter in Jira to see the custom fields, most of them are gone. Also the basic custom fields types (like multicheckboxes) are gone. I can only see the custom fields that have a custom field type (like 'Colour of Epic' from Jira Agile plugin).

I checked in the DB itself and indeed the custom fields are there, I didn't manage to find any obvious problem in the DB. I searched in the logs and found something like this:

2013-08-29 01:30:18,465 TP-Processor10 ERROR agonzale 90x2350x1 1rpaxf5 137.XX.XX.XX /secure/admin/ViewCustomFields.jspa [jira.issue.managers.DefaultCustomFieldManager] Could not load custom field type plugin with key 'com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes'. Is the plugin present and enabled?

The strange thing is that if I repeat the migration from an old copy of Jira in our developer instance, that has the same code as the production ijnstance, it works just fine. I tried to load several XML backups of JIRA from different points in time and it is very consistent: before migration backups work but after migration backups don't. So I am 95% sure it is not the code or any other file in the file system.

I hope there is a mising magic entry in the DB that I can change to load the com.atlassian.jira.plugin.system.customfieldtypes plugin or something like this.

Cheers

4 answers

1 accepted

This widget could not be displayed.

Hello,

I found the answer.

The trees didn't let me see the forest. The problem was not a corrupted DB at all. The problem was that the migration process disabled the customfieldtypes plugin. So when I went to the Add-ons page, select system plugins and enble the customfieldtypes plugin, everything started to work fine.

I am sorry for the noise, my bad, but if I can do a recomendation for the integrity checker: "It is mislesading that the integrity check says that the custom field doesn't exist, it should take into account the customfieldtype issue and perhaps even activate it or offer that solution to the user".

Anyway thank you very much for your help.

Cheers

This widget could not be displayed.
Ahmad Danial Atlassian Team Aug 28, 2013

Hey there, Alvaro.

Can you try to perform the following steps to see if it can help to retrieve the custom fields that were missing? As you mentioned, the database corruption might have caused this issue to occur. So, let's see if these steps can help:

Give it a try and share the outcome here. Good luck!

Warm regards,

Danial

Hello,

Thank you for your answer. But the problem with that is that I get quite a lot of ERROR lines like this:

ERROR: The field layout item with id 12607 has a reference to the deleted custom field with id customfield_10614. (JRA-4423)

I can click in 'Fix', but that will remove the information in the issues regarding the custom fields, isn't it? So I will lose that information, and this is the opositte of what I want.

Ahmad Danial Atlassian Team Aug 28, 2013

Hey there, Alvaro.

You are welcome. So, we can confirm that there are some inconsistency in your database. Since the custom field is already deleted from the instance, it should not cause any issues as far as I am concerned. Just to be safe, you can also perform an XML backup first before proceeding with the steps.

Warm regards,

Danial

Hello,

I am doing the test in a copy of the production instance. I will let you know. Anyway I am not convinced that this is the answer. My concerns are:

I can not even create new custom fields with the standard custom field types (like datepicker) and I don't see how this solution will fix that.

Also I can see in the customfields table in DB the supposedly deleted custom fields.

Cheers

Ahmad Danial Atlassian Team Aug 28, 2013

Hey there, Alvaro.

Thank you for the clarification. However, we need to ensure that the database is in the consistent state first before proceeding with the rest of the steps. Since you are performinig this on a copy of your production instance, we hope that it will help. Let me know how it goes for you.

Warm regards,

Danial

Hi,

I did the steps, now the integrity checker returns no error, but there is no other improvement. I still cannot see all the custom field types.

Cheers

Hello,

Do you have any other suggestion?

Cheers

Ahmad Danial Atlassian Team Aug 29, 2013

Hey there, Alvaro.

Have you completed the rest of the steps yet? The database integrity checker is only part of the whole process, so I would like to know if you have performed steps 2 - 5? Can you let me know the outcome of it?

Warm regards,

Danial

This widget could not be displayed.

Hello there,

Just few logs that I they can have something to do with the problem:

jira.option.rpc.allow : true

jira.option.timetracking : true

jira.option.user.crowd.allow.rename : false

jira.option.user.externalmanagement : false

jira.option.voting : true

jira.option.watching : true

jira.option.web.usegzip : false

jira.path.attachments : /var/jira-home/data/attachments

jira.path.attachments.use.default.directory : true

jira.path.backup : /var/jira-home/export

jira.path.index.use.default.directory : true

jira.plugin.state-.com.atlassian.jira.plugin.system.customfieldtypes : false

jira.plugin.state-.com.atlassian.jira.plugin.system.renderers.wiki.macros:code : false

jira.plugin.state-.com.atlassian.jira.plugin.system.renderers.wiki.macros:noformat : false

jira.plugin.state-.com.atlassian.jira.welcome.jira-welcome-plugin:show-whats-new-flag : true

jira.plugin.state-.com.atlassian.jira.whatsnew.jira-whatsnew-plugin:show-whats-new-flag : true

jira.project.summary.max.issues : 3

jira.projectkey.description : admin.projects.key.description

jira.projectkey.maxlength : 10

jira.projectkey.pattern : ([A-Z][A-Z]+)

jira.projectkey.reservedwords.list : PRN, AUX, CLOCK$, NUL, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9, CON, LPT1,

LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, LPT9

jira.projectkey.warning : admin.errors.must.specify.unique.project.key

jira.projectname.maxlength : 80

jira.releasenotes.default : Html

This widget could not be displayed.
And more
2013-08-29 16:08:01,963 main INFO [ext.bamboo.service.PlanStatusUpdateServiceImpl] Job 'com.atlassian.jira.plugin.ext.bamboo.service.Pl
anStatusUpdateServiceImpl:job' scheduled to run every 60000ms
2013-08-29 16:08:01,981 main INFO [atlassian.plugin.loaders.ScanningPluginLoader] No plugins found to be installed
2013-08-29 16:08:06,499 main INFO [atlassian.plugin.manager.DefaultPluginManager] Found dependent enabled plugins for uninstalled plugi
n 'remotable.plugins.i18n': []. Disabling...
2013-08-29 16:08:06,500 main INFO [atlassian.plugin.manager.DefaultPluginManager] Updating plugin 'remotable.plugins.i18n' to 'remotabl
e.plugins.i18n'
2013-08-29 16:08:06,501 main INFO [atlassian.plugin.manager.DefaultPluginManager] Disabling remotable.plugins.i18n
2013-08-29 16:08:06,517 main INFO [atlassian.plugin.loaders.ScanningPluginLoader] Removed plugin remotable.plugins.i18n
2013-08-29 16:08:06,950 main INFO [atlassian.plugin.manager.DefaultPluginManager] Returned module for key 'com.pyxis.greenhopper.jira:g
reenhopper-delete-shortcut' was null. Not enabling.
2013-08-29 16:08:06,955 main INFO [greenhopper.plugin.sampledata.JiraImportersPluginInstallerImpl] Checking if jira-importers-plugin is
present and at version 4.4 or higher
2013-08-29 16:08:06,956 main INFO [greenhopper.plugin.sampledata.JiraImportersPluginInstallerImpl] jira-importers-plugin already at 6.0
.18.
2013-08-29 16:08:06,976 main ERROR [jira.issue.managers.DefaultCustomFieldManager] Could not load custom field type plugin with key 'co
m.atlassian.jira.plugin.system.customfieldtypes:select'. Is the plugin present and enabled?
2013-08-29 16:08:06,976 main ERROR [jira.issue.managers.DefaultCustomFieldManager] Could not load custom field type plugin with key 'com.atlassian.jira.plugin.system.customfieldtypes:datetime'. Is the plugin present and enabled?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

47 views 0 1
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you