【TAC分享】UCCX Switch version failed when upgrading from 11.6 to 12.5.

yangwan4 · ‎02-27-2023

问题描述：当升级UCCX 从11.6 到12.5 的时候，升级可以成功但是版本切换的时候会报错。报错如下：

Sync after switch version failed: Unified CCX Data Update Switch version has failed due to :: Unified CCX Data Update failed Please collect the logs via "file get install /*". Reboot this UCCX node with the command "utils system restart". Issue the command "utils uccx switch-version db-check". If database corruption is found issue the command "utils uccx switch-version db-recover". Contact Cisco TAC for assistance.

我们可以自己收集一下install log，需要提前准备一个SFTP server.通过在UCCX 的CLI 里输入下面这个命令将log 下载到SFTP server 上。

file get install *

有一个log 文件叫uccx-install.log。从这个log 里我们如果能看到如下报错的话，说明这个数据表有问题。

agentstatedetailsnapshot

Applying action 'SCHEMA_UPDATE'using migration script: /opt/cisco/uccx/sql/cra_delta_930_to_964.sql
Sourcing IDS environment variables
Database selected for migration: db_cra
Regular schema update using file: /opt/cisco/uccx/sql/cra_delta_930_to_964.sql

Routine created.

242: Could not open database table (informix.agentstatedetailsnapshot).

106: ISAM error: non-exclusive access.
Error in line 559
Near character position 1

Failed to run SQL file : /opt/cisco/uccx/sql/cra_delta_930_to_964.sql
unmounting /proc ...
Wed Feb 22 14:19:05 CST 2023 :: Error updating schema
Wed Feb 22 14:19:05 CST 2023 :: Stopping DB
Wed Feb 22 14:19:05 CST 2023 :: ------Stopping uccx database-------
Wed Feb 22 14:19:20 CST 2023 :: Waiting for port to be released
Wed Feb 22 14:19:20 CST 2023 :: The port is released
Wed Feb 22 14:19:20 CST 2023 :: ------UCCX database stopped--------
Wed Feb 22 14:19:20 CST 2023 :: DB upgrade script failed
Wed Feb 22 14:19:20 CST 2023 :: Restoring replication status of the database
At least two servers must be defined for replication.
The requested operation will not be performed.

Wed Feb 22 14:19:21 CST 2023 :: ./uccx_sv_db.sh 11.6.2.10000-38 12.5.1.11002-481
Script uccx_sv_db.sh failed with exit code 255.
inside updateprogressErrorMsg function
error msg is : : Unified CCX Data Update failed

我们从log 里可能看到多个不同的数据表有问题，需要在root 中检查。

我们有两个Action 可以做：

1. 重启server 然后再次尝试switch version

2. 如果还是失败且log 里是相同的报错的话，请激活root accout 然后开TAC case，TAC 会帮助你从root 里删除和重建这个表。

utils remote_account enable

utils remote_account create ciscotac 3

将上面这个命令的输出和install log 的压缩包提供给TAC 即可。

CNModerator.Cisco · ‎02-27-2023

感谢专家分享

Clifford McGlamry · ‎04-26-2024

This showed up in a google search. I had to run it through Google Translate to understand it. I pasted in the translation below. The TAC engineer found the fix for this in the notes to Bug ID CSCvv87187

English translation of the above:

【TAC Share】UCCX Switch version failed when upgrading from 11.6 to 12.5.
yangwan4
yangwan4 Cisco EmployeeCisco Employee
on ‎02-27-2023 07:15 PM - edited on ‎05-14-2023 11:09 PM by Yanli Sun Community Manager

Problem description: When upgrading UCCX from 11.6 to 12.5, the upgrade can be successful but an error will be reported when switching versions. The error is reported as follows:

Sync after switch version failed: Unified CCX Data Update Switch version has failed due to :: Unified CCX Data Update failed Please collect the logs via "file get install /*". Reboot this UCCX node with the command "utils system restart". Issue the command "utils uccx switch-version db-check". If database corruption is found issue the command "utils uccx switch-version db-recover". Contact Cisco TAC for assistance.

We can collect the installation log ourselves. We need to prepare an SFTP server in advance. Download the log to the SFTP server by entering the following command in the CLI of UCCX.

file get install *

There is a log file called uccx-install.log. If we can see the following error message from this log, it means there is a problem with the data table.

agentstatedetailsnapshot

Applying action 'SCHEMA_UPDATE' using migration script: /opt/cisco/uccx/sql/cra_delta_930_to_964.sql
Sourcing IDS environment variables
Database selected for migration: db_cra
Regular schema update using file: /opt/cisco/uccx/sql/cra_delta_930_to_964.sql

Routine created.

242: Could not open database table (informix.agentstatedetailsnapshot).

106: ISAM error: non-exclusive access.
Error in line 559
Near character position 1

Failed to run SQL file: /opt/cisco/uccx/sql/cra_delta_930_to_964.sql
unmounting /proc ...
Wed Feb 22 14:19:05 CST 2023 :: Error updating schema
Wed Feb 22 14:19:05 CST 2023 :: Stopping DB
Wed Feb 22 14:19:05 CST 2023 :: ------Stopping uccx database-------
Wed Feb 22 14:19:20 CST 2023 :: Waiting for port to be released
Wed Feb 22 14:19:20 CST 2023 :: The port is released
Wed Feb 22 14:19:20 CST 2023 :: ------UCCX database stopped--------
Wed Feb 22 14:19:20 CST 2023 :: DB upgrade script failed
Wed Feb 22 14:19:20 CST 2023 :: Restoring replication status of the database
At least two servers must be defined for replication.
The requested operation will not be performed.

Wed Feb 22 14:19:21 CST 2023:: ./uccx_sv_db.sh 11.6.2.10000-38 12.5.1.11002-481
Script uccx_sv_db.sh failed with exit code 255.
inside updateprogressErrorMsg function
error msg is : : Unified CCX Data Update failed

We may see from the log that there are problems with multiple different data tables and need to be checked in the root.

We have two Actions to do:

1. Restart the server and try switch version again

2. If it still fails and the same error is reported in the log, please activate root accout and open TAC case. TAC will help you delete and rebuild the table from root.

utils remote_account enable

utils remote_account create ciscotac 3

Just provide the output of the above command and the compressed package of the install log to TAC.