SOLVEDSCCM SMS_STATE_SYSTEM CRITICAL ERROR

J

Jahandar

New Member
2
0
1
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



sccm error.PNGPlease refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.
chrisleon15

chrisleon15

Member
18
0
1
Hi Guys

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

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

TIA

CL
chrisleon15

chrisleon15

Member
18
0
1
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.

1689844008852.png

1689843942019.png

1689843715911.png
Thanks for helping
Garth

Garth

Well-Known Member
Staff member
1,780
152
63
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

chrisleon15

Member
18
0
1
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?

1689957868019.png
TIA

CL
Garth

Garth

Well-Known Member
Staff member
1,780
152
63
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
这是如何与你的网站的升级吗?Do you care about this application? Does the Object exist? Can you access it?
chrisleon15

chrisleon15

Member
18
0
1
这是如何与你的网站的升级吗?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

Forum statistics

Threads
5,686
Messages
22,170
Members
12,388
Latest member
Mike2202