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.
01-05-2022 09:34 AM
@jpare thank you for posting this, since the original URL in your document is no longer accessible, but this pointed to the issue for me.
08-09-2022 01:48 PM
Thank you so much for posting this: it allowed me to solve this very same issue!
03-14-2023 06:12 AM
Thank you for posting! I used your query to find my sync error root cause.
11-08-2023 05:01 PM
Great, this solved my issue too. thank you
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide