Hello,

I am facing a pentaho transformation issue. Basically, My application used to connect DB2 database and get the records and then insert into oracle database. But randomly I am getting the below error message which says that communication error occured. I am using JDBC drive to connect 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


Please advise me to resolve the issue asap.

Thanks in advance
-Dhana