Health check

Contents[Hide]

1. Overview

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

Find Health Check under System Health in the Admin section.

Click Health Check in Administration
Click Health Check in Administration

2. Health check options

Click Run all health checks 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 health checks 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. Click on the Details icon 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

IDNameDescription
DBI0010 Check Application DB Connectivity Ensures that the application can connect to the Application Database.
DBI0011 Check Warehouse DB Connectivity Ensures that the application can connect to the Warehouse Database.
DBI0020 Check Application DB Settings Ensures that various settings related to the application database are correct.
DBI0021 Check Warehouse DB Settings Ensures that various settings related to the warehouse database are correct.
DBI0030 Check Fragmented Indexes in App DB Ensures that the indexes in the Application Database are not overly fragmented.
DBI0031 Check Fragmented Indexes in Warehouse DB Ensures that the indexes in the Warehouse Database are not overly fragmented.
DBI0040 Check if Scheduler Service is Running Ensures that the Scheduler service has been running properly. If the service has not been running for more than 11 minutes, an admin will have to run it manually.
DBI0100 Check for ADSI Hotfix 2683913 Ensures that the hotfix for Microsoft KB 2683913 is installed, to prevent random exceptions from being thrown when calling Active Directory functionality.
DBI0206 Invalid Child Count Finds the system entries with invalid values in the ChildCount column.
DBI0210 Invalid Check-Out References Finds references from checked-out entries where the corresponding entity is not actually checked-out.
DBI0211 Mark Inactive Entries Finds transient subentries which are no longer referenced by the latest revision of their parent entity, and marks them as inactive.
DBI0212 Detect 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 Fix Invalid Inactive Entries Finds inactive subentries which should not be inactive.
DBI0215 Find Entities with Missing Data Locates 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 Detect and Fix Privileges Where Everyone Group Has Incorrect Assignee Kind Finds privileges where the Everyone group has an incorrect assignee kind.
DBI0219 Missing Referenced Entities Finds references to entities which do not exist.
DBI0220 Detect and Remove Duplicate Tenant Project Folders Ensures that there is no more than a single Tenant Project Folder per Tenant.
DBI0221 Circular References Finds entities that refer to themselves, either directly or indirectly via other referenced entities. These references may need to be fixed manually.
DBI0222 Orphaned Tenant Overrides Finds tenant overrides saved for a data connector or time dimension that has been deleted.
DBI0223 Detect Invalid Project Temp Folder Privileges Finds project temp folders which don't have correct privilege assignments.
DBI0224 Detect Invalid Project Privilege Inheritance Finds projects that are set to inherit privileges, which is not valid.
DBI0300 Orphaned Account, Group, and Tenant Data Finds (and optionally deletes) account, group, and tenant-related data corresponding to accounts, groups, and tenants that no longer exist.
DBI0305 Detect License Seat Usage Issues Detect when more seats are being used than what is permitted by the licenses.
DBI0400 Check Log Filter Settings Checks whether any log filters are set to inadvisable settings and warns if they are.
DBI1000 Check Reports And Scorecards For Upgrade** Ensures that reports and scorecards have been properly upgraded from version 1.
DBI2000 Detect Unused Warehouse Tables Finds warehouse tables that are not in use.
DBI2010 Detect Invalid Default Time Dimensions Finds projects whose specified default time dimension couldn't be found in the system.
DBI2015 Detect Transient and Inactive Native Structures Ensures that native structures (tables, views, etc.) are not incorrectly marked as transient or inactive.
DBI2020 Detect and Remove Duplicate Storage Jobs Finds and removes duplicate storage jobs.
DBI2025 Third-Party Drivers for Data Connectors Ensures that all of the third-party drivers required for existing data connectors are installed.
DBI2030 Invalid Notifications Finds notifications where the underlying metric set was deleted or had the permissions removed from the user.
DBI2035 Detect Missing Warehouse Tables Finds data cubes that are missing their warehoused data.

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

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: 7am-6pm, ET, Mon-Fri