Preview Tool

Cisco Bug: CSCvs46886 - sp_updatedefaultgroup_auth Causes Unique Constraint Violation

Last Modified

Apr 28, 2020

Products (1)

  • Cisco Unified Intelligence Center

Known Affected Releases

11.0(1) 11.6(1)

Description (partial)

"My Group" of a CUIC User can't be changed for a user due to violation of unique constraint. With below error :

"Caused by: java.sql.SQLException: Unique constraint (informix.u136_220) violated."

Issue is reproducible in lab after restoring the customer DB with ES15 on CUIC 11.0(1).
Observed that, 'sp_updatedefaultgroup_auth' stored procedure which has changed in CUIC 11.0(1) ES15.

CUIC 11.0 with ES15 and upgraded from CUIC 11.0 with ES15 to CUIC 11.6
Bug details contain sensitive information and therefore require a account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.