Guest

Preview Tool

Cisco Bug: CSCuo51115 - Same tc alias can be added multiple times

Last Modified

Mar 01, 2015

Products (1)

  • Cisco Unified Communications Manager IM & Presence Service

Known Affected Releases

9.5(1)

Description (partial)

Symptom:
Upgrade fails with below error:
21:58:35.012 |   DBUtil::DoSQLCommand ### *ERROR* ###:  SQL Exception detected while Enabling Target Indexes [Error executing "SET INDEXES FOR tcaliases ENABLED": [Informix][Informix ODBC Driver][Informix]Cannot create unique index on column with duplicate data.]
21:58:35.012 |   DBUtil::BlockCopyTable ### *ERROR* ###:  SQL Exception Detected:   ErrorCode=-371   , SQLState=23000
21:58:35.012 |   DBUtil::BlockCopyTable *ERROR*   (diagnosis):  Unexplained SQL Exception processing table tcaliases.  Please report/investigate in full logs.  (-371) [Error executing "SET INDEXES FOR tcaliases ENABLED": [Informix][Informix ODBC Driver][Informix]Cannot create unique index on column with duplicate data.]
21:59:04.714 |*ERROR* Error executing "select pkid,fkprocessnode,isprimary,peerclusterid,tcalias from tcaliases ORDER BY pkid": [Informix][Informix ODBC Driver][Informix]Cannot read system catalog (systables).
21:59:04.825 |*ERROR* Error executing "insert into tcaliases (fkprocessnode,isprimary,peerclusterid,pkid,tcalias) values (NULL,'F',2802,'330970f8-4bc3-429f-a6a5-f72bcf7ff275','xxcadfafd'): [Informix][Informix ODBC Driver][Informix]Could not insert new row - duplicate value in a UNIQUE INDEX column (Unique Index:x_tcaliases_tcalias).

Conditions:
1) IC peers
2) Same tcalias(es) across clusters
Bug details contain sensitive information and therefore require a Cisco.com 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.