Details
-
Bug
-
Resolution: Fixed
-
Medium
-
6.0.2
-
None
-
6
-
Description
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
- Shut down JIRA
- 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.
- Restart JIRA
- Run the full indexing
Make sure you have the latest JIRA backup before proceed with the steps below.
Attachments
Issue Links
- is duplicated by
-
JRASERVER-33730 After upgrade Project Roles went missing when JIRA integrate with LDAP
- Closed
-
JRASERVER-34008 ProjectRole Migration from 5.1.3 to 6.1-m03
- Closed
- is cloned from
-
JRADEV-22456 Loading...
- mentioned in
-
Wiki Page Loading...