kettle 本机正常linux下报错

莲台野吹逼 2018-04-19 10:37:09
我在跑kettle的脚本的时候出现了这样的问题;在本机windows环境下跑转换没有问题,用同样的转换放到linux服务器下面就报错;两个转换用的是同样的 数据源文本输入 配置也都一样 求各路大神解惑

错误代码如下:

org.pentaho.di.core.exception.KettleException:
Error converting line
Couldn't parse field [Timestamp] with value [2006/02/24 09:18:44.000000000], format [null] on data row [743].
79
at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:526)
at org.pentaho.di.trans.steps.fileinput.text.TextFileInputReader.readRow(TextFileInputReader.java:311)
at org.pentaho.di.trans.steps.fileinput.BaseFileInputStep.processRow(BaseFileInputStep.java:205)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.pentaho.di.core.exception.KettleException:
Couldn't parse field [Timestamp] with value [2006/02/24 09:18:44.000000000], format [null] on data row [743].
79
at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:433)
... 4 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 79
at sun.util.calendar.BaseCalendar.getCalendarDateFromFixedDate(BaseCalendar.java:453)
at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:2397)
at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:2312)
at java.util.Calendar.complete(Calendar.java:2268)
at java.util.Calendar.get(Calendar.java:1826)
at java.text.SimpleDateFormat.subFormat(SimpleDateFormat.java:1119)
at java.text.SimpleDateFormat.format(SimpleDateFormat.java:966)
at java.text.SimpleDateFormat.format(SimpleDateFormat.java:936)
at java.text.DateFormat.format(DateFormat.java:345)
at org.pentaho.di.core.row.value.timestamp.SimpleTimestampFormat.parse(SimpleTimestampFormat.java:373)
at java.text.DateFormat.parse(DateFormat.java:364)
at org.pentaho.di.core.row.value.timestamp.SimpleTimestampFormat.parse(SimpleTimestampFormat.java:449)
at org.pentaho.di.core.row.value.ValueMetaTimestamp.convertStringToTimestamp(ValueMetaTimestamp.java:255)
at org.pentaho.di.core.row.value.ValueMetaTimestamp.convertData(ValueMetaTimestamp.java:417)
at org.pentaho.di.core.row.value.ValueMetaTimestamp.convertDataFromString(ValueMetaTimestamp.java:384)
at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:393)
... 4 more
...全文
911 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

7,394

社区成员

发帖
与我相关
我的任务
社区描述
其他数据库开发 数据仓库
社区管理员
  • 数据仓库
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧