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:
UPDATE SCHEMA FOR PROJECT "Strategy Tutorial";
[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";