Quick BI基于MaxCompute数据源追加附件报错“Out of range value for column occupied_volumn at row 1”

问题描述

Quick BI基于MaxCompute数据源上传附件报错“Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'occupied_volumn' at row 1”完整的报错信息如下：

org.springframework.dao.DataIntegrityViolationException:
### Error updating database.
Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'occupied_volumn' at row 1
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: update yunbi_mix_repository set occupied_volumn = (occupied_volumn + ?) where id = ?
Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'occupied_volumn' at row 1
; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'occupied_volumn' at row 1

问题原因

根据报错信息看是因为上传的附件信息超过Qucik BI元数据库元数据表字段长度限制导致。经过进一步确认，是因为一个数据源中累计最多上传2G的附件，超过该限制就会报错。

解决方案

确认数据源历史上传的附件是否都要用，如果确认不用，删除部分不再用的附件，减少附件大小即可。

适用于

• Quick BI公有云专业版6.0