Client Settings Issue after SCCM update to 2211

Question

Hi all,

I have a issue with the client settings after update to v2211.
If i copy a exising client settings, this will be done, but im not able to edit, increase, decrease or delete the new copy of the existing. also the original one from where i copy is corrupted after that. The original one is still working, but I'm also not possible to edit or delete, the Console is all time crashing.

Funny is also that the first copy of the client settings have the same prio like the default server settings.

Also it is not possible to delete the copy with powerhsell.

Remove-CMClientSetting -Id "16777241" there are an SQL Error i not understand.

Has anybody every see something like that?

Are you sure you wish to continue: ClientSetting: Name="SMS - Default Client Settings - Copy (2)"?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"): Y
Remove-CMClientSetting : ConfigMgr Error Object:
instance of SMS_ExtendedStatus
{
        CauseInfo = "";
        Description = "CSspClientSettings: SQL_ERROR";
        ErrorCode = 3242722562;
        File = "K:\\dbs\\sh\\cmgm\\1125_114522\\cmd\\4\\src\\SiteServer\\SDK_Provider\\SMSProv\\sspclientsettings.cpp";
        Line = 129;
        Operation = "DeleteInstance";
        ParameterInfo = "SMS_ClientSettings.SettingsID=16777241";
        ProviderName = "WinMgmt";
        SQLMessage = "[42000][6965][Microsoft][SQL Server Native Client 11.0][SQL Server]XML Validation: Invalid content. Expected element(s):
'list-view-default','scpivot-filter-default'. Found: element 'required-filter-default' instead. Location:
/*:settings[1]/*:defaults-list[1]/*:required-filter-default[1].";
        SQLSeverity = 16;
        SQLStatus = 6965;
        StatusCode = 2147749889;
};
CSspClientSettings: SQL_ERROR
At line:1 char:1
+ Remove-CMClientSetting -Id "16777241"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (Microsoft.Confi...veClientSetting:RemoveClientSetting) [Remove-CMClientSetting], WqlQueryException
    + FullyQualifiedErrorId : UnhandledException,Microsoft.ConfigurationManagement.PowerShell.Cmdlets.ClientSettings.RemoveClientSetting

Answer 1

Hi,

Based on my experience, we could query the client settings from the CM database.

In general, the priority column should be a unique number.

If the priority number is duplicate, I recommend you try to contact the CSS support.

SELECT TOP (1000) [ID]
      ,[UniqueID]
      ,[Name]
      ,[Description]
      ,[Type]
      ,[Enabled]
      ,[Flags]
      ,[Priority]
      ,[SourceSite]
      ,[IsTombstoned]
      ,[DateCreated]
      ,[DateModified]
      ,[CreatedBy]
      ,[LastModifiedBy]
      ,[FeatureType]
      ,[rowversion]
  FROM [CM_PRI].[dbo].[ClientSettings]

Answer 2

The problem could be solved.

What is the cause of this, I do not know, but it is relatively simple to solve this problem. It must be one of the custom client settings in the copies that is causing the problem. Which of these settings I unfortunately can not say. But I assume the Endpoint Protection.

If I simply remove all checked options, and then save them. Is it then also possible to delete these copies again. also this, which shared the same priority with an existing one.

Done