KB199722: Name space of tables in primary database instance for a project cannot be updated even though "Ignore current table name space..." option is enabled in Warehouse Catalog in MicroStrategy Developer 9.x

Symptoms

Suppose a warehouse table under certain name space was imported into project via primary database instance in Warehouse Catalog in Strategy Developer 9.x. If the name space on the warehouse side is changed, name space of the table in Strategy project cannot be updated even though "Ignore current table name space when reading from the database catalog and update using new table name space" option is checked in Warehouse Catalog options as shown below:

Diagnosis

This is a known issue in Strategy Developer 9.3.1

Solution

This issue was fixed in MicroStategy Developer 9.5
 
Workaround

• Check option "Ignore current table name space when reading from the database catalog and update using new table name space" in Warehouse Catalog>Options>Read Settings.
• In Warehouse Catalog, select all the problem tables and right click on them. Choose "Table Database Instances" as shown below:
   
   
  

• Change Primary Database Instance to the one without suffix "project primary database instance" as shown below:
   
  

• Click on Read to read table information. Save and close Warehouse Catalog.
• Open Warehouse Catalog again. Change the DB instance of the table back to the original one.