CUxAC Troubleshooting Guide (CUEAC, CUDAC, CUBAC)

Document

Feb 15, 2012 3:36 PM
Feb 15th, 2012

How to determine if the Directory hit the maximum limit of user entries

  • Start > All Programs > Microsoft SQL Server 2008 > click on the Connect button > expand the tree structure until you get to the Tables level:

SQLStudio2.jpg

  • Highlight the dbo.Contact_Numbers table and right click on it, then select Top 1000 rows. You will see at the lower right corner the amount of users imported to the Directory.

SQLStudio.jpg

NOTE: Before applying this steps, make sure that Directory Sync is  enabled ( System Configuration > Directory Synchronization >  Enable), that you have restarted the LDAP plugin service, and that you  have closed the client console and logged back in.

How to determine which users are going to be present inside the Directory once the limit is reached

Basically, theAttendant Console will filter the user directory from CallManager sorting the entries by their pkid value. First come, first served. However the pkids are out of our control, and are also random. Take for example this output from an SSH connection to a Publisher:

admin:run sql select telephonenumber,userid,pkid from enduser order by pkid

telephonenumber userid   pkid                                

=============== ======== ====================================

7005            luzuniga 072db6cd-4968-664f-07c6-e3b284c03682

7003            aformosa ae5e7d41-a66a-5f0d-b10c-50a8f445638c

1234            1234tome b517f6c5-ec3c-3e15-56d4-226bf4156b79

7005            cbucket  c8f7be03-9028-0ad3-a871-3f35337e5c25

7335            willy    dddd2b45-aad9-7218-a5e5-ff332e3ecb0

The output shows the order in which Attendant Console reads the user list from CallManager, and starts inserting them into the database. See how the username with extension 7005 is not alphabetically the first one, nor is it the lowest directory number, and it was not chronologically the first user inserted, but its pkid starts with 0.

Lets say my Attendant Console has a capacity of displaying maximum 3 users on a client Console. That means that Charlie Bucket and Willy won't be displayed at all. CUBAC has a maximum of 500 users, and CUDAC goes up to750. CUEAC, up to 100 000.

The SQL Query above can be  used to determine the last entries that will not get inserted into CUxACs LDAP database.

NOTE: Before applying this steps, make sure that Directory Sync is enabled ( System Configuration > Directory Synchronization > Enable), that you have restarted the LDAP plugin service, and that you have closed the client console and logged back in.
Average Rating: 0 (0 ratings)

Actions

Login or Register to take actions

This Document

Posted February 15, 2012 at 3:36 PM
Stats:
Comments:0 Avg. Rating:0
Views:1671 Contributors:0
Shares:0
Tags: No tags.

Documents Leaderboard