EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB249815: "Object with ID 'XXX' and type 57 (DBMS) is not found in Metadata. It may have been deleted." error appears when importing .mstr file into MicroStrategy 10 Desktop


Community Admin

• Strategy


This article discusses a known issue that occurs when importing .mstr file into MicroStrategy 10 Desktop

SUMMARY:
This article shows a known issue that "Object with ID 'XXX' and type 57 (DBMS) is not found in Metadata. It may have been deleted." error appears when importing .mstr file into Strategy 10 Desktop. This is because Strategy connection type Microsoft SQL Server 2008 is not available in Strategy 10 Desktop. The resolution is to change connection type of data source in Strategy Express to Microsoft SQL Server 2012 and change it back to Microsoft SQL Server 2008 and 2008 R2 after migrating it into Strategy 10 Desktop.  
 
SYMPTOM:
Suppose Strategy Express user has one report which queries data against Microsoft SQL Server 2008. If this user exports it into one .mstr file and then import this file into Strategy 10 Desktop, "Object with ID 'XXX' and type 57 (DBMS) is not found in Metadata. It may have been deleted." error would appear as shown below:
   

ka04W000000Oge8QAC_0EM4400000025dJ.jpeg


Object with ID 'XXX' and type 57 (DBMS) is not found in Metadata. It may have been deleted. Error(s) occurred while loading report: DSSSSQLEngine:  converting Report: DBMSCOM interface error. 

 
CAUSE:
The DBMS object shown in the error message is for Microsoft SQL Server 2008 warehouse whose corresponding Strategy connection type Microsoft SQL Server 2008 is not available in Strategy 10 Desktop as shown below:

ka04W000000Oge8QAC_0EM4400000025dA.jpeg

 
ACTION:

  1. In Strategy Express, edit data source and change connection type to Microsoft SQL Server 2012. 
  2. Export the report to .mstr file and import the file to Strategy 10 Desktop.
  3. Edit data source and change connection type to Microsoft SQL Server 2008 and 2008 R2. 

Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017