RTMT-ALERT CCXToCUICCVDSyncFailed

I was getting this alert every day. This was because, "aaa" ID was not there in UCCX DB, however same ID present in CUIC reporting. I tried to delete it from CUIC but unable to delete it and I was getting cannot delete error.

RTMT Alert:

 RTR : User with userID:aaa failed to be synced to CUIC. Please run sync CLI command to fix the issue.

AppID : Cisco Unified CCX Cluster View Daemon ClusterID : 

NodeID : uccx01

 TimeStamp : Sat Oct 06 01:00:03 PDT 2018.

The alarm is generated on Sat Oct 06 01:00:03 PDT 2018.

run sql select * from cuic_data:cuicuser    ->This command is to see all the users that should have access on CUIC

I followed steps mentioned in the below Cisco forum and was able to delete the ID from CUIC.

https://community.cisco.com/t5/contact-center/uccx-10-5-shows-ccxtocuiccvdsyncfailed/td-p/2561092

https://community.cisco.com/t5/cisco-bug-discussions/cscup31962-commands-showing-on-the-bug-workaround-are-wrong/td-p/2499841

#UCCX Version :11.5

-------------------------------------------------------------------------------------------------------------------

I was getting below error when I removed one of the Admin CUIC user:

RTR : Failed to grant permission to the collection: XXXXX for the userGroup:AllUsers.ReportingUsers in CUIC.Please run sync CLI c AppID : Cisco Unified CCX Cluster View Daemon ClusterID :  

To fix this login UCCX CLI and Enter, you would get groupfullname

run sql select * from cuic_data:cuicgroup

Then enter following, make sure group name and defaultgroupid are matching here

·       

run sql update cuic_data:cuicgroup set groupfullname='AllUsers.ReportingUsers' where id='D7D7E1A610000132363635BD3F57F543'

·       run sql update cuic_data:cuicgroup set groupfullname='AllUsers.Agents' where id='5B526E081000013F000000BF0A4E5EB6'

·       run sql update cuic_data:cuicgroup set groupfullname='AllUsers.Supervisors' where id='5B53E1651000013F000000C40A4E5EB6'

 

·       utils service restart Cisco Unified Intelligence Center Reporting Service

·       utils service restart Cisco Unified Intelligence Center Serviceability Service