SYMPTOM:
When the user migrates a table object from a source project to a target, the following error occurs:
The source manipulator found a missing dependency. Object: <DB Table id=> is not found. A total of 1 object(s) need it, one of which is <Table id=>. Please turn on the log for more information.
CAUSE:The steps that lead to this state are unknown at this time. One possible cause of this issue is a physical table object (DBTable) has become a managed object, therefore, when searching dependencies in the Strategy Obejct Manager, the managed objects are missing from the result set.
ACTION:Run ScanMD Common Tests (check all the verification tests under
Schema). Refer to the following technical note for information on how to install and run ScanMD:
KB35809: Using ScanMD to fix known logical metadata inconsistencies in the MicroStrategy Product Suite 9.4.x - 10.2 Hotfix1In order to track down the cause of this behavior, customers encountering this issue should make note of changes on configuration objects, Object Migrations, or error messages prior to experiencing the problem. Change Journaling, if it has been enabled, can help in preserving this information.
Contact Strategy Technical Support if the issue is not resolved after running ScanMD.