In some cases, the Could downgrade to field in the Application > Information tab appears empty for all applications. As a result, automatic downgrade rights are not applied, and compliance calculations may appear incorrect.

This issue occurs when the automatic downgrade rights feature has been disabled in the Snow Management and Configuration Center (SMACC). When this setting is disabled, downgrade paths stored in the database are not applied automatically, even if they exist.

Investigation steps

1. Verify that downgrade paths exist in the database
   Run the following SQL queries in SQL Server Management Studio, replacing <ApplicationID> with the relevant ID:

   -- Check automatically defined downgrade paths
   SELECT DowngradePaths 
   FROM SnowLicenseManager.dbo.tblApplication; 
   
   -- Check for manually defined downgrade paths
   SELECT * 
   FROM SnowLicenseManager.dbo.tblApplicationCompatibility;
       

   Expected results:

   • The tblApplication table should contain downgrade path data.
   • The tblApplicationCompatibility table should not contain entries unless manual downgrade paths have been configured.
2. If all applications are missing downgrade paths:
   • Confirm that downgrade paths exist in dbo.tblApplication.
   • Confirm that no manual downgrade paths exist in dbo.tblApplicationCompatibility.
   • If both are true, the automatic downgrade setting is likely disabled in SMACC.