Kettle读取运行ktr转换出错
我用的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
求教大家该如何解决啊?