erwin Data Transformation 9.2.3 - User Guide

Client, Scheduler and Workflow log

Client, Scheduler and Workflow log

The buttons open different kinds of logs showing a detailed view of the system events. Very detailed information can be found there, such as query messages, exceptions, errors etc.

The log will be shown in your predefined text editor:

•Client Log refers to the operations executed through the user interface

•Scheduler Log refers to the batch operations related to Adapter execution

•Workflow Log refers to the operations required by workflow transformation and operation

Utilities

Utilities

Additional administration features are available from the “Tools” Menu.

Reset Workflows/Sequences

Reset Workflows/Sequences

If DT Windows Services are forced to stop, or in the case of a severe internal error, sequences may enter an inconsistent state which could stop other jobs from being executed. In such a case, the administrator may use the “Reset WF/Sequences” item in the “Tools” menu.

This operation can be done manually, as described, or by scheduling it in a custom job, using the sample execution: resetSequencesUtil.bat that can be found in the DT installation folder:

Reset Logs/Files

Reset Logs/Files

When needed, it is possible to reset the logs table just by pressing the “Tools” menu item “Reset Logs/Files”.

This action will clean the database of all the application logs, thus preventing the DB from being overloaded by historical tracking data.

This operation can be done manually, as described, or by scheduling it as a custom job, using the sample execution: resetLogsUtil.bat that can be found into the DT installation folder. The executable optionally accepts a numerical integer parameter, which is “days to be maintained”. For example, if called with “3”, past logs until 3 days before the job execution will be deleted.