After R2 SP1 installation: SMS_State_System has errors

I installed SP1 on a existing configuration manager installation (fresh install no CU installations).

Everything is fine, only the SMS_State_System component shows errors

Microsoft SQL Server reported SQL message 6522, severity 16: [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 c

in the statesys.log i find the following error

*** [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

Can someone help me or point me in the right direction to solve this problem?

best regards and thenk you in advance.


May 26th, 2015 12:27pm

Hello,

Have you checked in the SQL server log ? maybe you will find something more usefull. The collation on your database has changed ?

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2015 4:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics