|Available in: Logi Info|| Source code name: IfEtlError|
IfEtlError helps handle errors while running ETL job elements. Errors include events such as failure to update a database, run a report, save a file. Without IfEtlError elements, the system logs an error page detailing the original error.
Add elements under the IfEtlError to perform error-handling work.
IfEtlError elements can be added at any levels. Errors "bubble up" until an IfError is found. If an element fails, and that element does not have its own IfEtlError element, the system looks up at the parent levels for an IfEtlError.
If there are no EndJob elements under an IfError, execution resumes with the element following the failed procedure. Thus an error can be completely ignored by not adding any child elements below the IfError.
An error might occur in an element under an IfEtlError, so you may include error handling within error handling. You may have additional IfEtlError elements under that element. Otherwise, the error will bubble-up to the Task and Process levels.
In order to perform different actions based on different errors, IfEtlError has an optional ErrorFilter attribute. Add an IfEtlError for each different type of error. The server looks for the first IfError that matches the current error. Usually the last IfEtlError should have a blank ErrorFilter to catch left-over errors.
To get the error message text use "@Function.LastErrorMessage~".