ConfigMgr Software Center crash and error "Call to ExecuteQuery failed, Query: "Select * From CCM_Application WHERE UserUIExperience = TRUE" "

A customer recently experienced an issue where ConfigMgr Software Center would not load and crashed. Errors in SCClient_[DOMAIN]@[USERNAME].log indicated issues with querying WMI.

Call to ExecuteQuery failed, Query: "Select * From CCM_Application WHERE UserUIExperience = TRUE" (Microsoft.SoftwareCenter.Client.Data.WmiConnectionManager at ExecuteQuery)

Exception caught in ExecuteQuery, line 465, file C:\__w\1\s\src\DataAbstractionLib\WmiDataProvider\WmiConnectionManager.cs - Type System.Runtime.InteropServices.COMException:  (Microsoft.SoftwareCenter.Client.Data.WmiConnectionManager at ExecuteQuery)

StackTrace:    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)

   at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()

   at Microsoft.SoftwareCenter.Client.Data.WmiConnectionManager.ExecuteQuery(String query)

Found exception of type System.Runtime.InteropServices.COMException; wrapping in type Microsoft.SoftwareCenter.Client.Data.WmiException (Microsoft.SoftwareCenter.Client.Data.WmiException at .ctor)

Call to ExecuteMethod failed, WMI MethodName "StoreEvent", MethodClass "CCM_ClientEvents", called by , error code -2147467259 (Microsoft.SoftwareCenter.Client.Data.WmiConnectionManager at ExecuteMethod) SCClient 19/10/2022 14:38:46 1 (0x0001)

Exception caught in ExecuteMethod, line 407, file C:\__w\1\s\src\DataAbstractionLib\WmiDataProvider\WmiConnectionManager.cs - Type System.Runtime.InteropServices.COMException:  (Microsoft.SoftwareCenter.Client.Data.WmiConnectionManager at ExecuteMethod) SCClient 19/10/2022 14:38:46 1 (0x0001)

StackTrace:    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)

   at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)

   at Microsoft.SoftwareCenter.Client.Data.WmiConnectionManager.ExecuteMethod(String methodClass, String methodName, Dictionary`2 methodParameters, String callerMethodName) SCClient 19/10/2022 14:38:46 1 (0x0001)

These errors suggested an issue with one of their application deployments, to verify this I suggested they exclude an affected device from all appplication deployments. 

This worked around the issue so the customer began a process of elimination to identify the specific application deployment which was causing the problem. 

Once the application was identified, its deployment was deleted and the application re-created.