Guest

Preview Tool

Cisco Bug: CSCuq18355 - upgrade fails due to non-standard ccmadministrator user

Last Modified

Jul 06, 2017

Products (1)

  • Cisco Unified Communications Manager (CallManager)

Known Affected Releases

10.0(1.10000.24)

Description (partial)

Symptom:
PCD migration fails during database migration.

Check both "installdb_ru.log.err" and "installdb_ru.log" for:

22:30:14.122 |*ERROR* Error executing "insert into ApplicationUser (aclallowreplace,acloobsubscription,acloodrefer,aclpresencesubscription,aclunsolicitednotification,fkmatrix_presence,isstandard,name,passwordreverse,pkid) values ('F','F','F','F','F','ad243d17-98b4-4118-8feb-5ff2e1b781ac','F','ccmadministrator','','031e82c9-22a7-3949-cbe4-7cdb70be1207'): [Informix][Informix ODBC Driver][Informix]Could not insert new row - duplicate value in a UNIQUE INDEX column (Unique Index:).
22:30:14.230 |   DBUtil::DoSQLCommand ### *ERROR* ###:  SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR applicationuserdirgroupmap ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected. sqlerrm(assign)]
22:30:14.230 |   DBUtil::BlockCopyTable ### *ERROR* ###:  SQL Exception Detected:   ErrorCode=-971   , SQLState=HY000
22:30:14.230 |   DBUtil::BlockCopyTable ### *ERROR* ###:  (diagnosis):  Bulk Data Migration for table applicationuserdirgroupmap failed due to data constraint issue, (-971).
22:30:14.840 |   DBUtil::BlockCopyTable *ERROR*   Violation of the REFERENTIAL constraint fk_applicationuserdirgroupmap_fkapplicationuser on the applicationuserdirgroupmap table by the record with pkid = cea5d541-9aaa-7abf-d311-493f5399e568.  Referenced applicationuser record must exist (fkapplicationuser).
22:30:44.366 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).
22:30:44.441 |   DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (applicationuserdirgroupmap)
22:31:05.895 |   DBUtil::DoSQLCommand ### *ERROR* ###:  SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR credential ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected. sqlerrm(assign)]
22:31:05.895 |   DBUtil::BlockCopyTable ### *ERROR* ###:  SQL Exception Detected:   ErrorCode=-971   , SQLState=HY000
22:31:05.895 |   DBUtil::BlockCopyTable ### *ERROR* ###:  (diagnosis):  Bulk Data Migration for table credential failed due to data constraint issue, (-971).
22:31:06.464 |   DBUtil::BlockCopyTable *ERROR*   Violation of the REFERENTIAL constraint fk_credential_fkapplicationuser on the credential table by the record with pkid = fc32f60e-c676-4878-a06a-27f7a04be962.  Referenced applicationuser record must exist (fkapplicationuser).

Conditions:
In PCD we have default application super user as "CCMAdministrator".customer added a ccmadministrator account.This account is copied before CCMAdministrator is being updated to administrator.
So we ended up having two ccmadministrator accounts during the upgrade.
This resulted in unique key violation.
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.