Guest

Preview Tool

Cisco Bug: CSCut12096 - Upgrade fails if user adds non-presence contact during the upgrade

Last Modified

Nov 10, 2016

Products (2)

  • Cisco Unified Communications Manager IM & Presence Service
  • Cisco Unified Communications Manager IM and Presence Service Version 10.5

Known Affected Releases

10.5(2) 8.6(5.2) 9.1(1.1)

Description (partial)

Symptom:
Upgrade fails with the error in the install log that will look like below:

=============
19:04:24.183 |ERROR Error executing "insert into nonpresencecontactgroupmap (fknonpresencecontacts,group_name,pkid) values ('03168775-ca20-4e4e-abb6-14c72eb1150f','ExampleGroup','a61c5937-0f7b-435f-910f-e3c7287bf97b'): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_nonpresencecontactgroupmap_fknonpresencecontacts).
===============
19:01:48.787 |ERROR Error executing "insert into nonpresencecontacts (buddy,fkenduser,fkepascontactaddinfo,nickname,pkid) values ('john.doe@example.com','b3440a56-27e5-4476-8d1d-30af156f09f8','96c3263d-7f03-4b8d-bba0-cbab41c45dcb',NULL,'f80d2494-e485-4556-ae83-f8d07d32124a'): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_nonpresencecontacts_fkepascontactaddinfo).
===============

Conditions:
A user added one or more non-presence contacts during the upgrade process
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.