Error capturing and logging

Rohit_Bajaj

Hi All,

I wanted to know is there any easy way to capture various errors which might occur during moving data from one place to another.

Even capturing this in form of error logs and later parsing in a readable format should be ok.

The requirement is to capture basic data movement technical errors (and not functional errors). Some of the examples might be -

1) Data Truncation Errors.

2) Precision Related Errors etc.

These errors can occur in any of the transformations, starting from input till output and in between transformations.

Is there also a way to increase the logging level to capture details at record level, error type level.

Any help in this regard is highly appreciated.

Thanks,

Rohit

NeilR

It appears as though shortening field length in a select tool does not result in truncation warnings. So a couple suggestions would be:

1. use a formula tool to create a new field of the desired length and set it equal to the long field, as attached. you will get the truncation warning.
2. proactively calculate the max length of a field to see if it's greater than the desired length. you can even output a custom warning, as attached.

If you think it's appropriate for the select tool to output the truncation warning, I'd advise you to post your suggestion to the Ideas section.

truncation.yxmd