In this guide the recommended actions are described on how to troubleshoot and configure the system to solve this error the duplicate message
General Description
The User sees the "User with this extension already exists" message
This message is displayed when the User tries to configure Ring Central RingCentral Telephony in the Creatio, but the Ring Central Account RingCentral account is already connected with another Creatio extension., and in order to eliminate this message, one needs to delete the RingCentral account duplicate registrations in Creatio
...
...
To check your CurrentContactId from the left main menu select ‘Contacts’ (Fig. 1)
Fig. 1 Contacts selection
...
Duplication deletion flow
Click on the profile icon (1) in the left upper corner and then on ‘Your Profile’ (2) (Fig. 21)
Fig. 2 Using the search fieldIn the appeared result(s) click on the Name of your account. A contact card will be opened. In the address bar, you can find a CurrentContactId at the end of the line (Fig. 3) and copy it.
Fig. 3 CurrentContactId locationClick on the ‘Gear’ icon in the upper right corner (Fig.4)
Fig. 4 Location of the ‘Gear’ iconSelect ‘Open system designer’ (Fig. 5)
Fig. 5 Open system designer optionScroll down the page and click on the 'SQL query console' (Fig. 6)
Fig. 6 SQL query consoleIn line 12 enter the following script delete from VvtSysAdminUnit where VvtContactId = '%CurrentContactId% Instead of the word CurrentContactId enter the CurrentContactId that you have copied in p. 3 and press the 'Execute’ button (Fig. 7)
Fig. 7 Entering and executing the scriptAfter that go to the ‘Your profile’ → ‘Call Center parameter setup’ and 1 Entering ‘Your profile’ section
Click on the ‘Call Center parameters setup' (Fig. 2)
Fig. 2 ‘Call Center parameters setup' locationCopy the settings “RingCentral URL“, “Client ID“, “Client Secret“ parameters, and then click on the ‘RESET RC SETTINGS’ button (Fig. 3)
Fig. 3 Reset RC settings initiationThis will reset the connection, as well as clear out the parameters. Fill the copied parameters back in, and after that press ‘GET RC SETTINGS’. Proceed with all steps of the authorization. If the settings were implemented successfully the following notification will be shown (Fig. 84)
Fig. 8 4 Successull messageClose the success window from the step above, and press the ‘Save’ button
Log out of Creatio and log back in. Check that your CTI panel is active
Cleaning of the duplicates. Long option
If the as a result of actions from p. 8 of the ‘Cleaning of the duplicates. Quick option’ 4, you see this the following error again (Fig. 95) proceed with the next steps to find the specific User connected by the Creatio user with the RingCentral account
Fig. 9 5 User with this username already exists errorFrom the left main menu select ‘Contacts’ (Fig. 106)
Fig. 10 6 Contacts selection
...
Click on the
...
‘Folders’ (Fig.
...
7). Select ‘Add’ (1) and name the new folder (2) (Fig.
...
8)
Fig.
...
7 Folder button
Fig.
...
8 New Folder creation
Select the filter icon (Fig.
...
9)
Fig.
...
9 Filter icon
Select ‘Add condition’ (Fig.
...
10).
Fig.
...
10 Adding filter conditions
In the opened window press on the ‘Contact’ (1) and enter ‘Contact communication option (by column Contact)’ (2). In ‘Column’ field select ‘Quantity’ (3) and press ‘Select’ button (4) (Fig.
...
11)
...
Fig. 15 Creating filter structure pt. 1Press ‘+' icon (Fig.
...
11).
Fig. 16 Adding sub conditionIn the Colunm field enter ‘Number’ (1) and press 'Select’ (2) (Fig.
...
12)
Fig.
...
12 Creating filter structure pt. 2
In the ‘quantity’ field enter ‘0' (1) and press the confirmation button (2). In the ‘Number’ field enter the required extension (3) and press the confirmation button (4). To apply all conditions press 'Save’ button (5) (Fig.
...
13)
Fig.
...
13 Applying all conditions
In the Table, you can see all the
...
Contacts that
...
are using this extension. If
...
there is only 1 Contact and it is CORRECT, then use another Ring Central account for your current Creatio profile by using this guide RingCentral Configuration. If you see that this is NOT the right Contact that should be connected to the Ring Central account, or there are multiple Contacts, proceed with the further steps
...
If you click on the Name of this contact a contact card will be opened. In the address bar, you can find a VvtContactid at the end of the line (Fig. 19)
Fig. 19 VvtContactid location
...
...
Login into the system with the credentials of the User that should not be connected to the required RingCentral account
Perform actions from p. 1 to p. 3
...
...
As a result, you will receive the VvtContactId (Fig. 21)
Fig. 21 Receiving VvtContactId via the SQL script request
...
...
To remove the connection between that user and the Ring Central account:
Step 1: Remove previous script from the 12 line and replace it with the following one delete from VvtSysAdminUnit where VvtContactid = 'VvtContactId'
Instead of VvtContactId write VvtContactId that you have received from p. 9 or p. 11 and press the 'Execute’ button.
Step 2: Remove previous script from the 12 line and replace it with the following one delete from ContactCommunication where VvtContactid = 'VvtContactId' Instead of VvtContactId write VvtContactId that you have received from p. 9 or p. 11 and press the 'Execute’ button.
...
Repeat points 17-18 for each User, which is not expected to have RingCentral extension registered with it
After that Login into the system with the credentials of the User who should be connected to the required Ring Central account
Perform actions from p. 4 to p. 5
At this point, all duplicate RingCentral extension registration should be cleared from all Creatio users except from the expected one