JIRA Crashes while Creating an Issue
The following error appeared while creating a JIRA issue:
The following appears in the
The root cause is still unknown. Past cases indicates that this problem happens only after upgrading to JIRA 4.2.x with the previous JIRA versions having a Multi User Picker custom field with an invalid default value of the custom field.
Here are the following steps on how to fix this problem:
Run the following SQL queries to find out the problematic custom field:
Which should return results like the following:
GENERICCONFIGURATION.datakey = FIELDCONFIGSCHEME.id
With this information above, run the next SQL query below:
Run the next SQL statement:
FIELDCONFIGSCHEME.fieldid = CUSTOMFIELD.id
- This means that even without creating issue to replicate this problem, this problem can be seen by just going to Notify Issue to custom field (
cfname) which is a Multi User Picker custom field type and clicking on 'Edit Default Value' will throws the same error as well.
- Try creating a similar custom field of 'Multi User Picker' and set the default value by putting in all the list of users shown above from the SQL query result to compare the default XML value of the problematic and non-problematic custom field.
Execute the same SQL query as in Step 1 (select * from genericconfiguration where XMLVALUE like '%UnmodifiableRandomAccessList%';) - spot the difference below:
Compared with the non-problematic:
Fix this problem by updating the default content of the custom field:
GENERICCONFIGURATION.id = 10335
If upgrading to JIRA 5.1 and after you can alternatively use the below SQL as custom fields are stored differently. The above SQL will work as well.
- Restart JIRA in order for it to take effect.
Take note to perform a full data backup first before proceeding with database modification.
Was this helpful?
Thanks for your feedback!