Sample code/error:
One or more columns were not found in table ''. Other objects use some of these columns. Removing these columns can leave the affected objects in inconsistent state.
The table structure will not be updated until no objects depend on these columns. Please modify the definition of the affected objects before continuing.
Click on'Details' to see the list of affected objects.
CAUSE:
One possible cause of this issue is that the case sensitivity of one or more of the table column(s) in the source database does not match that of the destination database. In order to point a table from one database to a different database, Strategy require table name, columns and data type to match between the source and destination database.
ACTION:
Users experiencing this issue can either update the case of the table column in the database to match between the source and destination database, or update the table structure from Architect, which can be accessed from Developer > Schema > Architect. Steps on how to update table structure from Architect is described in the knowledge article:
KB40152: How to rename the column in a warehouse table object in MicroStrategy Developer 9.x - 10.x This issue has been logged as SCOPUS ID: 255849 and KB441578
