SOLVED SCCM 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?

 

[Prajwal Desai]

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.

 

[chrisleon15]

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

Oh lol, it was build and like this before I came here hahaah. I managed to get it up and running and synced not Garth.

I am having 1 more issue but cant seem to find a resolution. Have you seen this before trying to delete or edit a package?


TIA

CL

 

[Garth]

Oh lol, it was build and like this before I came here hahaah. I managed to get it up and running and synced not Garth.

I am having 1 more issue but cant seem to find a resolution. Have you seen this before trying to delete or edit a package?

View attachment 5426
TIA

CL

How is this related to the upgrading of your site? Do you care about this application? Does the Object exist? Can you access it?

 

[chrisleon15]

How is this related to the upgrading of your site? Do you care about this application? Does the Object exist? Can you access it?

No I am trying to delete it, the object is there as I can deploy the application and install it through the software center. it just wont let me edit or delete it.

Regards

CL