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 , ...
                    • Unable to add or update worklog across multiple days

                      When you get an error stating - Work log across multiple days is not allowed. Please follow the below steps to fix this case. A) ID - 15344 Unable to add or update worklog 1. Go to Admin -> Timesheet settings. 2. Enable Allow multi-day work log ...
                    • Mail fetching issue: Fetching stops when mail sent from unapproved user (with huge description)

                      Issue : Mail fetching stops when mail sent from an unapproved user Issue found in Build number : 14200 Issue fixed in Build number : 14300 Issue ID: 20438 Error trace: ...
                    • Query to get the user details (both technicians and requesters) account-wise with User ID (MSSQL & PGSQL)

                      Tested in builds PGSQL (14300) or MSSQL (14306) Tested in builds : 14000, 14201, 14301 1) Query to get the First Name, Last Name, Display Name, Login User ID, Login Name, Email and Phone Number of all users in the application, account-wise, with the ...
                    • Support Groups

                      This Report is used to export the list of Support groups configured in the application with the complete details. MSSQL SELECT qd.QUEUENAME "Support group", ci.DESCRIPTION "Description", su.first_name "Owned By", STUFF( (SELECT ',' + au.first_name ...