Profile Picture Missing After an Upgrade
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
問題
After an upgrade, Users' profile picture are missing.
診断
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
原因
Part of the Confluence database, in the table: OS_PROPERTYENTRY might not be updated.
| Confluence バージョン | 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.
回避策
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:
Confluence の以前のバージョンにロールバックする方法