index out of range value for column at row

Highlighted
Four Stars

index out of range value for column at row

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.

Moderator

Re: index out of range value for column at row

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: index out of range value for column at row

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. 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog