We upgraded our production Windows 2003 ETL server from pdi version 3.1.0 to 4.1.0 on 9/16/2011 . The ETL jobs are randomly failing with the following example error:

ERROR 22-09 08:45:20,977 - ODE Division - org.pentaho.di.core.exception.KettleDatabaseException:
SHRS_Delta - Output : An error occurred executing SQL:
Command - SHRS_Delta - Output : SELECT division_code,
Command - SHRS_Delta - Output : division ,
Command - SHRS_Delta - Output : division_director,
Command - SHRS_Delta - Output : division_director_title,
Command - SHRS_Delta - Output : division_phone ,
Command - SHRS_Delta - Output : pma_coordinator ,
Command - SHRS_Delta - Output : pma_coordinator_title ,
Command - SHRS_Delta - Output : division_mail_code
Command - SHRS_Delta - Output : FROM ODE_DIVISION
Command - SHRS_Delta - Output : ORDER BY division_code
Command - SHRS_Delta - Output : Closed Connection
Command - SHRS_Delta - Output : org.pentaho.di.core.database.Database.openQuery(Database.java:1864)
Command - SHRS_Delta - Output : org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:221)
Command - SHRS_Delta - Output : org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:130)
Command - SHRS_Delta - Output : org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
Command - SHRS_Delta - Output : java.lang.Thread.run(Unknown Source)


The ETL server is a Windows 2003 Server with 4GB ram. We utilize Auomize (HiTek Software LLc) scheduling software to manage the execution of the Pentaho Jobs. Automize runs the kjb files using kitchen.bat.

OJDBC14.JAR - Oracle jdbc driver

JRE version
java version "1.6.0_26"
Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
Java HotSpot(TM) Client VM (build 20.1-b02, mixed mode, sharing)

Database
Oracle Database 10g 10.2.0.4.0

Our ETL jobs have successfully completed in this infrastructure configuration for approximately 2 years while using PDI version 3.1.0. Any solutions will be appreciated. Without a fix, we will be forced to rollback to pdi 3.1.0


Thanks,

Ed