11-05-2020 07:05 AM
We recently hit this bug in UCCE 11.6.1 / CUIC 11.6.1.10000-44.
Our client reported that some users were getting the following error when trying to view live data report gadgets in Finesse. "Request to Server returned Forbidden".
We traced the issue to CUIC where some agents were not syncing properly from UCCE. We found the following error when attempting synchronization in UCCE User Integration Configuration. "FAILED [ doBulkInsert for Supervisors failed: SQLException: Unique constraint (informix.u120_107) violated. ]"
We were able to clear the user sync error in CUIC using the SQL query provided in Step 6 of the following document. https://www.cisco.com/c/en/us/support/docs/customer-collaboration/unified-intelligence-center/211629-CUIC-11-5-1-UCCE-User-Integration-fai.html run sql select * from cuic_data:cuicuser cuic ,(select t.ADLoginName, t.personid from cuic_data:cuicuser as c, cuic_data:cuic_temp_users as t where c.personid = t.personid and c.name != t.ADLoginName ) as temp where cuic.name = temp.ADLoginName and (cuic.personid != temp.personid or cuic.personid is NULL)
The output from this query provided a "problematic users in CUIC that need to be deleted ( Again DO NOT delete them from CUIC CLI with SQLstatements )". Deleting this user in CUIC allowed the user sync to complete successfully. All the previous users then synced successfully and were able to see the Live Data report gadgets in Finesse.