59.3.18 T-Workflow Options

A complete log of all T-workflows executed by certain assets is stored on a 'Log table' within Etere's database (WF_Log) , these logs are available for all existing T-workflows, track their whole execution, and can be viewed in the T-Workflow tab (by pressing the 'view log' button) which is located in the Media Library module.

In Configuration Editor, under the T-Workflow > Options section, the user will be able set some of the more important parameters regarding size limits and deletion parameters of the aforementioned 'Log table'. This Log section is divided into two parts for specific configuration:

Add Log

Select one of the option to capture log data during execution of T-workflow:

o Never: The processing of T-workflow would not be write to the log file.

o Only with warnings or errors: Only warning message or error message occurred during the execution of T-workflow would be written in the log file.

o Ever: This option record all processes of T-workflow in the log file.

Log Table State

· Lines: The total number of line data written in the log file.

· Days: The number of days written in the log file.

Log Table Growth

Set the type of limit on which the size of the 'Log Table' will be based. By default, the 'Log Table' is restricted by size to no more than 1,000,000 lines, the other available limits are:

· Unlimited growth: Logs will be stored without restriction of size limit.

· Limited by time. Delete lines older than: Store log data by time restriction, Log's line data older than the specified number of days will be deleted. By default, Log data lines older than 7 days would be delete from the Log table.

· Limited by size. No more than: To manage the log data by it size, log line data exceeding 1000 lines would be deleted.

Log Table Deletion

Deletion is not applied to the entire 'Log table', but to the lines contained on it, this for avoid 'Log Table' to be blocked for a long time during a deletion.

· Max number of lines to delete at each batch deletion run: Set the maximum number of lines to be deleted on each execution (by default: 10'000). If the value is set to "0" all log data lines would be deleted at each batch deletion.
When log data are deleted from the file, the “View log ” function in T-workflow tab in Media Library would be disabled.

· Delete now!: Perform a manually deletion of log data lines, before confirming the deletion, a window would popup showing all the details of the deletion you are intending to perform (Total number of lines in Log table, excess lines number, deletion limit and lines that will be deleted), you would need to click the <OK> button to confirm the deletion.
If you want to delete ALL excess lines skipping the 'max. number of lines' parameter, just hold the [CTRL] key while you are pressing the [Delete now!] button.

· Archive deleted items if historical DB is available: If enabled, in case a historical database is configured for the system (Etere Configuration > Settings > Basic > System ), all items deleted from the 'Log Table' would be archived into the historical database in order to keep this information for future consultations.

Periodically, you should check the T-workflow logs archive status via the “SQL Server Management Studio > Job Activity Monitor” console to determine the considerable amount of T-workflow logs (log name starts with “wf_runtime”) in the Log Table, maintaining a low amount of logs data would help to achieve a better system performance.

NB: Since the log-table deletion (i.e.: delete now!) is performed by the Microsoft SQL Agent (w hich runs in the PC w here the Etere database server is installed) that check all parameters each 5 minutes ,this option w ill be available only for Etere systems w hich have a Microsoft SQL Server 2005/2008 version that includes the SQL Agent Job Scheduling Service (i.e.: Workgroup Edition, Standard Edition and Enterprise Edition); otherw ise (if your Etere system has the free version of Microsoft SQL Server 2005/2008: the Express Edition) this feature w ill not be available.