CSV import fails with error "Failed to add users to 'Developers' role for the project"

[Vinod_Honnalli]

Hi,

I am trying to import CSV data but it fails everytime with error "java.lang.Exception: Failed to add users to 'Developers' role for the project 'GBIS': Errors: {name=A project role with name 'Developers' already exists.}"

Please find the details log below.

We are in JIRA 7.12.1 version.

I have tried with very few columns in the CSV since this error start appearing , but no luck with import. 

kindly suggest me to resolve this issue.

2020-01-22 15:08:37,076 INFO - Project ExternalProject{id='null', key='GBIS', externalName='null', name='ONE GBIS'} exists and found correctly.
2020-01-22 15:08:37,076 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state
java.lang.Exception: Failed to add users to 'Developers' role for the project 'GBIS': Errors: {name=A project role with name 'Developers' already exists.}
Error Messages: []
at com.atlassian.jira.plugins.importer.external.ExternalUserUtils.addUsersToProjectRole(ExternalUserUtils.java:409)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.setProjectRoles(DefaultJiraDataImporter.java:685)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importProject(DefaultJiraDataImporter.java:667)
at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:369)
at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:458)
at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:426)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
at java.lang.Thread.run(Thread.java:748)
2020-01-22 15:08:37,077 INFO - No issues need to be reindexed.

[Michael Thompson · Accepted solution]

Do you have a group named Developers that is a member of the Developers role for that project? It's possible the importer is getting confused.

[Vinod_Honnalli]

Hi Michael,

We do not have any group with name: Developers.

But, we have project role as DEVELOPERS.

Is it an issue with JIRA Software version?

Please let me know if you need any information from my end.

Regards,

Vinod

[Michael Thompson]

I just found JRACLOUD-72348, which matches your problem. Can you check your CSV file and confirm that "Developers" has been spelled with a capital D? It appears that the importer is confusing the lower case 'developers' with the upper case 'Developers'.

[Vinod_Honnalli]

Hi Michael,

I have not added any columns in excel  for Developers information.

The excel is very simple data with 3-4 columns data.

But we have a project role as "DEVELOPERS" , should i try changing it to "Developers" and import ?

Note: We are using the JIRA software version 7.12.1 (Server Based)

Best Regards,

Vinod

[Michael Thompson]

I would say yes. This sounds like a bug, Jira should not be checking case sensitivity but appears to be doing just that. I think if you match their expected case you should be fine.

[Vinod_Honnalli]

Hi Michael,

It worked fine when i renamed the project role from DEVELOPERS to Developers .

Thanks for your help. Have a Great Day !!!

Regards,

Vinod