When the Intelligence Server is starting, the following errors appear in the DSSerrors.log file:
[Metadata Server][Error][CMDAccessInfo.cpp:1137] Object with ID 'XYZ' and type 29 (DB Instance) is not found in metadata. It may have been deleted.
[Cube Server][Error][CDSSCubeServer.cpp:157] Error while initializing CubeManager
[COM][Error][0x8004100A][CDSSCubeServer.cpp:162] The data source (Cube Server) has not been initialized
[Kernel][Error][MSIProjectData.cpp:642] MsiProjectData::GetComponent(): get_Component from IDSSSession failed: project=project_name, component role = 47, HR=0x8004100A.
A similar error might appear when trying to display the Intelligent cubes caches under System Monitors and also when modifying the project Database Instances under Project Configuration.
This issue occurs because there is at least one project that has a reference to a non-existent database instance.
One approach would be to search for the missing database instance ID in an older backup of the metadata. If found, it can be migrated with Workstation Migrations or Strategy Object Manager. The ID of the missing database instance can be found in the DSSErrors log:
[Metadata Server][Error][CMDAccessInfo.cpp:1137] Object with ID 'XYZ' and type 29 (DB Instance) is not found in metadata. It may have been deleted.
The Intelligence Server must be restarted afterwards.
If the database instance ID cannot be found in an older metadata backup, please reach out to Strategy Cloud Support for assistance on solving this metadata inconsistency.
