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

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 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?