index out of range value for column at row

[Anonymous]

Hello,

I'm a beginner at Talend ETL and while working with the orion star ETL with mariadb, I keep facing this error when running some jobs.
The data have been insterted to a point where this error show up. 

I've made a research on the internet and found out that the data to be inserted is greater than the max value type of the column which is Double.

Then, I tried changing it to Bigdecimal, String, but I keep having the same error.

Looking for solutions in here. I attached a screenshot of the job.

Thanks.

[Anonymous]

Hello,

Could you please also post your screenshot of the expression in tMap component?

Best regards

Sabrina

[Anonymous]

Hello,

I've fixed it. 

I have changed the type of the value to BIGINT in mariaDB and data were inserted.

Changing it in tMap wasn't affecting the table in the database.

Thanks anyway.