kettle 抽数时灵时不灵

[WattingLife]

kettle 工具从 sql server 里抽数，表输入（表里有数据） 点预览数据时，有时可以预览出数据，有时就报错如下

2014/06/04 15:19:17 - Spoon - Logging goes to file:///C:/Users/admin/AppData/Local/Temp/spoon_89f7e030-ebb8-11e3-8557-8da926448ae6.log
2014/06/04 15:19:19 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000
2014/06/04 15:19:20 - Spoon - 要求资源库
2014/06/04 15:19:20 - RepositoriesMeta - Reading repositories XML file: C:\Users\admin\.kettle\repositories.xml
2014/06/04 15:21:25 - /转换 1 - 为了转换解除补丁开始 [/转换 1]



2014/06/04 15:19:17 - Spoon - Logging goes to file:///C:/Users/admin/AppData/Local/Temp/spoon_89f7e030-ebb8-11e3-8557-8da926448ae6.log
2014/06/04 15:19:19 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000
2014/06/04 15:19:20 - Spoon - 要求资源库
2014/06/04 15:19:20 - RepositoriesMeta - Reading repositories XML file: C:\Users\admin\.kettle\repositories.xml
2014/06/04 15:21:09 - /转换 1 - 为了转换解除补丁开始 [/转换 1]
2014/06/04 15:21:09 - 表输入.0 - Finished reading query, closing connection.
2014/06/04 15:21:25 - /转换 1 - 为了转换解除补丁开始 [/转换 1]
2014/06/04 15:21:26 - 表输入.0 - Finished reading query, closing connection.
2014/06/04 15:21:26 - dummy.0 - 完成处理 (I=0, O=0, R=899, W=898, U=0, E=0
2014/06/04 15:21:26 - 表输入.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy)
: Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
2014/06/04 15:21:26 - 表输入.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy)
: Couldn't close query: resultset or prepared statements
2014/06/04 15:21:26 - 表输入.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy)
: Cancel has been invoked on this Statement.

[天善智能]

找个kettle相关的群问下啦

[搞怪的索引]

哪个版本的？

[唐增辉]

2016/11/08 22:18:19 - Spoon - Transformation opened. 2016/11/08 22:18:19 - Spoon - Launching transformation [test1]... 2016/11/08 22:18:19 - Spoon - Started the transformation execution. 2016/11/08 22:18:19 - test1 - Dispatching started for transformation [test1] 2016/11/08 22:18:19 - Table output.0 - Connected to database [zac] (commit=1000) 2016/11/08 22:18:19 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Because of an error, this step can't continue: 2016/11/08 22:18:19 - Table output.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2016/11/08 22:18:19 - Table output.0 - The tablename is not defined (empty) 2016/11/08 22:18:19 - Table output.0 - 2016/11/08 22:18:19 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:259) 2016/11/08 22:18:19 - Table output.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128) 2016/11/08 22:18:19 - Table output.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2016/11/08 22:18:19 - Table output.0 - at java.lang.Thread.run(Thread.java:745) 2016/11/08 22:18:19 - Table input.0 - Finished reading query, closing connection. 2016/11/08 22:18:19 - Table input.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException: 2016/11/08 22:18:19 - Table input.0 - Couldn't close query: resultset or prepared statements 2016/11/08 22:18:19 - Table input.0 - Cancel has been invoked on this Statement. 2016/11/08 22:18:19 - Table output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2016/11/08 22:18:19 - test1 - test1 2016/11/08 22:18:19 - test1 - test1 2016/11/08 22:18:19 - Table input.0 - Finished processing (I=11, O=0, R=0, W=9, U=0, E=1) 2016/11/08 22:18:19 - test1 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2016/11/08 22:18:19 - Spoon - The transformation has finished!! 2016/11/08 22:18:19 - test1 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2016/11/08 22:18:19 - test1 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2016/11/08 22:18:19 - test1 - test1 2016/11/08 22:18:19 - test1 - test1

[唐增辉]

今天下载的 pdi-ce-6.1.0.1-196 去掉 partition data over datas 选项就好了

[唐增辉]