How to capture Data truncation?

[briansms]

How can "Data truncation" messages from a DBOutput be captured? I have it's Rejects flow going to a file, but none of the data truncation messages are in there.
Thanks,
- Brian

[Anonymous]

Hello
Which version of TOS are you using?
I tested this issue with TOS2.4.1, it shows the 'data truncation' error message.
Best regards

shong

[briansms]

Hi Shong,
I'm using both 2.3.3 and 2.4.1, but it's my mistake. Apparently I was looking at the wrong table.
I do notice however that your message above includes the field name in the message: "Data truncation: Data too long for field 'name'..."
The message from MSSSQLOutput is simply "Data truncation", it doesn't tell which field has the offending data. How do you get the field name in there? (I'm outputting the rejects row to a tFileOutputDelimited)

classstructureid|assetattrid|measureunitid|domainid|defaultnumvalue|defaultalnvalue|attrdescprefix|useinitemspec|itemsequence|itemrequirevalue|useinitemdesc|useinassetspec|assetsequence|assetrequirevalue|useinassetdesc|useinlocspec|locsequence|locrequirevalue|useinlocdesc|cs01|cs02|cs03|cs04|cs05|orgid|section|siteid|classspecid|rowstamp|errorCode|errorMessage
2007|CHRGCIRC1||||||0|4|0|0|1|4|0|1|1|4|0|0|||||||||1093|||Data truncation
2007|CHRGCIRC2||||||0|5|0|0|1|5|0|1|1|5|0|0|||||||||1094|||Data truncation
2007|CHRGCIRC3||||||0|6|0|0|1|6|0|1|1|6|0|0|||||||||1095|||Data truncation
2007|HEATINPUT||||||0|7|0|0|1|7|0|1|1|7|0|0|||||||||1096|||Data truncation

Thanks,
- Brian

[_AnonymousUser]

I am getting the same thing.. I am not given column name for which data truncation occurs.. i am storing rejected rows in file and sending it in email..It is not telling me which column is truncated.
Can anyone help?

[_AnonymousUser]

I am getting the same thing.. I am not given column name for which data truncation occurs.. i am storing rejected rows in file and sending it in email..It is not telling me which column is truncated.
Can anyone help?

[_AnonymousUser]

Hi,
Please check whether the input & output columns are in the same order.
Regards
Deepak

[Anonymous]

I am also facing issue...where i am using tmssqloutput
I want to know on which column the data truncation is happening so I can rectify the same.
Kindly find the actual scenario in linked screenshot below
Please help

[Anonymous]

used tSchemaComplianceCheck component after tMap and before your tmssqloutput component and then used reject link from tSchemaComplianceCheck component it will give you data truncation with column name and error code.
Hope this will help you

[Anonymous]

Hey Umesh, thanks for reply.
i have tried the same as you have suggested but not working.
In my source file City field contains 'Mumbai'(6 characters) but my corresponding CITY column of table is length 5.
It should give me the error like "Data truncation on CITY column....."
How can i get it???

[Anonymous]

Hi,
Here is KB article on Talend Help Center about Exception Data truncation Data too long for column, hope it will be helpful.
Best regards
Sabrina