利用kettle的表輸入、表輸出將資料從sqlserver庫匯入到oracle庫，執行程序中遇到以下錯誤：
2020/08/20 16:33:46 - 表輸出.0 - linenr 2750000
2020/08/20 16:33:46 - 表輸入.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unexpected error
2020/08/20 16:33:46 - 表輸入.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2020/08/20 16:33:46 - 表輸入.0 - Couldn't get row from result set
2020/08/20 16:33:46 - 表輸入.0 - I/O Error: Connection reset
2020/08/20 16:33:46 - 表輸入.0 -
2020/08/20 16:33:46 - 表輸入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2546)
2020/08/20 16:33:46 - 表輸入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2516)
2020/08/20 16:33:46 - 表輸入.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:114)
2020/08/20 16:33:46 - 表輸入.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/08/20 16:33:46 - 表輸入.0 - at java.lang.Thread.run(Thread.java:748)
2020/08/20 16:33:46 - 表輸入.0 - Caused by: java.sql.SQLException: I/O Error: Connection reset
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2481)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:805)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:611)
2020/08/20 16:33:46 - 表輸入.0 - at org.pentaho.di.core.database.Database.getRow(Database.java:2534)
2020/08/20 16:33:46 - 表輸入.0 - ... 4 more
2020/08/20 16:33:46 - 表輸入.0 - Caused by: java.net.SocketException: Connection reset
2020/08/20 16:33:46 - 表輸入.0 - at java.net.SocketInputStream.read(SocketInputStream.java:210)
2020/08/20 16:33:46 - 表輸入.0 - at java.net.SocketInputStream.read(SocketInputStream.java:141)
2020/08/20 16:33:46 - 表輸入.0 - at java.io.DataInputStream.readFully(DataInputStream.java:195)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:885)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:731)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:146)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.ResponseStream.readString(ResponseStream.java:301)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.ResponseStream.readNonUnicodeString(ResponseStream.java:285)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.TdsData.readData(TdsData.java:961)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.TdsCore.tdsRowToken(TdsCore.java:3175)
2020/08/20 16:33:46 - 表輸入.0 - at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2433)
2020/08/20 16:33:46 - 表輸入.0 - ... 7 more
2020/08/20 16:33:46 - 表輸入.0 - Finished reading query, closing connection.
2020/08/20 16:33:46 - 表輸入.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
2020/08/20 16:33:46 - 表輸入.0 - Couldn't close query: resultset or prepared statements
2020/08/20 16:33:46 - 表輸入.0 - Invalid state, the Connection object is closed.
求大神說明原因，提供解決方法。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/14898.html
標籤：其他技術專區
上一篇：買了渦街流量計知道怎么用嗎
下一篇：炸藥與氣體爆炸