I have an issue where one particular user won't sync from CCM to CUPS. All other users are are ok and the CCM config for the problem user is all ok. When I go to CUPS Application\CUPC\User Settings the user is listed but without any devices or licensing allocated (there are two watchers however). The only thing I can see is that the username in CCM/CUPS closely matches an existing user - problem user is owens, similar user is owensk.
Has anyone experienced any problems with closely matching usernames ?
Ended up logging a TAC case and they got me to do some SQL queries on the command line of the CUCM and CUPS and there was a duplicate entry that they then gave me another SQL command to resolve. I've looked back but don't have the info any more. Was something to do with duplicate PKID entries.
Just found the emails with the SQL commands, not all that clear looking back at them but did fix the issue -
From the CLI on both boxes, can we run these commands to check out which users exist in each database:
run sql select * from enduser where userid = 'coles'
Then with the output of the CUCM details, we should search on possible 'unique field' matches on the CUPS server to find the duplicate entry.
The unique field can be the PKID, userID, and sometimes mailid and ocsprimaryuseraddress.
If you send me over the output I can prepare some more commands - or if you're comfortable doing it yourself, we'll see something like this from the CUCM:
admin:run sql select * from enduser where userid = 'emtest'
pkid assocpc firstname middlename
lastname userid manager department telephonenumber tkuserlocale mailid status facsimiletelephonenumber mobile pager homephone title building site fkdirectorypluginconfig uniqueidentifier nickname deletedtimestamp
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...