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.
2. Health check options
Click Run All on the toolbar to run all standard health checks that can apply in general to your instance.
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:
The details dialog will give you more information on the error/issue:
If an automatic fix is available, you can click the Apply fix button.
4. List of available health checks
|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.