Reading the scheduler log
The Scheduler log can record the details of scheduled and completed batch imports and exports - the actual events that are logged will depend on the logging options set on the Schedules page of the iBase Scheduler Configuration dialog. Activity for each database connection is logged to the same file.
To display the log viewer
Click the Schedules tab to display Schedules page.
Click View Log to open the log files folder, and then click the required log.csv file to view it. Files can be opened and viewed in a number of applications and text editors, such as Microsoft Excel, or Notepad.
Completion status
The different statuses for scheduled tasks are shown in the following table:
Task | Status |
|---|---|
Task execution successful | The task ran successfully. |
Trigger updated | The trigger has been edited. |
Trigger inactive | The trigger has been made inactive and will not run again until you make it active. |
Trigger expired | The batch import or export did not run because the end date on the File Change type trigger had passed. |
Trigger deleted | The trigger has been deleted. Also, the task was scheduled but was canceled by the service because the trigger had expired. This might happen, for example, if a previous task took much longer to run than expected. |
Error | The task was not completed successfully. |
Scheduled batch imports and exports that fail
If the logging option When tasks are scheduled to run is selected, entries are added to the log for tasks that are scheduled to run in the future.
The file associated with a file trigger does not have to exist; the task is still scheduled and an entry appears in the log. If the file does not exist, or if the permissions on the folder containing the file prevent viewing of the date and time of the file, then these messages are logged once every 24 hours:
The file X does not exist or there are insufficient permissions on the directory it is located in to read the file.
The File Change trigger file X does not exist or there are insufficient permissions on the directory it is located in to read it.
A batch import or export fails if the batch specification contains a specification that requires input from or is output to a text file, and this text file is missing. In this instance the message "Failed to create import set X. File not found" is displayed.
Note: Tasks fail to run if the service cannot get exclusive access to the database, for example because it is open in iBase Designer.
Completed batch imports and exports
To prevent a type of message from appearing in the log, display the Schedules page, and click to turn off the required Logging option, as described in the Log Description section below.
Message | Description |
|---|---|
Date & Time | Timestamp recorded when this phase of the batch import or export was started or completed. Most recent events are listed first. |
Connection Name | Name of the connection to the iBase database. |
Task Name, Task Type | Name of the trigger that scheduled the task, and its type: Interval or File Change. |
Log Type | The log type corresponds to the logging options set on the Schedules page. |
Log Type Schedule | When a task is scheduled to run. |
Log Type Execute Task | When a task starts and finishes. |
Log Type Execute Program | When the program for a task action starts and finishes. |
Log Type Plugin | When a plug-in for a task action starts and finishes. |
Log Type Execute Component | When components start and finish. |
Log Type Statistics | Statistics when a task completes. |
Log Type Completion Status | The completion status when a task finishes. See Completion Status above for details. |
Log Type Warnings | Warnings produced by a batch specification running. |
Log Type Errors | Errors produced by a batch specification running. |
Log Description
The messages detail, in reverse order, the progress of the task. For example:
Message | Logging option |
|---|---|
Completed execution of batch X | When batch X finished. This marks the end of this task. Exclude this message by turning off "When tasks start and finish". |
Completed execution of X | When the named import/export specification finished running. The messages given below relate to this specification. Exclude this message by turning off "When components start and finish". |
Entity, Links, Entity End 1/2 | When importing entities and links, this reports statistics concerning the entity or link records. If any errors are reported, then they are logged in the text file specified in the specification. When exporting, reports the number of records exported. Exclude this message by turning off "Statistics when a component finishes". |
Execution <status> | Shows the status of the completed batch import/export. See Completion status above. Exclude this message by turning off "The completion status when a task finishes". |
Starting execution of X | When the service began to run the named specification. |