Data Warehouse and Class Extensions
Very often after I add extend a class to add a new property and import the sealed class extension; our Data Warehouse starts having issues were it either stops archiving data altogether or won't add the new property to the DW database.
Does anyone have or know of a resource with a procedure to safely import class extensions and have them transfer into the DW?
Best Answer
-
Conner_Wood Customer Ninja IT Monkey ✭✭✭✭
Unfortunately there is a unfixed bug in SCSM. I reported it to Microsoft back in 2016 but they never touched it and ultimately they deleted their submitted ticket database.
Bug causes 100% Data Warehouse MP Corruption - Import Sealed MP for DataWarehouse that contains StateTransition Fact that uses a Dimension that has specified "Extends" Attribute
The workaround is to not use extends so that the "Data Warehouse Bug - Duration Fact using Dimension with "Extends" corrupts DW 100%" does not happen.
As for safely, you have 2 sealed management packs, one with the sealed properties and relationships, then one for the DataWarehouse Dimensions (Properties) and Facts (Relationships). Note that class extensions don't need Dimensions specified if the main class has HierarchySupport="IncludeExtendedClassProperties"
If you are interested in getting stuff into the DWAS Cubes
EDIT: More Examples
For additional info on correctly making readable extended relationships and then using them in projections, see Cireson Thread Change Request Primary Owner
5
Answers
Unfortunately there is a unfixed bug in SCSM. I reported it to Microsoft back in 2016 but they never touched it and ultimately they deleted their submitted ticket database.
Bug causes 100% Data Warehouse MP Corruption - Import Sealed MP for DataWarehouse that contains StateTransition Fact that uses a Dimension that has specified "Extends" Attribute
The workaround is to not use extends so that the "Data Warehouse Bug - Duration Fact using Dimension with "Extends" corrupts DW 100%" does not happen.
As for safely, you have 2 sealed management packs, one with the sealed properties and relationships, then one for the DataWarehouse Dimensions (Properties) and Facts (Relationships). Note that class extensions don't need Dimensions specified if the main class has HierarchySupport="IncludeExtendedClassProperties"
If you are interested in getting stuff into the DWAS Cubes
EDIT: More Examples
For additional info on correctly making readable extended relationships and then using them in projections, see Cireson Thread Change Request Primary Owner