2020/04/08 02:10:21 - Spoon - Using legacy execution engine

2020/04/08 02:10:21 - Spoon - 转换已经打开.

2020/04/08 02:10:21 - Spoon - 正在打开转换 [多个Excel合并]...

2020/04/08 02:10:21 - Spoon - 开始执行转换.

2020/04/08 02:10:23 - Spoon - 转换完成!!

2020/04/08 02:10:47 - B:\2019-2020(2)学习文件\数据导入和预处理\第三章实验\lsn第三章实验\ktr\多个Excel合并.ktr : 多个Excel合并 - 为了转换解除补丁开始 [B:\2019-2020(2)学习文件\数据导入和预处理\第三章实验\lsn第三章实验\ktr\多个Excel合并.ktr : 多个Excel合并]

2020/04/08 02:10:47 - Excel输入.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : 错误处理 Excel 文件 [B:\2019-2020(2)学习文件\数据导入和预处理\第三章实验\OnlineExperiment\2\data\课程信息表1.xlsx] 中的行 : org.pentaho.di.trans.steps.excelinput.KettleCellValueException: 不能转换位于表单 1, 行 3, 列 6的字段"开课时间":

2020/04/08 02:10:47 - Excel输入.0 - org.pentaho.di.core.exception.KettleValueException:

2020/04/08 02:10:47 - Excel输入.0 - v String : couldn't convert string [2018/9/12] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] on offset location 9

2020/04/08 02:10:47 - Excel输入.0 - 2018/9/12

2020/04/08 02:10:47 - Excel输入.0 -

2020/04/08 02:10:47 - Excel输入.0 -

2020/04/08 02:10:47 - Excel输入.0 - v String : couldn't convert string [2018/9/12] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] on offset location 9

2020/04/08 02:10:47 - Excel输入.0 - 2018/9/12

2020/04/08 02:10:47 - Excel输入.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.trans.steps.excelinput.KettleCellValueException: 不能转换位于表单 1, 行 3, 列 6的字段"开课时间":

2020/04/08 02:10:47 - Excel输入.0 - org.pentaho.di.core.exception.KettleValueException:

2020/04/08 02:10:47 - Excel输入.0 - v String : couldn't convert string [2018/9/12] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] on offset location 9

2020/04/08 02:10:47 - Excel输入.0 - 2018/9/12

2020/04/08 02:10:47 - Excel输入.0 -

2020/04/08 02:10:47 - Excel输入.0 -

2020/04/08 02:10:47 - Excel输入.0 - v String : couldn't convert string [2018/9/12] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] on offset location 9

2020/04/08 02:10:47 - Excel输入.0 - 2018/9/12

2020/04/08 02:10:47 - Excel输入.0 -

2020/04/08 02:10:47 - Excel输入.0 -

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.fillRow(ExcelInput.java:221)

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:613)

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:432)

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)

2020/04/08 02:10:47 - Excel输入.0 - at java.lang.Thread.run(Thread.java:748)

2020/04/08 02:10:47 - Excel输入.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:

2020/04/08 02:10:47 - Excel输入.0 - v String : couldn't convert string [2018/9/12] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] on offset location 9

2020/04/08 02:10:47 - Excel输入.0 - 2018/9/12

2020/04/08 02:10:47 - Excel输入.0 -

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:939)

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getDate(ValueMetaBase.java:2302)

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3858)

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.fillRow(ExcelInput.java:216)

2020/04/08 02:10:47 - Excel输入.0 - ... 4 more

2020/04/08 02:10:47 - Excel输入.0 - Caused by: java.text.ParseException: 2018/9/12

2020/04/08 02:10:47 - Excel输入.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:930)

2020/04/08 02:10:47 - Excel输入.0 - ... 7 more

2020/04/08 02:10:47 - Excel输入.0 - 完成处理 (I=1, O=0, R=0, W=1, U=0, E=1)

2020/04/08 02:10:47 - B:\2019-2020(2)学习文件\数据导入和预处理\第三章实验\lsn第三章实验\ktr\多个Excel合并.ktr : 多个Excel合并 - 转换被检测

2020/04/08 02:10:47 - dummy.0 - 完成处理 (I=0, O=0, R=1, W=1, U=0, E=0)

2020/04/08 02:10:47 - B:\2019-2020(2)学习文件\数据导入和预处理\第三章实验\lsn第三章实验\ktr\多个Excel合并.ktr : 多个Excel合并 - 转换正在杀死其他步骤!

是不是我的Java不正常啊？Java文件路径下jre.时间转换不了，后面去改时间格式，保持一致了，还是有问题

Summer_1218

SQLite数据库分组查询合并数据问题

2条回答

为你推荐