SUP Syncing issues

[Ghost Image]

 

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 September 13, 2017 by Ghost Image
Format was wrong