title: MySQL Pentaho communication link error ETL
body: <p>When trying to load one month data from DW by the last day of the month or second last day of the month, while loading the data, communication link error comes and it stops the running job. due to this last few set of data is not loading. </p>
  
  <p>About transformation steps used:</p>
  
  <p><strong>Table Input-> DB JOIN -> Stream Lookup-> Table output</strong></p>
  
  <p>please help on this. We are stuck with this.. </p>
  
  <pre><code>2019/01/11 05:42:18 - Table input.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException: 
  2019/01/11 05:42:18 - Table input.0 - Couldn't close query: resultset or prepared statements
  2019/01/11 05:42:18 - Table input.0 - **Communications link failure**
  2019/01/11 05:42:18 - Table input.0 - 
  2019/01/11 05:42:18 - Table input.0 - **The last packet successfully received from the server was 109 milliseconds ago.  The last packet sent successfully to the server was 22 milliseconds ago.**
  </code></pre>