View Full Version : Commit in Kettle
03-28-2006, 01:34 AM
Whenever there is a error in the transaction, the tranaction breaks up abruptly. Is there any way I can insert that erronous record into a Exception Table and proceed with other records
03-28-2006, 01:41 AM
Not yet. Kettle was never designed to do this. In a data warehouse environment, you don't want to have ANY errors.
We can ignore errors in TableOutput (batch processing needs to be turned off) but the error text itself is not yet captured.
Please file a feature request for this, it's not that hard to program I guess.
03-28-2006, 04:54 AM
If I ignore errors in input is there any way I can know what are all the erronous records,
03-28-2006, 04:56 AM
no, see above.
03-30-2006, 04:02 AM
Is there any Log files that captures this error messages.
03-30-2006, 04:04 AM
Yes, in the standard logging to console, file or database.
But only the first 20 occurances.