yenuo4977 2016-08-01 06:58 采纳率: 0%
浏览 7740
已结题

Kettle的转换保存打开问题,一个神奇的问题

自己设置的转换在保存时爆出以下问题
图片说明
点击细节显示如下问题,求各位大神帮忙解决下:
org.pentaho.di.core.exception.KettleException:
转换无法打开 [654321]

一个数据库错误发生在从资源库文件读取转换时

CREATED_DATE String : couldn't convert string [2016-08-01 14:45:40] to a date using format [yyyy/MM/dd HH:mm:ss.SSS]
Unparseable date: "2016-08-01 14:45:40"

at org.pentaho.di.trans.Trans.<init>(Trans.java:491)
at org.pentaho.di.ui.spoon.trans.TransGraph.start(TransGraph.java:3317)
at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:924)
at org.pentaho.di.ui.spoon.Spoon$31$1.run(Spoon.java:7627)
at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7051)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8311)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)

Caused by: org.pentaho.di.core.exception.KettleException:
一个数据库错误发生在从资源库文件读取转换时

CREATED_DATE String : couldn't convert string [2016-08-01 14:45:40] to a date using format [yyyy/MM/dd HH:mm:ss.SSS]
Unparseable date: "2016-08-01 14:45:40"

at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:526)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:255)
at org.pentaho.di.trans.Trans.<init>(Trans.java:469)
... 16 more

Caused by: org.pentaho.di.core.exception.KettleValueException:
CREATED_DATE String : couldn't convert string [2016-08-01 14:45:40] to a date using format [yyyy/MM/dd HH:mm:ss.SSS]
Unparseable date: "2016-08-01 14:45:40"

at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:619)
at org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1670)
at org.pentaho.di.core.row.RowMeta.getDate(RowMeta.java:245)
at org.pentaho.di.core.RowMetaAndData.getDate(RowMetaAndData.java:208)
at org.pentaho.di.core.RowMetaAndData.getDate(RowMetaAndData.java:203)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadRepTrans(KettleDatabaseRepositoryTransDelegate.java:591)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:441)
... 18 more

Caused by: java.text.ParseException: Unparseable date: "2016-08-01 14:45:40"
at java.text.DateFormat.parse(DateFormat.java:337)
at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:614)
... 24 more

  • 写回答

2条回答 默认 最新

  • Ginna1993 2016-08-01 07:59
    关注

    kettle 中要是把时间日期作为变量 一般不都是 不加-和/直接写 201608就可以了

    评论

报告相同问题?

悬赏问题

  • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料