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