I have a transformation that pulls data from a remote oracle database which gets authenticated using oracle wallet over SSL. I have created an oracle wallet and configured the oracle side of things and I can connect fine via sqlplus.

In the Kettle repo I have a defined a connection to oracle using OCI and this also connects just fine and I can explore the database etc. I can preview the table input steps in the transformations as well.

The issue I am seeing is that the transformation fails intermittently with ORA-29024: Certificate validation failure. Basically I can run the transformation n times and then it while fail once, then run fine again a few times and then fail, always with the same ORA-29024 error.

OS: Windows Server 2003 R2

java version "1.6.0_22"
Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
Java HotSpot(TM) Client VM (build 17.1-b03, mixed mode)

PDI pdi-ce-4.1.3-r15020

Any help much appreciated I'm really stuck here.