SOLVEDSCCM SMS_STATE_SYSTEM CRITICAL ERROR

[Jahandar]

Hi.We have a critical error in SCCM 1902 Current Branch.Help please.


Microsoft SQL Server reported SQL message 245, severity 16: [22018][245][Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the nvarchar value '^6\' to data type smallint. : spLifecycleRefreshAndSummarize



Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

[Harshit Pandey]

How is this error affecting your SCCM setup ?.

[Jahandar]

How is this error affecting your SCCM setup ?.

This error is not affecting to our Sccm.Everything works fine,but critical error showing on component status

[Brady Ross]

Were you ever able to find out any information about this error? i am seeing the same thing. thanks

[Soufiane]

Were you ever able to find out any information about this error? i am seeing the same thing. thanks

[Anil Bhatt]

Any one can help me for bellowed screen shot

[Garth]

Any one can help me for bellowed screen shot

View attachment 5093

Did you read the log file listed within the message?

[hth华体会体育全站]

Can you upload the statesys.log?.

[chrisleon15]

Hi Guys

Can anyone help, I am getting sync issues but just cant seem to solve the problem.


If anyone has came across this before and managed to resolve please can you share what you did to fix it?

TIA

CL

[Garth]

Hi Guys

Can anyone help, I am getting sync issues but just cant seem to solve the problem.

View attachment 5422
If anyone has came across this before and managed to resolve please can you share what you did to fix it?

TIA

CL

What does the actual error message say? What troubleshooting have you done?