kettle 抽数时灵时不灵
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.