Skip to main content

Integrity Check

This feature of the Asset Manager is only available if the logged-in user has the Administrator role.

The objects in the Asset Manager (tables, queries, websites, dashboards, reports, variables, and constants) can, when combined, form a complex structure that occasionally requires verification. The integrity check is designed for this purpose; it allows you to verify whether the individual objects are valid on their own and whether the combinations of objects are consistent.

During the integrity check, all objects (including hidden ones) in the navigation tree are checked for integrity according to the following rules based on their object type:

  • Tables
    • Check whether the table exists.
    • If the table has a query that can be used to filter the results, check the corresponding query.
    • Check whether the queries within the variables are valid.
    • Check whether the columns in the __dynamicFormColumns table correspond to the columns of the SQL table.
    • Check whether the queries for lookup queries within the __dynamicFormColumns table are valid.
  • Queries
    • Check whether the query (SQL script) is valid.
    • Check whether the queries within the variables are valid.
    • Check whether all drilldowns are valid.
  • Links
    • Check whether the specified link is valid.
  • Dashboards
    • Check whether all queries specified as data sources are valid.
  • Reports
    • Check whether all queries specified as data sources are valid.

Back to top