EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB42087: "Unexpected Error. Cannot save or move object "X" with id "Y" and type "DB Table". Its dependent object with id "Z" and type "Column" does not exist in the metadata" error message appears in the Warehouse Catalog in MicroStrategy 9.4.1 -10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This article describes error "Unexpected Error. Cannot save or move object "XYZ" with id "XYZ" and type "DB Table". Its dependent object with id "XYZ" and type "Column" does not exist in the metadata" in the Warehouse Catalog in MicroStrategy 9.4.1 - 10.x

SYMPTOM:
Whilst trying to "Update Structure" or "Show Sample Data" in the Warehouse Catalog in Strategy Desktop 9.x  the following error occurs:
 
 

ka02R000000kXFnQAM_0EM440000002Czm.jpeg


Unexpected Error. Cannot save or move object 'XXXXX' with id 'XXXX' and type 'DB Table'. Its dependent object with id 'XXX' and type 'Column' does not exist in the metadata.

  
CAUSE:
This issue is caused by a physical table object left in the metadata even though its logical table has been removed from the project. This physical table object has references to multiple invalid columns which causes the error to be thrown.
 
ACTION:
Contact Strategy Technical Support for further assistance. In order to track down the cause of the inconsistency, customers encountering this issue should make note of Schema-related changes, Object Migrations or error messages prior to experiencing the problem.  Change Journaling, if it has been enabled, can help in preserving this information.
 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 20, 2017

Last Updated:

June 20, 2017