Getting a System Error when accessing to Confluence People tab
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
Summary
The Confluence People tab throws a System Error. This error is generally thrown when any content references a missing user in the database.
Diagnosis
While navigating to the People tab below System Error on Confluence UI is rendered as well as in the application logs below logs can be seen.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2023-08-28 13:28:35,779 ERROR [http-nio-8090-exec-11] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- referer: https://xyz.org/ | url: /browsepeople.action | traceId: abcdd09a86e3456 | userName: xyzabc
org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.atlassian.confluence.user.ConfluenceUserImpl#8a7e101821b824031003d]
at org.hibernate.boot.internal.StandardEntityNotFoundDelegate.handleEntityNotFound(StandardEntityNotFoundDelegate.java:28)
at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:244)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:166)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:268)
at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:73)
at com.atlassian.hibernate.adapter.proxy.JavassistLazyInitializer_ImplementV2Proxy.invoke(JavassistLazyInitializer_ImplementV2Proxy.java:70)
at com.atlassian.confluence.user.ConfluenceUserImpl_$$_jvst166_7.getName(ConfluenceUserImpl_$$_jvst166_7.java)
at com.atlassian.confluence.user.PersonalInformation.getUsername(PersonalInformation.java:87)
at com.atlassian.confluence.user.actions.PeopleDirectoryAction.search(PeopleDirectoryAction.java:161)
at com.atlassian.confluence.user.actions.PeopleDirectoryAction.doBrowse(PeopleDirectoryAction.java:130)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)By checking the following query it can help to identify if any content is referencing a missing user in the database
1
SELECT * FROM CONTENT WHERE contenttype = 'USERINFO' AND username NOT IN (SELECT user_key FROM user_mapping);If the above SQL query gives any output, it suggests that some content is referencing missing user(s) in the database.
Cause
The reason for this issue is not clear but this is due to users which does not exist in the database but are having a content referring the user.
Solution
To fix this issue delete the content referring to the missing user(s). Follow below steps to fix this issue
Shutdown Confluence
Take full backup of Confluence Database
Execute below SQL query to delete the content referring to missing users
1DELETE FROM CONTENT WHERE contenttype = 'USERINFO' AND username NOT IN (SELECT user_key FROM user_mapping);Start Confluence
Was this helpful?