Error uploading Cloud Backup

[Kunjan Sanghavi]

I am new to JIRA and I am trying to migrate my JIRA cloud to JIRA Server.

I have my local JIRA running and when I try to restore the back up I am getting below error.

I am using SQL Server 2014 Database engine, and databse uses SQL_Latin1_General_CP437_CI_AI collation.

Unexpected error occurred during import: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ApplicationUser][lowerUserName,sjacobi2][id,10020][userKey,SJacobi] (SQL Exception while executing the following:INSERT INTO dbo.app_user (ID, user_key, lower_user_name) VALUES (?, ?, ?) (Cannot insert duplicate key row in object 'dbo.app_user' with unique index 'uk_user_key'. The duplicate key value is (SJacobi).))

[Alexey Matveev · Accepted solution]

Hello,

It means that you have a duplicate key value for SJacobi. Extract your backup. Open the entities.xml file. Find one of the users with the SJacobi value and delete the line with this user. Then compress the files back and restore this backup.