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.时间转换不了,后面去改时间格式,保持一致了,还是有问题