Hello,

I am facing pentaho error while running a transformation. Basically what my job is doing, connect to DB2 database and get the records and then insert into oracle database. So I am getting below error message while fetching records from DB2 database. Using JDBC driver to get the records from DB2 database.

org.pentaho.di.core.exception.KettleDatabaseException:
Couldn't get row from result set
A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: Connection reset. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
at org.pentaho.di.core.database.Database.getRow(Database.java:2869)
at org.pentaho.di.core.database.Database.getRow(Database.java:2784)
at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:137)
at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:345)
Caused by: com.ibm.db2.jcc.b.DisconnectException: A communication error has been detected. Communication protocol being used: Reply.fill(). Communication API being used: InputStream.read(). Location where the error was detected: Connection reset. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
at com.ibm.db2.jcc.a.a.a(a.java:428)
at com.ibm.db2.jcc.a.ab.b(ab.java:175)
at com.ibm.db2.jcc.a.ab.c(ab.java:222)
at com.ibm.db2.jcc.a.ab.d(ab.java:236)
at com.ibm.db2.jcc.a.db.a(db.java:1911)
at com.ibm.db2.jcc.a.eb.a(eb.java:134)
at com.ibm.db2.jcc.a.eb.a(eb.java:34)
at com.ibm.db2.jcc.a.s.a(s.java:30)
at com.ibm.db2.jcc.a.h.Gb(h.java:325)
at com.ibm.db2.jcc.b.rc.R(rc.java:3022)
at com.ibm.db2.jcc.a.d.nb(d.java:1152)
at com.ibm.db2.jcc.a.d.a(d.java:520)
at com.ibm.db2.jcc.a.d.b(d.java:211)
at com.ibm.db2.jcc.b.r.a(r.java:198)
at com.ibm.db2.jcc.b.rc.c(rc.java:302)
at com.ibm.db2.jcc.b.rc.next(rc.java:277)
at org.pentaho.di.core.database.Database.getRow(Database.java:2799)
... 4 more

I have tried lot of analyze with network monitoring tools, but nothing is working out. The above error message is not coming regularly. Please advise me to fix the issue asap.

Thanks in advance.

-Dhana.