Quick BI数据准备功能报错：“Etl task execution failed，reason：the agent task execution failed”

问题描述

Quick BI数据准备功能报错：“Etl task execution failed，reason：the agent task execution failed”。

2023-01-31 10:33:44 [INFO] Init etl task context, etlId: [92ffec58-0a6d-4a11-9e38-2c4d8973cc87], taskId: [t_308432_20230131_308433].
2023-01-31 10:33:44 [INFO] Start execute etl task.
2023-01-31 10:33:49 [INFO] Create temp table success.
2023-01-31 10:33:49 [INFO] Submit task to agent successfully, wait for the task to execute successfully.
2023-01-31 10:34:49 [ERROR] Etl task execution failed, reason: the agent task execution failed.
User class threw exception: org.apache.spark.SparkException: Exception thrown in awaitResult:

问题原因

用户数据库字符集编码格式有误，导致报错。

解决方案

需要将character_set_server的latin1格式修改成utf8mb4即可。

更多信息

MySQL修改字符集编码

适用于

• Quick BI

说明：本文档描述的功能场景已在公共云V4.5.3版本验证。