What errors could Catalog Doctor detect

What errors could Catalog Doctor detect?

With the Catalog Doctor you can diagnose and validate the data objects in a Catalog.

Errors are diagnosed independently

Since data objects in the catalog are constructed one after another, the Catalog Doctor diagnoses each type of data objects independently. For example, when it checks formulas, it only looks into the definition of parameters and DB-Fields in the current catalog. The system does not check if the DB-Fields exist in the connected database. When the system checks the queries, it will only look for the current mapping fields in the Catalog and does not confirm whether the formulas are valid.

For convenience, in the following statements database refers to the raw database connected to via JDBC or ODBC, mapped table/view refers to the table/view in the Catalog, raw table/view refers to the table/view in the raw database, and raw columns refers to the columns in the raw database.

Mapped table/view and DB-Field

Checks to see if the raw table/view of the mapped table/view exists in the database

Checks to see if the raw column of the DB-Field exists in the database. If it exists, then check to see if the stored information such as SQL date type matches the raw column in the database.

Formulas and Summaries

Checks to see if formulas and summaries have correct syntax..

Queries

Check to see if the mapped tables/views referenced by the query exist in the Catalog.
Check to see if the mapping fields are valid:

The DB-fields of the table/view match saved in the query;

The formulas and parameters can be found in the Catalog.

Other errors are caused by the two errors above.