-
Bug
-
Resolution: Fixed
-
Low
-
3.5, 3.5.1, 4.0
-
None
Summary
After upgrading to Confluence 3.5 or higher, where the user property migration (e.g. com.atlassian.confluence.user.migration.AtlassianUserDataMigrator#migrateUserProperties or com.atlassian.user.util.migration.OSUCrowdEntityMigrator#migratePropertySet) won't happen/called during the upgrade which is expected for the following scnearios:
.....user settings (confluence.user.*) in OS_PROPERTYENTRY table will be lost such as:
- Profile picture
- Default setting of editor (wikimarkup/RTE)
- User site home page
- Login details
- etc.
Possible Cause
The upgrade process does not migrate the respective entities in OS_PROPERTYENTRY table. They are no more taken into account due to different structure - previously the entity_name is OSUser_user (and entity_id set to JIRA's userbase.id) and now is CWD_username (entity_id set to 0).
- Mismapped OS_PROPERTYENTRY entries of JIRA users
+---------------+-----------+---------------------------------------------+----------+-------------+------------+-------------------------------------+----------+----------+---------+---------------------+ | entity_name | entity_id | entity_key | key_type | boolean_val | double_val | string_val | text_val | long_val | int_val | date_val | +---------------+-----------+---------------------------------------------+----------+-------------+------------+-------------------------------------+----------+----------+---------+---------------------+ | OSUser_user | 10000 | confluence.user.last.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-04-12 03:45:37 | | OSUser_user | 10000 | confluence.user.previous.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-04-12 03:42:12 | | OSUser_user | 10000 | confluence.user.profile.picture | 5 | | 0 | /images/icons/profilepics/dude1.gif | | 0 | 0 | NULL | | OSUser_user | 10010 | confluence.user.last.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-04-12 03:42:22 | | OSUser_user | 10010 | confluence.user.previous.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-03-18 21:26:59 | | OSUser_user | 10010 | confluence.user.profile.picture | 5 | | 0 | stylesheets.jpg | | 0 | 0 | NULL | | OSUser_user | 10011 | confluence.user.last.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-03-18 21:27:54 | | OSUser_user | 10011 | confluence.user.previous.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-03-17 21:36:41 | | OSUser_user | 10011 | confluence.user.profile.picture | 5 | | 0 | jbb-95295-pp-ochenklogo.jpg | | 0 | 0 | NULL | +---------------+-----------+---------------------------------------------+----------+-------------+------------+-------------------------------------+----------+----------+---------+---------------------+
- New structure:
+---------------+-----------+---------------------------------------------+----------+-------------+------------+-----------------------------------------+----------+----------+---------+---------------------+ | entity_name | entity_id | entity_key | key_type | boolean_val | double_val | string_val | text_val | long_val | int_val | date_val | +---------------+-----------+---------------------------------------------+----------+-------------+------------+-----------------------------------------+----------+----------+---------+---------------------+ | CWD_adminconf | 0 | confluence.user.keyboard.shortcuts.disabled | 1 | | 0 | NULL | | 0 | 0 | NULL | | CWD_adminconf | 0 | confluence.user.last.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-04-12 04:03:42 | | CWD_adminconf | 0 | confluence.user.previous.login.date | 7 | | 0 | NULL | | 0 | 0 | 2011-04-12 04:00:38 | | CWD_adminconf | 0 | confluence.user.profile.picture | 5 | | 0 | /images/icons/profilepics/Avatar-15.png | | 0 | 0 | NULL | | CWD_adminconf | 0 | confluence.user.site.homepage | 5 | | 0 | ds | | 0 | 0 | NULL | | CWD_adminconf | 0 | confluence.user.time.zone | 5 | | 0 | Asia/Kuala_Lumpur | | 0 | 0 | NULL | | CWD_adminconf | 0 | confluence.user.whats.new.dont.show.version | 5 | | 0 | 3.5 | | 0 | 0 | NULL | +---------------+-----------+---------------------------------------------+----------+-------------+------------+-----------------------------------------+----------+----------+---------+---------------------+
Form Name |
---|
[CONFSERVER-27834] OS_PROPERTYENTRY User Property Settings Lost after Upgrade to Confluence 3.5 with JIRA User Management
Workflow | Original: JAC Bug Workflow v3 [ 2875278 ] | New: CONFSERVER Bug Workflow v4 [ 3003725 ] |
Workflow | Original: JAC Bug Workflow v2 [ 2803274 ] | New: JAC Bug Workflow v3 [ 2875278 ] |
Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
Workflow | Original: JAC Bug Workflow [ 2736155 ] | New: JAC Bug Workflow v2 [ 2803274 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389357 ] | New: JAC Bug Workflow [ 2736155 ] |
Labels | Original: affects-server bugfix dev_bugfix_backlog loyalty team-ants | New: affects-server dev_bugfix_backlog loyalty team-ants |
Labels | Original: affects-server bugfix dev_bugfix_backlog team-ants | New: affects-server bugfix dev_bugfix_backlog loyalty team-ants |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 2267035 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389357 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2210526 ] | New: Confluence Workflow - Public Facing - Restricted v5 [ 2267035 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2196917 ] | New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2210526 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 1909983 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2196917 ] |