File Log Inspector

Use the File Log Inspector to inspect information about projects and jobs execution and fatal errors, and to review the system log.

1. Select Tools | File Log Inspector. The generated log files are displayed.

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

   Log files are located in the \log subdirectory of the installation directory.

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

   • fatal.log – captures low-level information that is written when the system encounters serious unexpected behavior. It includes information from fatal system exceptions when the system can no longer write to the system log file.

   • 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 following table lists the error codes that you may see in the system.log file.

     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.
     10101	Error	Connection to the repository database failed.

     The detail level of data written to the system.log file 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.

       The uTracelevel(n) function, 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 the 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.