What column is causing Data Truncation?

[Anonymous]

Hi, I have searched the forums and not found any helpful replies to previous similar topics.

I am getting the following error in a job:

[ERROR]: projename.jobname - tDBOutput_1 - Data truncation

Not a very helpful message at all as it is not telling which column the truncation is occurring on, making it difficult to troubleshoot.

Although I can investigate this outside of Talend and eventually find the solution, is there a way of telling the component to report the field(s) the truncation is occurring on?  Would be very handy

Thanks

Steve

[Anonymous]

can you post your job plz?
sounds strange as error message

[nivedhitha · Accepted solution]

@abouzigon ,

You can try using a tSchemaComplianceCheck (its schema same as the Dboutput component) component before your tDbOutput and connect main to DbOutput and write the rejects to a file. It will give you the records that don't conform to the output schema along with reasons as to why they were rejected.

[Anonymous]

Thanks @nivedhitha I will give that a try

Thanks

Steve

[nivedhitha]

@abouzigon , Let me know if it doesn't work

[Anonymous]

Apologies it's taken so long. This sorted it for me thank you

[nivedhitha]

@abouzigon , no worries