Unable to add support rep in v11 - Error: User with the same email id exists

Unable to add support rep in v11 - Error: User with the same email id exists

Follow the steps below to rectify this issue.


1. Under the contacts module, click on All Contacts view. Try searching if there is any contact with the same email address by mentioning it in the Primary email, and see if you are able to find any contact. If you do find any contact, remove the email address from the contact info and try adding the support rep with the mentioned email. 




2. If the above report doesn't return any value, go to reports - > New query report, and execute the below query.

select * from aaausercontactinfo where contactinfo_id in(select contactinfo_id from aaacontactinfo where emailid like '%emailaddress%')

- > Replace the email address with the user's email address.


3. You will be seeing the userid for the contact. Open any contact and replace the userid in the URL; check if you are able to see the contact details.




4. You can remove the email address from the contact details and save it. You should then be able to create a contact with the mentioned email address.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Email id already exists issue

                        It wont allow you to create a contact, says 'email already exists'.But wont be listed in contact list view,support list view,Acc manager list view select * from aaacontactinfo where emailid='email@email.com'; This will give you the contactinfo_id , ...
                      • Query for Support Rep list in DB

                        Please run this query to find the list of Support Reps available with login in the system select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...
                      • User Import Issue (CSV)

                        While importing Contact or Support Rep via CSV many customer face issue with importing getting failed The most comman reason is that the CSV file may not have the password for the users getting imported We have set the Display Name and Login Name as ...
                      • Excess license usage shown for support reps in SCP 8.1

                        1. Go to reports - > New query report, and execute the below query.  select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...
                      • Error - Sanity Failed - Upgrade from 8121 to 11

                        While upgrading from 8121 to 11, after executing Updatemanager.bat and if the update fails, You need to check the Updatemanager logs in the path < Support Center Plus Application path -> Server-> Default-> Logs > .  And if you find the below ...