ETL kettle传输表数据时报错：无法从套接字读取更多的数据

qq_39757325 2019-08-13 10:30:51

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) : 错误被检测到!

...全文