Confluence site import failing with error related to duplicated users

XMLWordPrintable

    • 22
    • Severity 3 - Minor

      Summary

      Confluence site import fails. 

      Environment

      • Confluence 1000.1090.1

      Steps to Reproduce

      1. Perform a site import using a Confluence backup (Server or Cloud)

      Expected Results

      The import completes successfully.

      Actual Results

      Following error on logs:

      2017-03-15 17:12:46.639427500 2017-03-15 17:12:46,638 ERROR [Long running task: Importing data] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: duplicate key value violates unique constraint "unq_lwr_username"
2017-03-15 17:12:46.639429500   Detail: Key (lower_username)=(paula) already exists.

          	 msg:	 com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: org.hibernate.exception.ConstraintViolationException: could not execute statement

      If we look for the user on the backup xml, there's only one entry for class="ConfluenceUserImpl".

      Notes

      Workaround

            Assignee:
            Klaus (Inactive)
            Reporter:
            Paula Silveira (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            19 Start watching this issue

              Created:
              Updated:
              Resolved: