Confluence Server User access failed

[Sofia Quintero]

User got this error when he was trying to log in Confluence. There´s no problem logging into Jira. He has a license. He changed the password. License was removed and re-added. He tried clearing cookies and cache, using another browser. And he even tried from an other computer. Failed authentication attempts counter in Confluence has been reset.

[Brant Schroeder · Accepted solution]

@Sofia Quintero The user most likely has a duplicate record in the user table.  You will need to fix this in the DB.  Information on how to fix below.

https://confluence.atlassian.com/confkb/user-related-issues-in-confluence-with-the-error-message-query-did-not-return-a-unique-result-596181603.html

https://confluence.atlassian.com/confkb/synchronization-with-external-directory-fails-with-error-query-did-not-return-unique-result-757727378.html

[Sofia Quintero]

@Brant Schroeder  thank you for answer!

[Sofia Quintero]

Hello @Brant Schroeder

We fixed the problem with the soultion that you mentioned. Thank you.

Now the same user has an other problem regading an page access.

If you know something about it, would be greatful.

https://community.atlassian.com/t5/Confluence-questions/User-can-t-acced-Confluence-URL/qaq-p/2070836#M247905