ORA-01438 value larger than specified precision allowed but didn't specify precision

[Anonymous]

I have this job:

 When I try to run it, after compiling it gives error

java.sql.SQLDataException: ORA-01438

for component tDBOutput_2. I've put option "die on error" for this component, and it fails on the first row, but the error is the same for all the rows that join.

In this case, the first and second fields are BigDecimal, while the last one is a String.

In tMap I tried first without specifying precision, then I tried using different levels of precision, then I've tried to print the precision of the field and put that value as precision, but didn't work.

In my DB, the field of the tables are defined as NUMBER, without specifying the lenght and precision.

How can I resolve this? In the error log there is no error shown.

[iamabhishek]

In your target you have defined the column as NUMBER without any precision being set? You should had defined as per the kind of data that would flow and you would expect to flow into the table/column.
So, basically either you change how the column is defined or change the data going into this column.

Some sample data, the schema definition from both database and Talend would really help to diagnose more on this.

[manodwhb]

@Mary,first try understand the columns and those data types in target table and ,since the source files need to be taken with precision in tMap and populate to target table.