Profile Picture Missing After an Upgrade
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
After an upgrade, Users' profile picture are missing.
Diagnosis
Run the following SQL query in Confluence Database:
SELECT * FROM OS_PROPERTYENTRY WHERE ENTITY_KEY = 'confluence.user.profile.picture';If the result of the above query is similar to as follows:
ENTITY_NAME;ENTITY_ID;ENTITY_KEY;KEY_TYPE;BOOLEAN_VAL;DOUBLE_VAL;STRING_VAL;LONG_VAL;INT_VAL;DATE_VAL
OSUser_usera;0;confluence.user.profile.picture;5;0;0;usera-47837-pp-img_0793.jpg;0;0;See this Bug Ticket: CONF-22298 - Getting issue details... STATUS
If the result of the above query is similar to as follows:
ENTITY_NAME;ENTITY_ID;ENTITY_KEY;KEY_TYPE;BOOLEAN_VAL;DOUBLE_VAL;STRING_VAL;LONG_VAL;INT_VAL;DATE_VAL
CWD_UserA;0;confluence.user.profile.picture;5;0;0;usera-47837-pp-img_0793.jpg;0;0;Proceed to Workaround
Cause
Part of the Confluence database, in the table: OS_PROPERTYENTRY might not be updated.
| Confluence Version | OS_PROPERTYENTRY Schema for the Column "entity_name" |
|---|---|
| Below 3.5 | OSUser_<username> |
| 3.5 | CWD_<username> |
| 5.2 | USERPROPS-<userkey> |
There are possibilities that the upgrade task was somehow corrupted.
Workaround
Go to the URL:
<Confluence Address>/admin/force-upgrade.action- Select "embeddedCrowdPropertSetFactoryMigrationUpgradeTask"
- Selet Force Upgrade
Please backup your database before performing the above
Should the above workaround does not solve the issue, it is recommended to rollback to previous version and redo the upgrade again, preferably by using the standalone installer. Use the documentation to rollback to your pre-upgraded state Confluence:
How to roll back to a previous version of Confluence