0 Replies Latest reply: Jan 8, 2015 3:44 PM by 980762 RSS

    Broken pipe

    980762

      Not sure if this is the right forum to ask this question, but I am having a connectivity issiu.
      am getting broken pipe errors while disconnecting from a database on a remote tool.
      any idea what can cause this?

      part of the log file:

      INFO 18-12 15:46:16,032 - EH_TBL_EH_Insert_EH_TBL_EH - Connected to database [WESTECDBEH] (commit=1000)
      ERROR 18-12 15:46:16,033 - EH_TBL_EH-MaxDate - Unexpected error :
      ERROR 18-12 15:46:16,033 - EH_TBL_EH-MaxDate - org.pentaho.di.core.exception.KettleDatabaseException:
      An error occurred executing SQL:
      SELECT nvl(max(clock), sysdate - 40) as sc FROM SYSADM.EH_TBL_EH
      No more data to read from socket
      org.pentaho.di.core.database.Database.openQuery(Database.java:1869)
      org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:221)
      org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:130)
      org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
      java.lang.Thread.run(Thread.java:662)

      INFO 18-12 15:46:16,034 - EH_TBL_EH-MaxDate - Finished reading query, closing connection.
      ERROR 18-12 15:46:16,034 - WESTECDBEH - Error disconnecting from database:

      Error comitting connection
      Io exception: Broken pipe

      ERROR 18-12 15:46:16,034 - WESTECDBEH - org.pentaho.di.core.exception.KettleDatabaseException:
      Error comitting connection
      Io exception: Broken pipe
      org.pentaho.di.core.database.Database.commit(Database.java:693)
      org.pentaho.di.core.database.Database.commit(Database.java:663)
      org.pentaho.di.core.database.Database.disconnect(Database.java:554)

      Thanks,
      Paul