(已解决)Kettle 转换CVS → EXCEL 错误

报错信息如下:

2020/07/29 13:04:41 - Spoon - Running transformation using the Kettle execution engine
2020/07/29 13:04:41 - Spoon - 转换已经打开.
2020/07/29 13:04:41 - Spoon - 正在打开转换 [jobs]...
2020/07/29 13:04:41 - Spoon - 开始执行转换.
2020/07/29 13:04:42 - jobs - 为了转换解除补丁开始  [jobs]
2020/07/29 13:04:42 - Access 输出.0 - Access 数据库写入到文件 'SALE'.
2020/07/29 13:04:42 - CSV文件输入.0 - Header row skipped in file 'file:///D:/2/Iowa_Liquor_Sales.csv'
2020/07/29 13:04:42 - Access 输出.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : 将数据行写入数据库时发生错误: [S28868500001], [11/12/2015], [2627], [Hy-Vee Wine and Spirits #1], [3424 MARTIN LUTHER KING JR PKW], [DES MOINES], [50310], [3424 MARTIN LUTHER KING JR PKW
DES MOINES 50310
(41.626402, -93.651112)], [77], [Polk], [null], [null], [65], [Jim Beam Brands], [237], [Knob Creek w/ Crystal Decanter], [3], [1750], [$35.55], [$53.34], [2], [$106.68], [3.5], [0.9]
2020/07/29 13:04:42 - Access 输出.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : java.io.IOException: Text is wrong length for TEXT column, max 69, min 0, got 71
2020/07/29 13:04:42 - Access 输出.0 - 	at com.healthmarketscience.jackcess.Column.encodeTextValue(Column.java:1665)
2020/07/29 13:04:42 - Access 输出.0 - 	at com.healthmarketscience.jackcess.Column.write(Column.java:1443)
2020/07/29 13:04:42 - Access 输出.0 - 	at com.healthmarketscience.jackcess.Column.write(Column.java:1407)
2020/07/29 13:04:42 - Access 输出.0 - 	at com.healthmarketscience.jackcess.Table.createRow(Table.java:1828)
2020/07/29 13:04:42 - Access 输出.0 - 	at com.healthmarketscience.jackcess.Table.createRow(Table.java:1722)
2020/07/29 13:04:42 - Access 输出.0 - 	at com.healthmarketscience.jackcess.Table.addRows(Table.java:1442)
2020/07/29 13:04:42 - Access 输出.0 - 	at com.healthmarketscience.jackcess.Table.addRow(Table.java:1387)
2020/07/29 13:04:42 - Access 输出.0 - 	at org.pentaho.di.trans.steps.accessoutput.AccessOutputData.addRowToTable(AccessOutputData.java:75)
2020/07/29 13:04:42 - Access 输出.0 - 	at org.pentaho.di.trans.steps.accessoutput.AccessOutput.writeToTable(AccessOutput.java:162)
2020/07/29 13:04:42 - Access 输出.0 - 	at org.pentaho.di.trans.steps.accessoutput.AccessOutput.processRow(AccessOutput.java:87)
2020/07/29 13:04:42 - Access 输出.0 - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/07/29 13:04:42 - Access 输出.0 - 	at java.lang.Thread.run(Thread.java:748)
2020/07/29 13:04:42 - Access 输出.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Error closing the database: java.io.IOException: Text is wrong length for TEXT column, max 69, min 0, got 71
2020/07/29 13:04:42 - CSV文件输入.0 - 完成处理 (I=9960, O=0, R=0, W=9959, U=0, E=0)
2020/07/29 13:04:42 - Access 输出.0 - 完成处理 (I=0, O=0, R=58, W=57, U=0, E=1)
2020/07/29 13:04:42 - jobs - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : 错误被检测到!
2020/07/29 13:04:42 - Spoon - 转换完成!!
2020/07/29 13:04:42 - jobs - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : 错误被检测到!
2020/07/29 13:04:42 - jobs - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : 错误被检测到!
2020/07/29 13:04:42 - jobs - 转换被检测
2020/07/29 13:04:42 - jobs - 转换正在杀死其他步骤!

经过对所有的功能按钮进行操作后,终于发现,原来是由于简易转换导致,取消勾选CVS输入中的简易转换后,输出终于正常了

在这里插入图片描述

  • 4
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 5
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值