Kettle读取运行ktr转换出错

aaaa94364936 2017-03-09 06:22:39
我用的Kettle6.0连接MySQL5.6.24,因为MySQL不支持Boolean类型,我在新建资源库的时候,把Kettl的那些R_的表格及数据都使用的网上提供的代码(其实就是改了一下那些插入到Boolean的字段类型)

做一个简单的转换:表输入->字段选择->表输出,把一个表的数据复制到另一个表中,预览和调试都可以查询到输出表中的数据,但是点击运行,就会报错,求助。PS:打开之前的ktr文件,也会报相同的错误,如下:

org.pentaho.di.core.exception.KettleException:
转换无法打开 [转换 1]

一个数据库错误发生在从资源库文件读取转换时
at org.pentaho.commons.launcher.Launcher.main (Launcher.java:92)
at java.lang.reflect.Method.invoke (Method.java:483)
at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)
at org.pentaho.di.ui.spoon.Spoon.main (Spoon.java:653)
at org.pentaho.di.ui.spoon.Spoon.start (Spoon.java:9214)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose (Spoon.java:7939)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch (Spoon.java:1339)
at org.eclipse.swt.widgets.Display.readAndDispatch (null:-1)
at org.eclipse.swt.widgets.Display.runAsyncMessages (null:-1)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages (null:-1)
at org.eclipse.swt.widgets.RunnableLock.run (null:-1)
at org.pentaho.di.ui.spoon.Spoon$31$1.run (Spoon.java:8468)
at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation (SpoonTransformationDelegate.java:881)
at org.pentaho.di.ui.spoon.trans.TransGraph.start (TransGraph.java:3601)
at org.pentaho.di.trans.Trans.<init> (Trans.java:574)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation (KettleDatabaseRepository.java:278)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation (KettleDatabaseRepositoryTransDelegate.java:576)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransHopMeta (KettleDatabaseRepositoryTransDelegate.java:1151)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.loadStepMeta (KettleDatabaseRepositoryStepDelegate.java:197)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.loadStepAttributesMap (KettleDatabaseRepositoryStepDelegate.java:441)


at org.pentaho.di.trans.Trans.<init>(Trans.java:598)
at org.pentaho.di.ui.spoon.trans.TransGraph.start(TransGraph.java:3601)
at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:881)
at org.pentaho.di.ui.spoon.Spoon$31$1.run(Spoon.java:8468)
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:1339)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9214)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:653)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Caused by: org.pentaho.di.core.exception.KettleException:
一个数据库错误发生在从资源库文件读取转换时
at org.pentaho.commons.launcher.Launcher.main (Launcher.java:92)
at java.lang.reflect.Method.invoke (Method.java:483)
at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)
at org.pentaho.di.ui.spoon.Spoon.main (Spoon.java:653)
at org.pentaho.di.ui.spoon.Spoon.start (Spoon.java:9214)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose (Spoon.java:7939)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch (Spoon.java:1339)
at org.eclipse.swt.widgets.Display.readAndDispatch (null:-1)
at org.eclipse.swt.widgets.Display.runAsyncMessages (null:-1)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages (null:-1)
at org.eclipse.swt.widgets.RunnableLock.run (null:-1)
at org.pentaho.di.ui.spoon.Spoon$31$1.run (Spoon.java:8468)
at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation (SpoonTransformationDelegate.java:881)
at org.pentaho.di.ui.spoon.trans.TransGraph.start (TransGraph.java:3601)
at org.pentaho.di.trans.Trans.<init> (Trans.java:574)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation (KettleDatabaseRepository.java:278)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation (KettleDatabaseRepositoryTransDelegate.java:576)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransHopMeta (KettleDatabaseRepositoryTransDelegate.java:1151)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.loadStepMeta (KettleDatabaseRepositoryStepDelegate.java:197)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.loadStepAttributesMap (KettleDatabaseRepositoryStepDelegate.java:441)

at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:673)
at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278)
at org.pentaho.di.trans.Trans.<init>(Trans.java:574)
... 16 more
Caused by: java.lang.NullPointerException
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.loadStepAttributesMap(KettleDatabaseRepositoryStepDelegate.java:441)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.loadStepMeta(KettleDatabaseRepositoryStepDelegate.java:197)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransHopMeta(KettleDatabaseRepositoryTransDelegate.java:1151)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:576)
... 18 more


求教大家该如何解决啊?
...全文
771 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

7,388

社区成员

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

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