Skip to content

SUP Syncing issues

Featured Replies

 

Hi, All

I wondering if anyone has seen this error before, if so is there a known fix for it, the strange thing is that the WSUS is working fine downloading updates, I see them in the WSUS console but once it finishes syncing and try’s to populate the SCCM SUP I get this error, this sever has been working for last 2 years with no issues then one day the error started showing up in the logs.  Also the database is WID not SQL.  Uninstalled Re-installed WSUS and SUP with the same results.

So any help with this would be greatly appreciated.

 

*** declare @Error int; exec spProcessSUMSyncStateMessage N'2017-09-13 15:25:48', N'LP2', N'{A9D53A25-27B9-41C4-8D6B-D894251BC4BE}', 1, 0, '81', @Error output,  N'LP-SMS.**Domain Name** SMS_WSUS_SYNC_MANAGER 9/13/2017 10:25:48 AM 13636 (0x3544)
*** [42000][8114][Microsoft]

Error converting data type nvarchar to int. : spProcessSUMSyncStateMessage SMS_WSUS_SYNC_MANAGER 9/13/2017 10:25:48 AM 13636 (0x3544)


 Sync failed: SQL error. Source: SqlExec SMS_WSUS_SYNC_MANAGER 9/13/2017 10:25:48 AM 13636 (0x3544)

 STATMSG: ID=6703 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" SYS=LP-SMS.legacycpas.com SITE=LP2 PID=12932 TID=13636 GMTDATE=Wed Sep 13 15:25:48.810 2017 ISTR0="SqlExec" ISTR1="SQL error" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_WSUS_SYNC_MANAGER 9/13/2017 10:25:48 AM 13636 (0x3544)

 Sync failed. Will retry in 60 minutes SMS_WSUS_SYNC_MANAGER 9/13/2017 10:25:48 AM 13636 (0x3544)


 

Edited by Ghost Image
Format was wrong

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.