Applies to: System Center 2019 Service Manager (Update Rollup 2 and earlier versions)
Note: This issue has been fixed in Update Rollup 4 for System Center 2019 Service Manager.
When you run the Set-SCDWRetentionPeriod cmdlet, the cmdlet doesn't set the data retention period correctly.
Workaround
To work around this issue, run a SQL command that resembles the following example after you run the cmdlet:
-- This example sets the data retention period to 10 years for all fact tables.
declare @RetentionPeriodInYears int = 10
UPDATE wegi
SET wegi.RetentionPeriodInMinutes = (@RetentionPeriodInYears*366*24*60)
FROM etl.WarehouseEntityGroomingInfo AS wegi JOIN etl.WarehouseEntity AS we ON we.WarehouseEntityId = wegi.WarehouseEntityId
WHERE we.WarehouseEntityName NOT IN ('EntityManagedTypeFact', 'EntityRelatesToEntityFact')
For more information about how to set the data retention period for specific fact tables, see the following article:
How long does the Service Manager Data Warehouse retain historical data
Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors (upstream author metadata: Cloud-Writer). Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.
