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
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
Hi Sabrina, Merry Christmas,
Any Update on this issue???
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.
Sorry for delay. I'm making a testing for your current case to see if there is any better solution for SQL SERVER then come back to you asap. Best regards Sabrina
Hi,
Sorry for delay.
For your requirement, would you mind opening a work item jira issue of DI project so that our develop will check if SQL Server can get the specified column on which truncation happens. Thanks for your understanding.
Best regards
Sabrina
