KB486132: Error “The requested object with id 96C487AF4D12472A910C1ACACFB56EFB and type 4 (Metric) does not exist in the object context” occurs when importing any files from MicroStrategy Web after upgraded to MicroStrategy 2021.

Symptom
After upgraded from Strategy 9.0.2 to Strategy 10.4 and further upgraded to Strategy 2021, importing data from Strategy Web > Add External Data is failed with error “The requested object with id 96C487AF4D12472A910C1ACACFB56EFB and type 4 (Metric) does not exist in the object context”.
DSSError.log:

[CDSSObjectContext.cpp:1376] The requested object with id E1853D5A36C74F59A9F8DEFB3F9527A1 and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 96C487AF4D12472A910C1ACACFB56EFB and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 078C50834B484EE29948FA9DD5300ADF and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id B328C60462634223B2387D4ADABEEB53 and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 00B7BFFF967F42C4B71A4B53D90FB095 and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id B1F4AA7DE683441BA559AA6453C5113E and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 54E7BFD129514717A92BC44CF1FE5A32 and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 83A663067F7E43B2ABF67FD38ECDC7FE and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 36226A4048A546139BE0AF5F24737BA8 and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 7FBA414995194BBAB2CF1BB599209824 and type 4 (Metric) does not exist in the object context.
[CDSSObjectContext.cpp:1376] The requested object with id 1769DBFCCF2D4392938E40418C6E065E and type 4 (Metric) does not exist in the object context.

Note: All these IDs are the Subtotal systems objects which should shipped out-of-the box in Strategy 2021.
Cause
System Objects are the out of the box objects that are automatically created in the metadata when user first creates a project. Prior to Strategy 9.0.2, System Objects were created with random object IDs (GUIDs). After Strategy 9.0.2, the Configuration Wizard introduces a new upgrade option at the project level which allows the user to Perform a System Object ID Unification. Performing this update will replace the existing GUIDs of System Objects with fixed IDs so all Strategy metadata use a unified structure. Please refer to KB34982.
Since the system objects’ ID are not unified, and the subtotals with fixed ID are missing from Metadata, when importing data and create the relationship metric (row count metric), the error occurs.
Action
Follow below steps to re-execute System Object ID Unification and upgrade metadata:

1. Ensure the metadata with above error has been backed up. 
2. Connect to this metadata and run below SQL:
   

   
   update DSSMDOBJPROP set prop_val=0 where propset_id='C02146A211D46D60C0001786395B684F' and prop_id=4 and object_type=32;

   
   
3. Use configuration wizard to upgrade all projects again.

If the error is not eliminated, please contact Strategy Technical Support.