kettle用了很長時間了，近期在資料庫連接成功的情況下，運行轉換來傳輸表資料的時候出現一個“無法從套接字讀取更多的資料”的問題，錯誤日志還提示驅動有問題，但現在的jdbc包已經用了很長時間了，而且資料庫連接是正確的。大神有遇到過這種情況的嗎？是什么問題啊？以下是運行轉換時的錯誤日志：
2019/08/13 10:12:21 - Spoon - 正在打開轉換 [sp_bord_dc_gfc]...
2019/08/13 10:12:21 - Spoon - 開始執行轉換.
2019/08/13 10:12:22 - sp_bord_dc_gfc - 為了轉換解除補丁開始 [sp_bord_dc_gfc]
2019/08/13 10:13:22 - SCM_BORDERHEAD_TMP1002.0 - Connected to database [SCM] (commit=1000)
2019/08/13 10:13:42 - SCM_borderdetail 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : An error occurred intialising this step:
2019/08/13 10:13:42 - SCM_borderdetail 2.0 - Error occurred while trying to connect to the database
2019/08/13 10:13:42 - SCM_borderdetail 2.0 -
2019/08/13 10:13:42 - SCM_borderdetail 2.0 - Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
2019/08/13 10:13:42 - SCM_borderdetail 2.0 - 無法從套接字讀取更多的資料
2019/08/13 10:14:02 - borderhead_1002.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : An error occurred, processing will be stopped:
2019/08/13 10:14:02 - borderhead_1002.0 - Error occurred while trying to connect to the database
2019/08/13 10:14:02 - borderhead_1002.0 -
2019/08/13 10:14:02 - borderhead_1002.0 - Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
2019/08/13 10:14:02 - borderhead_1002.0 - 無法從套接字讀取更多的資料
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 錯誤初始化步驟[SCM_borderdetail 2]
2019/08/13 10:14:02 - borderhead_1002.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 錯誤初始化步驟[borderhead_1002]
2019/08/13 10:14:02 - sp_bord_dc_gfc - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 步驟 [borderhead_1002.0] 初始化失敗!
2019/08/13 10:14:02 - sp_bord_dc_gfc - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 步驟 [SCM_borderdetail 2.0] 初始化失敗!
2019/08/13 10:14:02 - borderhead_1002.0 - Finished reading query, closing connection.
2019/08/13 10:14:02 - borderdetail_1002.0 - Finished reading query, closing connection.
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error rolling back the database connection.
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - Unable to get database metadata from this database connection
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at java.lang.Thread.run (Thread.java:748)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.ui.spoon.trans.TransGraph$29.run (TransGraph.java:4035)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.trans.Trans.prepareExecution (Trans.java:1113)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose (TableOutput.java:610)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:832)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.core.database.Database.rollback (Database.java:840)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData (Database.java:2745)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 -
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2747)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:840)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.core.database.Database.rollback(Database.java:832)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:610)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1113)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.ui.spoon.trans.TransGraph$29.run(TransGraph.java:4035)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at java.lang.Thread.run(Thread.java:748)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - Caused by: java.lang.NullPointerException
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:2745)
2019/08/13 10:14:02 - SCM_borderdetail 2.0 - ... 6 more
2019/08/13 10:14:02 - Spoon - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : sp_bord_dc_gfc: preparing transformation execution failed
2019/08/13 10:14:02 - Spoon - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleException:
2019/08/13 10:14:02 - Spoon - 無法初始化至少一個步驟. 執行無法開始!
2019/08/13 10:14:02 - Spoon -
2019/08/13 10:14:02 - Spoon -
2019/08/13 10:14:02 - Spoon - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1142)
2019/08/13 10:14:02 - Spoon - at org.pentaho.di.ui.spoon.trans.TransGraph$29.run(TransGraph.java:4035)
2019/08/13 10:14:02 - Spoon - at java.lang.Thread.run(Thread.java:748)
2019/08/13 10:14:02 - sp_bord_dc_gfc - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 錯誤被檢測到!
2019/08/13 10:14:02 - sp_bord_dc_gfc - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : 錯誤被檢測到!
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/52779.html
標籤：數據倉庫
上一篇：高并發下事務讀寫是否問題？
下一篇：flyway如何回滾到上一個版本