topic data truncation error in Talend Studio

data truncation error

Anonymous — Mon, 09 Apr 2018 08:27:11 GMT

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.

Re: data truncation error

vboppudi — Mon, 09 Apr 2018 14:53:52 GMT

Hi,

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

Regards,

Re: data truncation error

manodwhb — Tue, 10 Apr 2018 01:51:02 GMT

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

Re: data truncation error

Anonymous — Tue, 10 Apr 2018 07:35:32 GMT

Hello,

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

Hope it will help.

Best regards

Sabrina

Re: data truncation error

Anonymous — Tue, 10 Apr 2018 08:18:15 GMT

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

Re: data truncation error

Anonymous — Tue, 10 Apr 2018 09:25:02 GMT

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

Re: data truncation error

Anonymous — Tue, 10 Apr 2018 10:29:16 GMT

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

Re: data truncation error

manodwhb — Thu, 19 Apr 2018 06:29:28 GMT

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

Job

tmap

tAggregaterow

Re: data truncation error

manodwhb — Fri, 20 Apr 2018 12:32:04 GMT

@ksingh,still do you have issue?