Error when trying to assign ticket to user

Question

When I want to assign a ticket to a user, we get the following error:

Exception occurred: Too many rows found for query on User row1: [GenericEntity:User][lastName,null][lowerDisplayName,andrew][displayName,andrew][lowerLastName,null][active,0][externalId,557058:9427a04f-304c-458b-8659-2a01b9a9c6ac][updatedDate,2017-07-19 07:56:51.695][userName,admin][lowerEmailAddress,andrew][firstName,null][emailAddress,andrew][lowerUserName,admin][createdDate,2017-07-19 07:56:51.695][credential,nopass][deletedExternally,null][localServiceDeskUser,0][directoryId,10000][lowerFirstName,null][id,11153]row2: [GenericEntity:User][lastName,null][lowerDisplayName,andrew][displayName,andrew][lowerLastName,null][active,1][externalId,557058:9427a04f-304c-458b-8659-2a01b9a9c6ac][updatedDate,2018-01-05 11:07:06.075][userName,andrew][lowerEmailAddress,andrew][firstName,null][emailAddress,andrew][lowerUserName,andrew][createdDate,2017-08-10 13:58:28.039][credential,nopass][deletedExternally,null][localServiceDeskUser,0][directoryId,10000][lowerFirstName,null][id,11128]

We have searched the error and most results are not for JIRA Cloud

How do we resolve this for JIRA Cloud

Kind Regards

Angélica Luz · Answer

That's awesome Nick!
Thank you for sharing this information with us.
If you face this issue again or have any other question, please count on us.

Regards,
Angélica

Nick_hbwouq · Answer

Hi Angelica

Thanks for the response, for some reason the problem was resolved yesterday and I could assign it again, very strange but it's working now

Kind Regards

Nick Muller

Angélica Luz · Answer

Hello Nick,

Thank you for getting in touch with Atlassian Community!
Just for us to better understand and help you with this issue, can you please let us know if this is happening only with Andrew? 
Is it happening on all tickets and projects where you try to add Andrew as the assignee?
Was there any change before this issue happen? Were you able to add him as assignee before?

Sorry for all those questions, but it will help us to find what is causing this.

Regards,
Angélica