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

KB30110: A List of Common Tests Performed by ScanMD


Stefano Antonellis

Principal Product Specialist • Strategy


This document contains a list of all the currently available ScanMD common tests.

ScanMD is a utility designed to detect and repair known logical inconsistencies in a Strategy metadata. For more information regarding ScanMD, refer to the following KB35809: Using ScanMD to fix known logical metadata inconsistencies in the MicroStrategy Product Suite 2019 and later.
This technical note lists known logical inconsistencies included in the Common Tests. The list below consists of what checks are performed for each test, sample error messages, and actions performed by ScanMD.
 


ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.Reports VerificationApplicationValidate the report's prompts, prompt resolutions, dependencies, and attribute forms.Remove inconsistent report definitions from metadata.


ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.Reports VerificationApplicationValidate the report's prompts, prompt resolutions, dependencies, and attribute forms.Remove inconsistent report definitions from metadata.


ArgumentDescriptionevt2001 - browseFolder Allows users to browse folders when providing an ID, folder name or system folder IDsrcSpecifies both the page component to handle the action and the event.systemFolderAllows access to different folders based on an internal ID (The EnumDSSXMLFolderNames enumeration contains a list of the valid system folders)folderIDSpecifies the ID of the folder to browsefolderNameSpecifies the name of the folder to browse. Uses the first match, in case of multiple matches.No input defined when...Web "Input is required" check box is checkedWeb "Input is required" check box is uncheckedDeveloper "Required" drop down is set to YesUsers will see "One or more required inputs have not been modified".A NULL will be inserted into the SQL if no input is defined.Developer "Required" drop down is set to NoUsers will see "One or more required inputs have not been modified".An error will be delivered by the driver outlining incorrect syntax if input-dependent SQL is not configured.Reports VerificationApplicationValidate the report's prompts, prompt resolutions, dependencies, and attribute forms.Remove inconsistent report definitions from metadata.

 
Delete invalid references to prompt or prompt resolution from reports. Remove references to missing attribute forms.The definition of Report EF1C618D42328ADAD829F1B00ED72799 is not loadable

 
: Report \2,3,4,5,7,13,17,22,23,37,40\Public Objects\Reports\Test contains 1 invalid prompt references.]

 

: Report \21,37,38,39\Public Objects\Reports\Test Prompt Resolution contains 1 prompt questions.]

 

: Report Test lists a non-existent object as a dependent.]

 

: Report test23 has a template attribute Dayfor23 which refers to a missing form.]

 
Attributes VerificationSchemaVerify the attribute object's correct definition, valid references, and system links.Remove inconsistent attribute definitions from metadata.

 
Attributes VerificationSchemaVerify the attribute object's correct definition, valid references, and system links.Remove inconsistent attribute definitions from metadata.

 
Attributes VerificationSchemaVerify the attribute object's correct definition, valid references, and system links.Remove inconsistent attribute definitions from metadata.

 
Attributes VerificationSchemaVerify the attribute object's correct definition, valid references, and system links.Remove inconsistent attribute definitions from metadata.

 
Delete the reference to the missing form from the attribute's definition.

 
Remove attributes with empty form collection (user fixable error).

 
Remove invalid template or browse forms that do not exist in System Dimension.

 
Remove BaseForm that is not referred to by any form from the attribute, table, and table’s TableKey collection. Remove invalid sort form from sort’s collection.

 
Checks whether each BaseForm is supported by its lookup table (user fixable error).The definition of Attribute EF1C618D42328ADAD829F1B00ED72799 is not loadable

 

: Attribute Test Forms's item 2 () refers to a missing Form.]

 

: Attribute Test's BaseForm with ID 1 is not referred to by any Form. This may result in undesirable dependency between a table and an attribute that can not be broken in Desktop.]

 

: Form DESC in the attribute's sorts collection is not found in the forms collection of the attribute 'Test'.]

 

: Form DESC in the sorts collection of attribute 'Test' is a compound attribute form.]

 

: Attribute Test's  BaseForm 1  is not supported by its lookup table Test_Table.]

 

: Test's attribute forms collection is empty.]

 
Facts VerificationSchemaValidate the Fact object's existence, valid references and proper column definition.Remove inconsistent fact definitions from metadata.

 
Facts VerificationSchemaValidate the Fact object's existence, valid references and proper column definition.Remove inconsistent fact definitions from metadata.

 
Facts VerificationSchemaValidate the Fact object's existence, valid references and proper column definition.Remove inconsistent fact definitions from metadata.

 
Facts VerificationSchemaValidate the Fact object's existence, valid references and proper column definition.Remove inconsistent fact definitions from metadata.

 
Remove references to invalid Table from fact’s table collection.The definition of Fact EF1C618D42328ADAD829F1B00ED72799 is not loadable

 

: Fact Test's Tables's item 1 () refers to a missing Table.]

 
Hierarchies VerificationSchemaVerify Hierarchy's correct definition and valid references.Remove inconsistent hierarchy definitions from metadata.

 
Hierarchies VerificationSchemaVerify Hierarchy's correct definition and valid references.Remove inconsistent hierarchy definitions from metadata.

 
Hierarchies VerificationSchemaVerify Hierarchy's correct definition and valid references.Remove inconsistent hierarchy definitions from metadata.

 
Hierarchies VerificationSchemaVerify Hierarchy's correct definition and valid references.Remove inconsistent hierarchy definitions from metadata.

 
Remove references to invalid attributes from hierarchies.The definition of Dimension EF1C618D42328ADAD829F1B00ED72799 is not loadable

 

: Dimension Test (Drilling)'s item 6 () refers to a missing Attribute.]

 
System Hierarchy VerificationSchemaVerify System Hierarchy's correct definition and valid references.Remove references to invalid attributes from hierarchies.: System Hierarchy's item {416} refers to a missing Attribute (AF3A164D4C533447AB8CAFBC1C59562C).]

 
System Hierarchy VerificationSchemaVerify System Hierarchy's correct definition and valid references.Remove references to invalid attributes from hierarchies.: System Hierarchy's item {416} refers to a missing Attribute (AF3A164D4C533447AB8CAFBC1C59562C).]

 
System Hierarchy VerificationSchemaVerify System Hierarchy's correct definition and valid references.Remove references to invalid attributes from hierarchies.: System Hierarchy's item {416} refers to a missing Attribute (AF3A164D4C533447AB8CAFBC1C59562C).]

 
System Hierarchy VerificationSchemaVerify System Hierarchy's correct definition and valid references.Remove references to invalid attributes from hierarchies.: System Hierarchy's item {416} refers to a missing Attribute (AF3A164D4C533447AB8CAFBC1C59562C).]

 
System Hierarchy VerificationSchemaVerify System Hierarchy's correct definition and valid references.Remove references to invalid attributes from hierarchies.: System Hierarchy's item {416} refers to a missing Attribute (AF3A164D4C533447AB8CAFBC1C59562C).]

 
Tables VerificationSchemaVerify the table object's existence and proper references.Remove inconsistent table definitions from metadata.

 
Tables VerificationSchemaVerify the table object's existence and proper references.Remove inconsistent table definitions from metadata.

 
Tables VerificationSchemaVerify the table object's existence and proper references.Remove inconsistent table definitions from metadata.

 
Tables VerificationSchemaVerify the table object's existence and proper references.Remove inconsistent table definitions from metadata.

 
Remove invalid Table references in a Table’s PartitionTables collection.

 
Remove invalid BaseForm reference in an attribute.The definition of Table EF1C618D42328ADAD829F1B00ED72799 is not loadable

 

: The Table Test_Table references a missing table in its PartitionTables collection.]

 

: The Table Test_Table contains an inconsistent attribute form. The BaseForm with ID 1 cannot be found in the corresponding attribtue: Test's BaseForm collection.]

 
Schema Collections VerificationSchemaValidate the schema collection's existence, and reference.Remove inconsistent schema object definitions from metadata.

 
Schema Collections VerificationSchemaValidate the schema collection's existence, and reference.Remove inconsistent schema object definitions from metadata.

 
Schema Collections VerificationSchemaValidate the schema collection's existence, and reference.Remove inconsistent schema object definitions from metadata.

 
Schema Collections VerificationSchemaValidate the schema collection's existence, and reference.Remove inconsistent schema object definitions from metadata.

 
Add schema objects to their corresponding schema collections.The definition of Attribute EF1C618D42328ADAD829F1B00ED72799 is not loadable

 

: Attribute Em Load Ts (\1,23,41,42\Schema Objects\Attributes\Em Load Ts) is being used by Dimension Em Load Ts, but it is not in Schema's Attributes collection.]

 
Warehouse Tables VerificationSchemaValidate the warehouse table’s existence and references.Remove inconsistent DbTable definitions from metadata.

 
Warehouse Tables VerificationSchemaValidate the warehouse table’s existence and references.Remove inconsistent DbTable definitions from metadata.

 
Warehouse Tables VerificationSchemaValidate the warehouse table’s existence and references.Remove inconsistent DbTable definitions from metadata.

 
Warehouse Tables VerificationSchemaValidate the warehouse table’s existence and references.Remove inconsistent DbTable definitions from metadata.

 
Remove DbTable that does not have corresponding logical table from metadata.The definition of DbTable EF1C618D42328ADAD829F1B00ED72799 is not loadable

 

: DbTable Test's corresponding logical table cannot be found.]

 


30110


Comment

0 comments

Details

Knowledge Article

Published:

April 4, 2017

Last Updated:

September 13, 2021