Health check


1. Overview

Administrators can run health checks to identify any potential issues with their Dundas BI instance, and apply fixes when available.

Under the System Health category in Administration, click on Health Check.

2. Health check options

Click Run All on the toolbar to run all standard health checks that can apply in general to your instance.

Run all health checks
Run all health checks

To choose specific health checks or to choose from the complete list of those available, click Run Selected instead.

3. Fixing issues

After running the health checks, view the result, which will display an icon to the left if any potential problems were found. Select the health check and then click the Details icon on the toolbar to get more information:

Health check result
Health check result

The details dialog will give you more information on the error/issue:

Details of the issue
Details of the issue

If an automatic fix is available, you can click the Apply fix button.

4. List of available health checks

DBI0010 Application DB Connectivity Ensures that the application can connect to the application database.
DBI0011 Warehouse DB Connectivity Ensures that the application can connect to the warehouse database.
DBI0012 App DB Schema Ensures that the tables in the application database are valid according to the expected schema.
DBI0020 Application DB Settings Ensures that various settings related to the application database are correct.
DBI0021 Warehouse DB Settings Ensures that various settings related to the warehouse database are correct.
DBI0022 Invalid Persisted Data Identifies data persisted to a database which is in an invalid format.
DBI0030 Fragmented Indexes in Application DB Detects overly fragmented indexes in the application database.
DBI0031 Fragmented Indexes in Warehouse DB Detects overly fragmented indexes in the warehouse database.
DBI0040 Scheduler Service Status Checks whether the Scheduler service is running and can connect to the Dundas BI web application.
DBI0045 Internal Application URL Status Checks whether the internal application URL set in the configuration settings is accessible.
DBI0060 Application Folders Write Permission Checks that the web server identity has Write access to application folders.
DBI0206 Invalid Child Count Finds the system entries with invalid values in the ChildCount column.
DBI0210 Invalid Checked-Out References Finds references from checked-out entries where the corresponding entity is not actually checked-out.
DBI0211 Invalid Active Entries Finds transient subentries which are no longer referenced by the latest revision of their parent entity, and marks them as inactive.
DBI0212 Invalid Project IDs Finds entries whose project ID does not match the ID of the project under which the entry resides.
DBI0213 Invalid Checked-Out Entity Data Finds checked-out data for entities which are not actually checked-out.
DBI0214 Invalid Inactive Entries Finds inactive subentries which should be active.
DBI0215 Missing Entity Data Finds entities which are missing their underlying data.
DBI0216 Invalid Subentry Revisions Finds subentries whose current revision doesn't match that of their corresponding primary entry.
DBI0217 Orphaned References Finds references from entity revisions which do not exist.
DBI0218 Incorrect Privilege Assignee Kind Finds privilege assignments where the Everyone group has the incorrect assignee kind.
DBI0219 Missing Referenced Entities Finds references to non-existing entities.
DBI0220 Duplicate Tenant Project Folders Finds tenants with more than a single Tenant Project Folder.
DBI0221 Circular References Finds entities which directly or indirectly reference themselves.
DBI0222 Orphaned Tenant Overrides Finds tenant overrides corresponding to items which do not exist.
DBI0223 Invalid Project Temp Folder Privileges Finds project-level temporary folders which don't have correct privilege assignments.
DBI0224 Invalid Project Privilege Inheritance Finds projects which incorrectly inherit privileges.
DBI0225 Invalid User Project Tenants Finds user projects and project items which have tenants different from the account's tenant.
DBI0300 Orphaned Account, Group and Tenant Data Finds data corresponding to accounts, groups, and tenants which no longer exist.
DBI0305 License Seat Usage Detects when more seats are being used than what is permitted by the licenses.
DBI0310 Empty User Projects Finds and removes empty non-developer user projects.
DBI0315 Orphaned Notification Jobs Finds and removes notification jobs without related notifications.
DBI0400 Log Filter Settings Warns if the current log filter setting may be overly verbose.
DBI2000 Unused Warehouse Tables Finds warehouse tables that are not in use.
DBI2010 Invalid Default Time Dimensions Finds projects whose specified default time dimension couldn't be found in the system.
DBI2015 Transient and Inactive Native Structures Finds native structures (tables, views, etc.) which are incorrectly marked as transient or inactive.
DBI2020 Duplicate Storage Jobs Finds native structures or data cubes which have more than one active associated warehouse or in-memory storage job.
DBI2025 Third-Party Drivers for Data Connectors Ensures that third-party drivers are installed for all data connectors.
DBI2030 Notifications with Invalid Metric Set References Finds notifications referencing metric sets which no longer exist or metric sets to which the associated account is no longer authorized. This check will remove the request if the referenced metric set no longer exists and will remove the entire notification if all metric sets no longer exist. Metric set privileges will not be modified.
DBI2031 Single-Use Notifications That Didn't Get Deleted Finds and deletes notifications that were created internally for a single use but weren't deleted, for example because of an error or shutdown.
DBI2035 Missing Warehouse Tables Finds data cubes that are missing their warehoused data.
**DBI2040 Duplicate Relationships (omitted by default) Finds duplicate relationship data.

 ** Indicates that the health check is omitted by default when using the Run All health checks option.

5. Scheduled health checks

In version 23.2 and higher, there is a built-in Health checks maintenance job that you can enable and schedule.

The configuration settings in the Health Check category let you set up which issues to check for, the level of severity that should trigger an email to the configured Maintainer Email address (in the Email category), and whether to apply fixes automatically when possible.

6. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

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