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

KB226744: Table key and fact entry level are not updated by running an UPDATE SCHEMA script after adding the objects in Command Manager 9.4.x


Community Admin

• Strategy


In MicroStrategy Command Manager 9.4.x, table key and fact entry level are not updated by running an UPDATE SCHEMA script after adding the objects.

SYMPTOM:
  In Strategy Command Manager 9.4.x, table key and fact entry level are not updated by running an UPDATE SCHEMA script after adding the objects.
 
STEPS TO REPRODUCE:
Follow the steps below to reproduce the issue with Strategy Tutorial project:

  1. Create an attribute mapped to 'DAY_CTR_SLS' and 'CITY_CTR_SLS',
     
  2. Run the following script in Command Manager. 
    
    UPDATE SCHEMA FOR PROJECT "Strategy Tutorial";

     
  3. The table key and fact entry level are not updated and the following message is logged.

[Client Services][Source Manipulator] Purging client side cache at the start of Source Manipulator operations
 [Client Services][Source Manipulator] Claimed exclusive lock on project
 [Client Services][Source Manipulator] Claimed exclusive lock on configuration
 [Client Services][Source Manipulator] Begin schema update operation (with flags 7)
 [Client Services][Source Manipulator] ... Updated table logical size for Table 'DAY_CTR_SLS'
 [Client Services][Source Manipulator] ... Updated table logical size for Table 'CITY_CTR_SLS'
 [Client Services][Source Manipulator] Completed schema update operation
 
CAUSE:
This is a known issue with Strategy Command Manager 9.4.x
 
ACTION:
Currently this issue is being reviewed by Strategy for a potential code fix on an upcoming Strategy release.
WORKAROUND:
Specify the parameters when running the script in Command Manager as shown below:


UPDATE SCHEMA REFRESHSCHEMA RECALTABLEKEYS RECALTABLELOGICAL RECALOBJECTCACHE FOR PROJECT "Strategy Tutorial"; 

 


Comment

0 comments

Details

Knowledge Article

Published:

April 6, 2017

Last Updated:

April 6, 2017