File Log Inspector

Use the File Log Inspector to view information about project and jobs execution, fatal errors, and to review the system log. Log files are located in the \log subdirectory of the installation directory.

1. Select Tools | File Log Inspector.

2. Click the log file information you want to view. You may see one or all of these log files:

   • alert.log – captures history of the triggered alerts. Provide alert details such as, alert name, event type, date and time, and alert message.

   • execution.log – captures information about job and project execution.

   • system.log – captures information about system activities, and operational and exceptional events. You can check the error codes in the system.log file to determine the reason and possible solution for errors encountered while working with Sybase ETL. The error codes that you may see in the system.log file include:

     Error code	Type	Description
     0	Information	Job or project execution is successful
     100 or 110	Error	ETL engine initialization error
     101	Error	Invalid license error
     1100	Error	ETL exception failure, including incorrect command line usage
     1103 or 1104	Error	Failure due to an unspecified exception
     10001	Error	Failure to retrieve information from repositories, including jobs, projects, and parameter sets
     10005	Error	Job execution failed
     10006	Error	Project execution failed
     10007	Error	Project execution ending in a rollback state
     10101	Error	Connection to the repository database failed

     The detail level of data written to system.log depends on the trace level that has been set.

     To set the trace level:

     • Select Tools | Enable System Trace.

     • Use the uTracelevel(n) function in a JavaScript procedure.

       uTracelevel(n), where n is a value of 0 through 5, lets you set the trace level from within a component.

     • Specify the trace level in the default.ini file in the etc subdirectory of the installation folder by modifying this line:

       Tracelevel=value
       

       where value is the trace level you want to set. You must restart Sybase ETL for the change to take effect.

     Sybase recommends you to set a trace level to either 0 or 5.

3. (Optional) Click “Truncate log” icon on the toolbar to truncate the log. Click Yes to confirm.

4. (Optional) Click the “Select rows containing a string or regular expression” icon on the toolbar to locate a particular log file.