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

KB42314: "One or more columns were not found in table 'XXX'. Other objects use some of these columns..." error message appears when updating the structure of a table in the Warehouse Catalog


Community Admin

• Strategy


This knowledge base article outlines an issue that occurs when trying to update a table structure in the MicroStrategy Warehouse Catalog.

SYMPTOM:

When updating the structure of a table in the Warehouse Catalog in Strategy, the following error message appears:

ka04W00000148e0QAA_0EM440000002Cv0.jpeg

 


Sample code/error:

One or more columns were not found in table 'LU_YEAR'. 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:

This is a known issue in Strategy Warehouse Catalog 9.x - 10.x, where it still detects that there are dependent Strategy objects on the table being updated.
 

ACTION:

It is not scoped for any upcoming scheduled Strategy release as the issue has a workaround and Developer is in maintenance mode.
 

WORKAROUND:

Update the table structure from Architect, which can be accessed from Developer > Schema > Architect.


Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

August 24, 2018