“A .NET Framework error occurred during execution of user-defined routine or aggregate” in StateSys.log and SMS_STATE_SYSTEM component has a “Critical” status

“A .NET Framework error occurred during execution of user-defined routine or aggregate” in StateSys.log and SMS_STATE_SYSTEM component has a “Critical” status

If I look in the ConfigMgr Console the SMS_STATE_SYSTEM Component is showing with a Critical Status.

If I look in the StateSys.log I see:

*** [42000][6522][Microsoft][SQL Server Native Client 11.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate “fnReadMDMPolicyCertValidationDuration”: ~~System.Data.SqlTypes.SqlTypeException: Two strings to be compared have different collation.~~
System.Data.SqlTypes.SqlTypeException: ~~
at System.Data.SqlTypes.SqlString.StringCompare(SqlString x, SqlString y)~~
at System.Data.SqlTypes.SqlString.Compare(SqlString x, SqlString y, EComparison ecExpectedResult)~~
at Microsoft.SystemsManagementServer.SQLCLR.CryptoUtility.fnReadMDMPolicyCertValidationDuration(SqlString MessageText)~~.
: sp_UpdateAPNSCertAlertVariable