I've have transformation that does a text file input followed by 2 database lookup. This runs fine originally but I know encountered the following error in one of the database lookup:-

Get Security Key.0 - ERROR (version 2.4.0, build 742 from 2007/01/27 12:29:00) : Unexpected error : java.lang.NumberFormatException: For input string: "E.42200707E4"

The strange thing is that when I change the log settings to either debug or rowlevel (and nothing) to locate the error, the transformation work without a glitch.

Does anybody has any idea what's the cause for this?

Tks & Rgds