716 Star 6.4K Fork 2.6K

GVPanji-plus / AJ-Report

 / 详情

excel保存报错 'json_str' 过长

Done
Opened this issue  
2022-07-01 17:58

该问题是怎么引起的?

新建excel报表,选择数据集并托拽字段后,点击保存报错;后台日志提示 gaea_report_excel表 'json_str'字段数据过长;
但查看保存数据里面有很多单元格没有什么配置都是null,导致整体字段过长;

重现步骤

添加数据集,excel选择11个字段后保存

报错信息

SQL: INSERT INTO gaea_report_excel ( report_code, set_codes, set_param, json_str, create_by, create_time, update_by, update_time, version ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )

Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'json_str' at row 1

; Data truncation: Data too long for column 'json_str' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'json_str' at row 1

输入图片说明

Comments (1)

xiaowoniu created任务

你是不是execl设计界面的东西太多了,导致字段超长

Foming changed issue state from 待办的 to 已完成

Sign in to comment

Status
Assignees
Milestones
Pull Requests
Successfully merging a pull request will close this issue.
Branches
Planed to start   -   Planed to end
-
Top level
Priority
参与者(2)
Java
1
https://git.oschina.net/anji-plus/report.git
git@git.oschina.net:anji-plus/report.git
anji-plus
report
AJ-Report

Search

挂件 关闭按钮