Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-33669

Usernames in the projectroleactor table are not lower-cased

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 6.0.5
    • 6.0.2
    • None

      After performing a JIRA upgrade, the project role is not appear correctly due to the migration didn't lower-case the projectroleactor:

      select project.pkey, projectroleactor.* from projectroleactor
  inner join project on projectroleactor.pid = project.id
where roletypeparameter = 'A223089';

      PKEY,ID,PID,PROJECTROLEID,ROLETYPE,ROLETYPEPARAMETER
THAT,79084,18561,10001,atlassian-user-role-actor,A223089

      As you can see from the above user has a role in the project.

      The user exists as lower case:

      select * from cwd_user where lower_user_name = 'a223089';

      ID,DIRECTORY_ID,USER_NAME,LOWER_USER_NAME,ACTIVE,CREATED_DATE,UPDATED_DATE,FIRST_NAME,LOWER_FIRST_NAME,LAST_NAME,LOWER_LAST_NAME,DISPLAY_NAME,LOWER_DISPLAY_NAME,EMAIL_ADDRESS,LOWER_EMAIL_ADDRESS,CREDENTIAL,DELETED_EXTERNALLY
31737,3,A223089,a223089,1,"2013-02-07 07:25:00","2013-02-07 07:25:00",User,user,"Something Else","something else","User Something Else","user something else",user.something@atlassian-com,user.something@atlassian-com,NULL,NULL

      The username in projectroleactor should be in lower case.

      Workaround

      1. Shut down JIRA
      2. Run the following database query 
        update projectroleactor 
  set roletypeparameter = lower(roletypeparameter)
  where roletype = 'atlassian-user-role-actor'

        this query was developed and tested on Oracle database, you may tune up the query to suits your database. It will work on MySQL as well.

      3. Restart JIRA
      4. Run the full indexing

      Make sure you have the latest JIRA backup before proceed with the steps below.

            edalgliesh Eric Dalgliesh
            vkharisma vkharisma (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: