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]

Dear Sabrina,
Thanks for sharing link....but i have not found it useful.
I am able to identify the issue i.e.Data Truncation but what is Next??
How should i come to know on which column the truncation happens??
I want the column name in my message.....
I have attached the screenshot of Database table output in which I am catching Errors.

[Anonymous]

Hi,
You can link "Rejects" row from tMssqloutput to check which column is rejected.
"Rejectes" is available when unchecked option " Use Batch Size".
Best regards
Sabrina

[Anonymous]

Reject option is not reflecting

[Anonymous]

Hi,

Reject option is not reflecting

It means there is no rejected row? If so, you can check the 'die on error' option on tOracleOutput and run the job again, then to see if there any detailed error message are printed on the console.
Best regards
Sabrina

[janhess]

Reject option is not reflecting

Right click on the tMSSQLOutput and select Row then Rejects.

[Anonymous]

Hi kunalrane
Is there any update for your issue, don't hesitate to post it on forum.
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
I have tried that to get the reject link but not showing but when i have shutdown the Talend and my machine then i got the link of reject when i have right clicked on tmssqloutput
So now i am transferring the rejected records in Text file but still i am not getting the specific Column name on which data truncation happens.
kindly check the same in screenshots.

[Anonymous]

Hi Sabrina,
One more issue...
As you suggested...i have uncheck the Die on error of tmssqloutput then i got the reject link
The issue is...
i am capturing database connectivity issue also(like table_name is invalid object) for that i am using tlogcather and tlogcather listens to Die on Error and if i'l uncheck the Die on Error option of tmssqloutput,i can not log the database connectivity issue.
Can you help me how can i handle the both the scenario in one board

[Anonymous]

Hi,
There is no specific Column name in error messgae(just line1;line2;....).
You have to use "Die on Error" or rejected in two board. The "rejected" row is unavailable if you checked out "Die on error".

you can check the 'die on error' option on tOracleOutput and run the job again, then to see if there any detailed error message are printed on the console.

.
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
I have tried the same thing with Oracle output.
And i got the specified column on which truncation happens.
Thanks for the same but what about SQL Server Output.
I am trying to Use Sql server.
Kindly help me to sort this out.