Unity Connection  Sub 9.1 install failed with error

I was doing a reinstall of mine Unity Connection 9.1 subscriber and it failed with the following error message.

"rpm --percent -iv --replacefiles
/common/rpm-archive/9.1.1.20000-5/RPMS/connection/cuc-9
.1.1.20000-32.i386.rpm " failed 91)

The system will now halt.


After talking to Cisco TAC it turns out to be a bug

Cluster renegotiate fails due to syscdr already present on SUB

CSCue78730

Description

Symptom:
The CLI "utils cuc cluster overwritedb" fails either on PUB or SUB.
The CLI "utils cuc cluster renegotiate" fails on SUB.
The install or upgrade fails on Subscriber server.

Conditions:
Enterprise replication was active between PUB and SUB.
Previous Replication could not be broken within a stipulated timeout as the database tables were locked internally. When replication is attempted to be recreated post overwritedb / renegotiate, it fails. The same failure is also seen during subscriber install or upgrade

Workaround:
None.

Cisco TAC did something with the database and afterward I was able to finish installing Unity Connection Subscriber to my cluster. Hope this helps someone else who run into the same issue somewhere. 

Using sql commands to update CUCM line settings

Recently we had to change the outbound PSTN access code from 9 to 0 because a lot of users were dialing 911 accidentally. It's really simple to do that in CUCM to change the dial-pattern from 9 to 0 but what about changing all the speed dial and call forward all destination. Turns out you can do that with CLI and sql commands.

To change speed dials from 9 to 0

1. verify the current speed dials with this command

    run sql select speeddialnumber from speeddial

2. use the following command to update the first number in the speed dial from 9 to 0 and only if the first number is 9

    run sql update speeddial set speeddialnumber[1] = '0' where speeddialnumber[1] = '9'

3. run the first command again to verify the change

To change call forward all destination from 9 to 0

1. verify the current call forward all destination

    run sql select cfadestination from callforwarddynamic

2. use the following command to update the first number in call forward all destination from 9 to 0 and only if the first number is 9

    run sql update callforwarddynamic set cfadestination[1]='0' where cfadestination[1]='9'

3. run the first command again to verify change