Email already exists issue

Email 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 , take this id and find the contact id in the following query

select * from aaausercontactinfo where contactinfo_id=303

This will give you the user id. If you fail with above, 

select * from sduser where secondemailid='email@email.com'

this will give you the contact id of the email exists in the secondary email id.

Now edit any contact and put this user id in the address bar.Here you could edit or delete the hidden contact.

As a single query to find the status of the user , use the following query

select * from aaausercontactinfo auci join aaacontactinfo aci on auci.contactinfo_id=aci.contactinfo_id where aci.emailid='emailaddress'
      • Related Articles

      • Change the default font-size and font-family while sending emails from SCP

        Kindly try the following steps below, Access the database and initiate the query below select * from globalconfig where category = 'rta'; It will list out the global config categories and from the list check for the  globalconfigid for font -size and ...
      • How to take console log ?

        This article is common for Servicedesk plus MSP and Supportcenter plus applications. To troubleshoot certain UI issues , JS errors , we need console log (output) from the browser. Steps to follow : 1. Login to the application. 2. Right click on the ...
      • Issue running reports

        Cause : Report API running the background causes the issue. If the user mentions issue with running reports with the below error and trace as mentioned below. Error trace: ...
      • Behavior of Survey email configuration in 11.0

        When Support reps setup survey email configuration, they would be under the impression that the language they select would the one the survey goes out but it doesn't work that way.  Let's say that the Support rep sets up the survey to go out in the ...
      • Email Signtature behavior in Version 11.0.

        In order for the email signature to work in Version 11.0, please do add the signature first and then go to Admin - Notification Rules - Replying to a Request template - Customize template and add the below variable  $EmailSignature.  ...