由于"将所有表转换为utf8mb4"、无法还原DWH数据库
适用场景
- 数据仓库(DWH) 7.3.14
- OnCommand Insight (OCI) 7.3.14
问题描述
2022-09-27 08:57:54,486 ERROR [default task-11] UpgradeManagerPortalBean (UpgradeManagerPortalBean.java:94) - Failed to restore from 'dwh_7.3.12_site_name_all_7753117435819340675.zip' Reason: com.netapp.sanscreen.dwh.upgrade.UpgradeException: Failed: Upgrader to version 7.3.14.2; description=[Convert all tables to utf8mb4]; framework match version=7.3.14.0
javax.ejb.EJBException: com.netapp.sanscreen.dwh.upgrade.UpgradeException: Failed: Upgrader to version 7.3.14.2; description=[Convert all tables to utf8mb4]; framework match version=7.3.14.0
Caused by: com.netapp.sanscreen.dwh.upgrade.UpgradeException: Failed: Upgrader to version 7.3.14.2; description=[Convert all tables to utf8mb4]; framework match version=7.3.14.0
Caused by: com.netapp.sanscreen.dwh.util.SqlShellException: Failed to execute: ALTER TABLE dwh_custom.#tableau_1020_sid_000001c7_4_filter CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci