Monitoring system health


1. Overview

Use the System Health options in the Admin screen to:

  • Examine the Dundas BI application log for any errors or warnings
  • Manage running and scheduled jobs in Dundas BI:
  • Verify email settings by sending a test email

System Health options
System Health options

2. Viewing logs

The application log in Dundas BI can help you to troubleshoot operational warnings or errors.

See Application logs for details on accessing the log and configuring log filters.

Viewing log entries
Viewing log entries

3. Managing jobs

3.1. View all jobs in Dundas BI

Under System Health, click Jobs to monitor the status of past, scheduled, and currently running jobs. The following job kinds are supported:

  • Update In-Memory Cube - Build in-memory storage for a data cube
  • Update Data Warehouse - Build data warehouse storage for a data cube
  • Notification - Scheduled and data-driven notification creation or execution
  • Cleanup - A periodic job performed by the system service. Deletes expired records from the application database (log entries, performance statistics, usage tracking data, etc.). You can control the frequency of the cleanup job and the expiry interval of the records in advanced configuration settings, or via the Maintenance Job Details dialog. Click View on the job to access it.
  • Rebuild Indexes - A periodic job performed by the system service. Rebuilds the indexes in the application and warehouse databases to avoid index fragmentation. You can change the job schedule or disable/enable it via the Maintenance Job Details dialog. Click View on the job to access it.

View the status of all jobs in Dundas BI
View the status of all jobs in Dundas BI

Jobs are displayed in a table at the bottom of the Jobs screen. Each job entry provides the following information:

  • An icon indicating the result of the last job run.
  • An icon indicating the status of a job (idle, running, disabled, deleted).
  • An icon indicating the kind of job (in-memory, data warehouse, notification, cleanup).
  • A description of the job.
  • The tenant who created the job.
  • The last time the job ran.
  • A description of the latest event.
  • A View icon leading to the Job Details dialog.

The legend above the Jobs table explains what each icon means. Or, hover over an icon in the table to see a descriptive tooltip.

Jobs interrupted by a DBI server shut down will by marked as Abnormal Termination by the Cleanup job.

3.2. Filter and sort jobs

Use the Job Kind and Job Status dropdowns to filter the job entries by type and/or status. The status of a job can be one of the following:

  • Idle
  • Running
  • Disabled
  • Deleted

Filter jobs by type and status
Filter jobs by type and status

Click the Last Run Date box and use the calendar to choose a specific date for filtering the job entries. For example, you can easily filter the entries to show jobs for Today only.

Filter jobs by last modified date
Filter jobs by last modified date

Use the Order By dropdown to sort the jobs by the last run date or the job creation date. The A-Z buttons let you switch between ascending or descending order.

Click Select tenant to choose a tenant and view only the jobs relevant for that tenant.

3.3. View job details

Select any job in the Jobs table and then click Details on the toolbar to see the details of the job including its history.

From the Job Details window, you can manually start the job or cancel a running one, as well as modify the schedule of any scheduled job.

View the details of a notification job
View the details of a notification job

You can also disable a job using the Disable job button (or re-enable it using the same button, which works like a toggle).

Use the Enable auto-refresh button to automatically trigger a refresh of the Job Details window every 30 seconds. This option will be turned off as soon as you leave the Job Details page or scroll down the job history.

3.4. Clear old job data

By default, the data associated with a job is cleared automatically based on the Job Data Maximum Age configuration setting. This is set to 30 days initially which means once job data becomes older than 30 days, it is cleared.

If you want to manually clear job data yourself, you can do so from the Jobs screen by clicking Remove on the toolbar.

In the Remove Job Data dialog, click inside the Remove before text box, and then use the calendar to select a date. All job data older than this date will be cleared. Click Submit to clear the data.

Clear job data older than a specified date
Clear job data older than a specified date

4. Testing email settings

Email settings must be configured properly in order for certain features such as notifications to work properly.

To check your email settings, expand the System Health options and click Test Email Settings.

Type an email address to receive a test email and then click Submit.

Test email settings
Test email settings

Check the appropriate inbox for the test email which will have the subject line: Dundas BI test email.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri