Page restrictions dialog box does not pop up
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Symptoms
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.
The following appears in the atlassian-confluence.log:
1
2
3
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]Cause
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.
Resolution
Find those users that have orphaned permissions
1
2
3
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
1 2DELETE FROM content_perm WHERE username = <user_name>Remove Everything.
1 2 3DELETE 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.
Was this helpful?