NumberFormatException For input string: " ... " error in 2.3.3?.

[Anonymous]

Hello,

I installed the new version 2.3.3 and a job that was working fine with 2.3.1 now produce NumberFormatException For input string: "...." error, the it ends with 0 so should means that everithing was ok, but the text enclosed in the error above is not loaded in the destination table.
The job is quite complex I try to summarize here the flow that gets error:
query from oracle db --> java row component -->t_denormalize component-->another java row component-->tFileOutputDelimited component-->tFileInputDelimited component-->tMap (that joins with other two queries from oracle)-->oracle output on the destination table.
In words the work of this job is to read a number of records from the initial input table, grouped by an id and this will became a single (one) record in the final destination table.
At the moment I had to switch back to the previous release 2.3.1, so I think that is something you need to look at (a bug?).

thanks

iosman

[TRF]

Usually this message appears when a data flow contains a string where a number is expected.

As soon as the same input works fine with previous job version, you have to make a gap analysis to find differences between these 2 versions.

Start by a comparison of datatypes used into schemas.