Kettle) used for a long time, in the near future under the condition of the database connection is successful, run the transformation to transmit when table data to a "could not read more data from the socket" problem, error log also suggests there is something wrong with the driver, but now the JDBC package has been used for a long time, and the database connection is correct, the great god has encountered this kind of situation? What's the problem? The following is the error log when run the transformation:
2019/08/13 10:12:21 - Spoon - are open conversion [sp_bord_dc_gfc]...
2019/08/13 10:12:21 - Spoon - began to perform the conversion.
2019/08/13 10:12:22 sp_bord_dc_gfc - to transform to remove patch began [sp_bord_dc_gfc]
2019/08/13 10:13:22 - SCM_BORDERHEAD_TMP1002. 0 and Connected to the database (SCM) (commit=1000)
2019/08/13 10:13:42 SCM_borderdetail - 2.0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : An ERROR occurred intialising this step:
2019/08/13 10:13:42 SCM_borderdetail - 2.0 - the 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 the database: (using class. Oracle JDBC. Driver. OracleDriver)
2019/08/13 10:13:42 SCM_borderdetail - 2.0 - could not read more data from the socket
2019/08/13 10:14:02 - borderhead_1002. 0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : An ERROR occurred, processing will be stopped:
2019/08/13 10:14:02 - borderhead_1002. 0 - the 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 the database: (using class. Oracle JDBC. Driver. OracleDriver)
2019/08/13 10:14:02 - borderhead_1002. 0 - could not read more data from the socket
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : an initialization ERROR step [2] SCM_borderdetail
2019/08/13 10:14:02 - borderhead_1002. 0 - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : an initialization ERROR step [borderhead_1002]
2019/08/13 10:14:02 sp_bord_dc_gfc - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : steps [borderhead_1002. 0] initialization failed!
2019/08/13 10:14:02 sp_bord_dc_gfc - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : steps [2.0] SCM_borderdetail initialization failed!
2019/08/13 10:14:02 - borderhead_1002. 0 - Finished reading query, closing the connection.
2019/08/13 10:14:02 - borderdetail_1002. 0 - Finished reading query, closing the connection.
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - ERROR (version 6.1.0.1-196, build 1 from the 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 the 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 the database metadata from this database connection
2019/08/13 10:14:02-2.0 at Java SCM_borderdetail. Lang. Thread. The run (748) Thread. Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. UI. Spoon. Trans. TransGraph $29. The run (4035) TransGraph. Java:
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. The dispose (tableoutput. Java: 610)
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. Core. The database. The database. The rollback (832). The database Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. Core. The database. The database. The rollback (840). The database Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. Core. The database. The database. The getDatabaseMetaData (2745). The database Java:
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. The database. The database. The getDatabaseMetaData (2747). The database Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. Core. The database. The database. The rollback (840). The database Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. Core. The database. The database. The rollback (832). The database Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. Trans. Steps. Tableoutput. Tableoutput. The 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. The run (4035) TransGraph. Java:
2019/08/13 10:14:02-2.0 at Java SCM_borderdetail. Lang. Thread. The run (748) Thread. Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - under Caused by: Java. Lang. NullPointerException
2019/08/13 10:14:02 SCM_borderdetail - 2.0 - at org. Pentaho. Di. Core. The database. The database. The getDatabaseMetaData (2745). The database Java:
2019/08/13 10:14:02 SCM_borderdetail - 2.0 -... Six more
2019/08/13 10:14:02 - Spoon - ERROR (version 6.1.0.1-196, build 1 from the 2016-04-07 12.08.49 by buildguy) : sp_bord_dc_gfc: preparing the transformation execution failed
nullnullnullnullnullnullnullnullnull