KB33395: "Cannot save or move object '[Table name]' with id '[Table GUID]' and type 'Table'. Its dependent object with id 'Fact GUID' and type 'Fact' does not exist in the metadata" error occurs when updating schema in MicroStrategy 9.x and 10.x

Salesforce Solutions Architect • Strategy

KB33395: "Cannot save or move object '[Table name]' with id '[Table GUID]' and type 'Table'. Its dependent object with id 'Fact GUID' and type 'Fact' does not exist in the metadata" error occurs when updating schema in MicroStrategy 9.x and 10.x

SYMPTOM:
The error below occurs when updating schema with the option "Recalculate table logical sizes." checked:


Cannot save or move object '' with id '' and type 'Table'. Its dependent object with id 'Fact GUID' and type 'Fact' does not exist in the metadata.

CAUSE:
The problem is that the metadata has a logical table object containing a reference to a fact object which no longer exists in the metadata.

ACTION:
Please 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.

WORKAROUND:
Please download the latest ScanMD version and perform the "Table Verification" test to resolve the issue. For more details, please refer to the tech note:

KB35809- Using ScanMD to fix known logical metadata inconsistencies in the Strategy 9.x Product Suite

Comment

0 comments

Details

Knowledge Article

Published:

June 20, 2017

Last Updated:

June 20, 2017