问题描述：当升级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 即可。
