KB43307: The primary and default DB instance(s) of the project is/are not added to the package as the object dependencies in MicroStrategy Object Manager 9.x.

 
SYMPTOM:
 
The primary and default DB instance(s) of the project is/are not added to the package as the object dependencies in Strategy Object Manager 9.x even 'Show System Objects' option is selected, as shown below:

 
NOTE: Run the report, and check SQL View. Notice that the DB instance 'Tutorial Data' is used, as shown below:

 
And 'Tutorial Data' is the primary and default database instance of the project, as shown below:

 
 
CAUSE:
 
This behavior is by design. The default / primary database instance of the project will be not added to the package as the object dependencies of a RLOAP report.
 
But if the report is FFSQL, XDA etc, the respective database instance(s) will be added to preserve metadata consistency.
 
 
ACTION:
 
Configuration Packages can be used to migrate database instances. For the steps below to create a configuration package in Strategy Object Manager 9.x:

• Select the project source / Administration in Object Manager, go to Menu -> Tools -> Create Configuration Package, as shown below:
  

• Click on 'Search for configuration objects' and search for the required database instance.
• Drag and drop the object to the 'Create Configuration Package' window.
• Click on 'Add All Used Dependencies', as shown below:
  

• Click on Proceed to create the configuration package.