Guest

Preview Tool

Cisco Bug: CSCvu36517 - CUC Upgrade from 11.5/12.0 to 12.5 fails due to Custom Role named as "Read Only Administrator"

Last Modified

Sep 16, 2020

Products (1)

  • Cisco Unity Connection

Known Affected Releases

12.5

Description (partial)

Symptom:
Upgrade to 12.5 fails.  The cuc-import.log file indicates below failure 
2020-05-22 11:04:48 DEBUG    Query: SELECT FIRST 1 ObjectId FROM tbl_Role WHERE RoleName=? (sql:85)
2020-05-22 11:04:48 DEBUG    Parameters: [u'Read Only Administrator'] (sql:87)
2020-05-22 11:04:48 DEBUG    Query: SELECT FIRST 1 ObjectId FROM tbl_Privilege WHERE PrivilegeName=? (sql:85)
2020-05-22 11:04:48 DEBUG    Parameters: [u'ExtendedBase_R'] (sql:87)
2020-05-22 11:04:48 DEBUG    Query: INSERT INTO tbl_RolePrivilegeMap (RoleObjectId, PrivilegeObjectId) VALUES (?, ?) (sql:85)
2020-05-22 11:04:48 DEBUG    Parameters: ['2f8e24ae-1315-4d19-be1b-84c9686ba485', '1be82331-9ff8-4f9d-8f7b-46405f02b436'] (sql:87)
2020-05-22 11:04:48 ERROR    Database error: Integrity constraint violation (sql:91)
2020-05-22 11:04:48 Traceback (most recent call last):
2020-05-22 11:04:48   File "/opt/cisco/connection/lib/python2.7/site-packages/connection/sql.py", line 89, in execute_raw
2020-05-22 11:04:48     cursor.execute(query, args)
2020-05-22 11:04:48 IntegrityError: SQLCODE -268 in EXECUTE:
2020-05-22 11:04:48 23000: Integrity constraint violation
2020-05-22 11:04:48 IX000: ISAM error:  duplicate value for a record with unique key.
2020-05-22 11:04:48
2020-05-22 11:04:48 ERROR    Exception raised while running defaultdata.roles (UnityDirDbDefaultData:113)

Conditions:
A custom Role exists on the system with the exact name "Read Only Administrator"
Upgrading to 12.5.1 from Release 11.5.1 or 12.0.1 with Custom Role Created with Exact Name as  "Read Only Administrator"  on Base Release 11.5.1 or 12.0.1.
Problem is due to the fact that On 12.5.1 , Unity has introduced a new System Role with Same Name as "Read Only Administrator" and this will cause conflict due to the Duplicate Entry at Upgrade.
https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/connection/12x/release/notes/b_Release_Notes_1251.html#id_80749
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.