topic Re: What column is causing Data Truncation? in Talend Studio

What column is causing Data Truncation?

Anonymous — Sat, 16 Nov 2024 03:16:33 GMT

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

Re: What column is causing Data Truncation?

Anonymous — Thu, 13 Feb 2020 17:03:07 GMT

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

Re: What column is causing Data Truncation?

nivedhitha — Thu, 13 Feb 2020 17:36:41 GMT

@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.

Re: What column is causing Data Truncation?

Anonymous — Fri, 14 Feb 2020 17:22:13 GMT

Thanks @nivedhitha I will give that a try

Thanks

Steve

Re: What column is causing Data Truncation?

nivedhitha — Fri, 14 Feb 2020 18:53:03 GMT

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

Re: What column is causing Data Truncation?

Anonymous — Mon, 04 May 2020 16:46:18 GMT

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

Re: What column is causing Data Truncation?

nivedhitha — Mon, 04 May 2020 16:52:26 GMT

@abouzigon , no worries