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?

[chrisleon15]

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

Hi Garth

Thank you so much for coming back to me. I have been trying to fix this issue for 2weeks now. I am new to SCCM and not sure which steps I need to troubleshoot in this issue. here are some logs if you are able to help or may know what the cause or fix is.






Thanks for helping

[Garth]

Since you have a CAS and therefore over 150k devices, you should open a support call directly with Microsoft. It is a rarity for people to have over 150k of devices.

[chrisleon15]

Since you have a CAS and therefore over 150k devices, you should open a support call directly with Microsoft. It is a rarity for people to have over 150k of devices.

Hi Garth,

We dont have 150K devices. Where did you see that information?

[Garth]

Hi Garth,

We dont have 150K devices. Where did you see that information?

Because you have a CAS. Only company with 150k device need a CAS.