More than one value stored for custom field id error during project import to Jira server

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Trying to import a project leads to similar following error in atlassian-jira.log and the importing fails:

2013-04-01 14:30:47,880 IssueIndexer:thread-5 ERROR anonymous 855x17x1 xxxxx 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [issue.customfields.impl.AbstractSingleFieldType] More than one value stored for custom field id 'customfield_11660' for issue 'TEST-2'.  Values [2.5E7, 2.2E8]
2013-04-01 14:30:47,883 IssueIndexer:thread-7 ERROR anonymous 855x17x1 xxxxx 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [issue.customfields.impl.AbstractSingleFieldType] More than one value stored for custom field id 'customfield_11660' for issue 'TEST-3'.  Values [3.125E7, 2.3E8]
2013-04-01 14:30:47,946 IssueIndexer:thread-5 ERROR anonymous 855x17x1 xxxxx 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [issue.customfields.impl.AbstractSingleFieldType] More than one value stored for custom field id 'customfield_11660' for issue 'TEST-12'.  Values [1.225E8, 3.2E8]

Cause

You have encountered the bug reported in JRA-12796 where the customfield_11660 has multiple values in them. The customfield_11660 exist in the Target JIRA instance and may exist in Source XML backup.

Workaround

  • If you happen to encounter the issue while restoring the XML backup and/or doing a Project Import, then you can proceed in following the instructions to the workaround by Ian Daniel in this comment from the bug report.
  • If you happen to encounter the issue while doing a Project Import:
    1. Verify the name of the custom field by running the following SQL query (where the id would is taken from 'customfield_11660'):

      SELECT cfname FROM customfield WHERE id=11660;
    2. Do either of the following:
      1. Remove the custom field via JIRA UI
      2. Rename the custom field via JIRA UI
Last modified on Sep 25, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.