Seven Stars

data truncation error

Dear Sir 

am facing data truncation error when delimit file data move into MSSql output. am already read truncation related post on Talend Community but unable to resolve. 

db_error_trauncation.JPG

8 REPLIES
Nine Stars

Re: data truncation error

Hi,

 

Does source and target has same datatype and length for every attribute?

 

Regards,

 

Veeru Boppudi
Twelve Stars

Re: data truncation error

Data truncation will get,when input column length is lower than output column
Manohar B
Moderator

Re: data truncation error

Hello,

Here is a KB article about:https://community.talend.com/t5/Design-and-Development/quot-Data-truncation-Data-too-long-for-column....

Hope it will help.

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.
Seven Stars

Re: data truncation error

i have already done it but its not work for me.
Community Manager

Re: data truncation error

Hi
Do you create the table on tMSSQLOutput component or Does the tables already exist in database?
For testing, you can print the length of column value on the console to see if it exceeds the maximum size of the field.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Seven Stars

Re: data truncation error

am created table for tMSSQL component. i couldn't understand print the lenght of column value on the console. how it will done?
Twelve Stars

Re: data truncation error

@bksingh,you need to get max column length linke below.

 

Job

Untitled.png

tmap

Untitled.png

 

tAggregaterow

Untitled.png

 

Manohar B
Twelve Stars

Re: data truncation error

@bksingh,still do you have issue?

Manohar B