Logs deletion
ETL Log window¶
Admin | 
ETL tile > LOGS
User |
ETL tile > LOGS
IMPORTANT: from this entry point, you cannot view logs related to executions carried out by users other than the current user.
Purpose of window¶
This page allows you to consult the logs related to executions of ETL routines, both those run individually and those run within an ETL job.
Page sections
| Element | Description |
|---|---|
| Events | Shows the list of events related to executions of ETL routines. |
| Event details | Displays in a tree, for each event, the details of the results generated by executing the routine’s extraction, transformation and loading tasks (including micro tasks). |
Events section
| Element | Description |
|---|---|
| Result | Overall result of the execution: - : all tasks of the routine completed successfully - : at least one task of the routine completed with warnings - : at least one task of the routine completed with errors |
| User | Code and description of the user that ran the routine (only visible if the window was opened from an entry point that allows executions run by all users to be shown |
| ETL domain | Code and description of the ETL domain related to the routine run |
| Routine | Code and description of the routine run; |
| Start date | The timestamp related to the start of the routine’s execution; |
| End date | The timestamp related to the end of the routine’s execution. Note: this can be omitted if the execution was not completed due to a blocking error. |
Event details section
| Element | Description |
|---|---|
| Result | Task execution results: - : execution successful - : execution completed with warnings - : execution completed with errors - : not executed |
| Task description | Indicates a description of the data processing task, from the following: - the description of a step: Extraction, Transformation, Loading; - the description of an activity related to data storage: Store data offline, Restore data online; - the description of a task containing the sorting and description defined by the user. |
| Date | indicates the timestamp related to the start of the task’s execution; |
| Record | indicates the number of records processed by the task. |
| Information | Only visible if the selected record has no other details; |
| Query | Only visible if the selected record is an extraction or transformation task or a loading micro task. Contains a list of the queries run by the task. |
Actions in window
| Element | Description |
|---|---|
| allows you to export the content of every detail panel onto Excel | |
| Delete Log: this utility allows the advanced deletion of ETL logs. Logs can be selected based on the following options: Task execution result: - execution successful - execution completed with warnings - execution completed with errors - not executed User: code of one or several executing users Routine: code of one or several ETL routines Date from/Date to: fields for defining the time range in which the execution was run Delete warnings only: only deletes the warnings contained in the warnings tab of the Executed with warnings logs. IMPORTANT: If the option is not active, the deletion will completely remove the selected logs. |
Logs deletion¶
| Element | Description |
|---|---|
| Result | Task execution results: - execution successful - execution completed with warnings - execution completed with errors - not executed |
| User | code of one or several executing users |
| Routine | indicates the code of one or several ETL routines |
| Date from/Date to | fields for defining the time range in which the execution was run |
| Delete warnings only | If enabled, this option only deletes the warnings contained in the warnings tab of the Executed with warnings logs. If the option is not active, the deletion will completely remove the selected logs. |