Summary

Migrating users from Delegated LDAP Authentication directory to internal directory is not working.

Steps to Reproduce

1. On a clean instance of JIRA 6.4.8, add a user directory using "Internal with LDAP authentication"
2. Use "Copy User on Logon" checkbox
3. Login with some AD users so that there are some users in the Delegated LDAP directory.
4. Now, logging in as the Internal Directory LDAP user, try to migrate users from "Internal with LDAP authentication" directory to Internal directory.
5. The message comes up : "0 of 2 users successfully migrated."
6. None of the users are migrated and there is nothing in the logs

Expected Results

All users from the delegated directory should get migrated to the Internal directory

Actual Results

The users do not get migrated
There are no errors shown up in the logs.

Workaround

Before proceeding with the workaround, please make a backup of your database so that it is possible to roll back to the original state in case something goes wrong.

1. Run this query in the database :

   update cwd_user set external_id = '' where directory_id = <id of the delegated directory you want to migrate>

   Note : You can get the directory id by hovering over the User directory on the UI and looking at the url for the link.

2. After changing this value, please restart JIRA.
3. Now try to run the migration. This time it should run fine.

Alternative way to reproduce the bug

Another way to reproduce this bug is to create users in the Jira internal directory, and then migrate them to an "Internal with LDAP authentication" directory. When doing that, all the users migrated to the "Internal with LDAP authentication" directory will be automatically given a value in the external_id column. Because of that, such users can't be migrated back to the Jira internal directory, unless this column is cleared for them.