Page restrictions dialog box does not pop up
症状
When any of the three methods to to access the page restrictions dialog box are used the page restrictions dialog box does not pop up.
atlassian-confluence.log
に次のエラーが返される。
ERROR [http-8080-24] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- url: /pages/getpagepermissions.action | userName: xxxxxx | referer: http://confluence.zzzzz.com/display/space_name/page_name
java.lang.IllegalArgumentException: No such user: [yyyyy]
原因
There are users in the content perm table that do not exist in the cwd_user table. This is most likely due to the incorrect deletion of users.
ソリューション
Find those users that have orphaned permissions
SELECT *
FROM content_perm
WHERE username NOT IN (SELECT user_name FROM cwd_user)
Ensure that the users that appear in your list of results should re removed them. Make sure you have a backup of your database before you start removing things
Remove them a user at a time - Preferred solution
DELETE FROM content_perm WHERE username = <user_name>
Remove Everything.
DELETE FROM content_perm WHERE username NOT IN (SELECT user_name FROM cwd_user)
For good measure it is a good idea to flush your browser cache and perform a res-sync on your user directories.