Element Details: If+ETL+Error
 Back


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



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ErrorFilter
UserDefined
Error Filter allows individual IfError elements to handle different errors. Set the Error Filter to any text found within the Error message. If the text is found, the IfError will handle the error. Otherwise, if there is one, the next IfError element will be checked. Leave Error Filter blank to process all errors.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.



PARENT ELEMENTS

Click element to drill down for more information.

Email.Message
Etl Job
Execute.OS Command
Execute.Plugin Call
Execute.Script
Execute.SP
Execute.SQL
Extract
File.Copy
File.Delete
File.Move
File.UnCompress
Folder.Compress
Folder.Copy
Folder.Create
Folder.Delete
Folder.Move
Folder.UnCompress
If
If ETL Error
If File Exists
If Folder Exists
Load DB Table.Delete
Load DB Table.Insert
Load DB Table.Update
Load DB Table.Upsert
Load SimpleDB.Delete
Load SimpleDB.Insert
Load SimpleDB.Update
Load SimpleDB.Upsert
Log.ETL Job Log
Loop.Data Layer Rows
Procedure.File Exists
Save Data.CSV
Save Data.XML
Send SMS Text Message
Send Tweet
Transform


CHILD ELEMENTS

Click element to drill down for more information.

Create DB Index
Create DB Table
Delete DB Index
Delete DB Table
Email.Log
Email.Message
Email.Status
End Job
Execute.OS Command
Execute.Plugin Call
Execute.Script
Execute.SP
Execute.SQL
Extract
File.Compress
File.Copy
File.Delete
File.Move
File.UnCompress
Folder.Compress
Folder.Create
Folder.Delete
Folder.Move
Folder.UnCompress
FTP.Delete
FTP.Directory
FTP.Download
FTP.Rename
FTP.Upload
If
If ETL Error
Load DB Table.Delete
Load DB Table.Insert
Load DB Table.Update
Load DB Table.Upsert
Load SimpleDB.Delete
Load SimpleDB.Upsert
Log.ETL Job Log
Loop.Data Layer Rows
Run ETL Job
Save Data.CSV
Save Data.Fixed
Save Data.XML
Send SMS Text Message
Send Tweet
Set Session Variables
Transform


 Back to top


 Chart Debug