KB43002: "The database table ‘xxx’ has been used in the project. You can not link this logical table to it." error message appears when updating warehouse table name in MicroStrategy Architect 9.3.0

SYMPTOM:

 
"The database table ‘xxx’ has been used in the project. You can not link this logical table to it." error message appears when updating warehouse table name in Strategy Architect 9.3.0 as shown below:
 
 

 
"The database table ‘xxx’ has been used in the project. You can not link this logical table to it."
 
The following steps demonstrate how to reproduce this issue in tutorial project:
 

1. Create a table "T1" with column "TC1" in tutorial warehouse.
2. Import table T1 into tutorial project and create an attribute TA1 mapping to column TC1.
3. In Warehouse, change table T1 with new name "T2".
4. In Warehouse Catalog, import T2 into the project. Save and close.
5. In Architect, modify "Database Name" as "T2" in definition of T1 as shown below:

• Click on blank area and get error message as shown below:

CAUSE:

 
T2 has been used in the project. T2 is wrongly imported before modifying database name of T1.
 

ACTION:

 
Follow steps below to delete table T2 from Metadata:
 

1. Edit attribute form of TA1 and uncheck T2 in the source table list as shown below:

 
Re-modify database name of T1 as T2 in Architect. Save and close. There will be no error any more.
 
For more details about how to update warehouse table name in Architect, please follow the tech note below:
KB39859: How to update warehouse table name in MicroStrategy Architect 9.2.1 
 
 
 

• Save and close. Update Schema. This can help to delete all dependencies of T2.
• In Warehouse Catalog, move T2 from right to left section to delete T2 from Metadata.