MicroStrategy ONE

Troubleshooting table and column messages

You may encounter the following messages while using the Warehouse Catalog:

Tables missing

This happens when one or more tables already in the project are removed from the data warehouse. Two cases can be seen:

  • When the Warehouse Catalog is starting and retrieving the table information from the data warehouse and it detects that one or more tables already in the project are missing, it displays an error message which gives you the following options:

    • Leave the table in the project: This leaves everything as is in the project metadata. However the definition in the project may be inconsistent with the real physical structure in the warehouse. This can result in SQL errors when running reports that need data from a "missing" table.

    • Remove the table from the project. In this case, the Warehouse Catalog does not check for any dependencies until you save the changes. If there are any dependencies, they are presented to you, and you have the option to proceed or cancel the operation.

  • When the Warehouse Catalog tries to update the structure of a table that is missing in the warehouse, a message is shown which explains that the table structure update cannot proceed because the table was not found in the warehouse. In this case, no changes occur and the original table structure remains intact.

Column's data type changed

When the table structure is updated for one or more tables in which the column data types have been changed, you get a warning message showing the table name, column name, original data type, and new data type. You can click Cancel at any time to undo all data type changes. This results in no changes being applied to the tables and columns.

Columns missing

Missing columns are detected when Update Structure is performed. If this happens, the Warehouse Catalog checks for the following:

  • Column is not mapped to any schema object: If this is the case, then no error message is shown.

  • Column is mapped to a schema object: If this is the case, then a message is displayed that gives details on objects, which are mapped to the missing column and the update structure operation is canceled. You are asked to remove the mapping before continuing with the update structure and original table structure is restored.