Project Import Fails - The custom field ‘XXXX ’ requires option ‘XXXX’ for the import but it does not exist in the current JIRA instance.

We are performing the JIRA Consolidation running on same version of JIRA 7.2.2

Using the Project Configurator plugin, we exported the project configuration from 'A' JIRA instance and imported into the 'B" JIRA instance. Then, were able to export the XML backup from 'A' JIRA instance and imported each project into the 'B" JIRA instance. Almost all Projects were imported successfully.

However, we are encountering issues with Only two Projects.

Error Message:

1 -

The custom field 'Complexity' requires option 'L' for the import but it does not exist in the current JIRA instance. 
The custom field 'Complexity' requires option 'M' for the import but it does not exist in the current JIRA instance.
The custom field 'Complexity' requires option 'None' for the import but it does not exist in the current JIRA instance.
The custom field 'Complexity' requires option 'S' for the import but it does not exist in the current JIRA instance.

2 - The custom field 'Department Code' requires option '5128' for the import but it does not exist in the current JIRA instance. 
The custom field 'Department Code' requires option '5134' for the import but it does not exist in the current JIRA instance.

We verified the custom field configuration and options and everyting looks similar to the 'A' JIRA instance. 

We even changed the Custom field context to Globally in both the 'A' (Source) and 'B' (Target) instances.

We are still facing the same issue,

Can you help us identify the root cause to fix this issue ?

 

Thanks,

Kiran.

2 answers

0 vote

I've seen this a couple of times.  I'm not sure if it's a bug.   Could you physically check the complexity and department code fields in the target JIRA - not check that "everything looks similar", but actually check for the missing options?

Hi @Nic Brough [Adaptavist],

We verified that both the custom fields have same options in both source and target.We also tried changing the target custom field options to match with that of source field, but no luck. We are unable to figure out what is causing the issue. Could you please mention what could be other causes?

Thanks so much!!

-Swathi

No, that's not what I asked.

Please check the options in the target JIRA are there in the option lists for the fields.  The source JIRA is irrelevant.

Hi Kiran,

As you have created also an issue at Project Configurator issue tracker, I am answering there and include a link here to that issue.

You are welcome!

For convenience, I will copy here the analysis of this problem and a way to fix it. Please see more details at the issue tracker.

There is a bug in JIRA project data restore functionality that produces this error if, at the source database, a custom field configuration scheme is associated to a custom field configuration and both of them do not have the same ID. You could check if this is happening in your case running this query on the source database:

select * from fieldconfigschemeissuetype where fieldconfigscheme!=fieldconfiguration

If this query returns any row, then those are candidates to suffer that problem. Taking the value from the fieldconfiguration column in those rows (let us say it is XXXX) you can run these queries:

select * from fieldconfiguration where id=XXXX
select * from customfieldoption where customfieldconfig=XXXX

The first will show you the impacted custom field configuration (whose name usually contains a reference to the custom field name). The second query willl show impacted options, so that you can verify if they are the same options that appear in the error messages in this case.

This can be fixed changing the source data, so that those 4 custom field configurations have the same id as their parent custom field configuration scheme. You could do it on the source database directly, or editing the exported .zip file (this is certainly safer, if anything goes wrong the source database would still be intact).

 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

172 views 0 4
Read article

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