User and groups are not migrated to the new cwd tables upon upgrade

Still need help?

The Atlassian Community is here for you.

Ask the community


While upgrading JIRA from a version prior 4.3 to a newer version, users and groups are not migrated to the new Crowd embedded tables (cwd_*) causing the login to fail.

No specific errors appear in the atlassian-jira.log


The root cause of this issue is usually related to a previous failed upgrade and the database was not totally restored to the original state before the upgrade attempt.


Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.

  1. Shutdown JIRA instance;
  2. Execute this query and take note of the 'id' value;

    SELECT * FROM propertyentry e, propertystring n WHERE = AND e.property_key = 'jira.version.patched'
  3. Update the table propertystring with build number '589' using the following statement;

     UPDATE propertystring SET propertyvalue = '589' WHERE id = <ID_from_previous_query>
  4. Restart JIRA;

(info) If JIRA is integrated to LDAP, be sure that the osuser.xml  file which contain the LDAP settings is located into '$JIRA_INSTALL/atlassian-jira/WEB-INF/classes' before restart the instance.

Last modified on Feb 26, 2016

Was this helpful?

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