SCCM SUP WSUS error

Question

Hi I am having an issue with SCCM SUP and WSUS.

In SCCM the sync is giving error code 0x80004005 and in the eventviewer I am getting SMSServer EventID 6703 SMS_WSUS_SYNC_MANAGER

WSUS Synchronization failed.
Message: SQL error.
Source: SqlExec.
The operating system reported error 2147500037: Unspecified error

When I check the WCM.log all seems fine and it says it can succesfully connect to WSUS.

When I check the WSUSCtrl.log all seems fine and its says it can connect to WSUS and There are no unhealthy WSUS Server components on WSUS Server {ServerName} and that it can connect to the Database.

But when I check the wsyncmgr.log I am getting some wierd issues.
It says it is able to find an active SUP and that it starts to sync with WSUS and that the sync has gone succesfully. it then goes to sleep for 120s and I get some wierd SQL error:

*** declare @Error int; declare @DBContentVersion int; exec spProcessSUMSyncStateMessage N'2021-01-06 15:21:39', N'P01', N'{D0388B31-EBB4-41BA-8740-85EFA1C6963E}', 1, 0, '12', @DBContentVersion output, @Error output, N'InternalServerFQDN'; Select @Error,@DBContentVersion SMS_WSUS_SYNC_MANAGER 1/6/2021 4:21:39 PM 12956 (0x329C)

*** [21000][512][Microsoft][SQL Server Native Client 11.0][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. : Update_SyncStatus_SUM_iu SMS_WSUS_SYNC_MANAGER 1/6/2021 4:21:39 PM 12956 (0x329C)

Sync failed: SQL error. Source: SqlExec SMS_WSUS_SYNC_MANAGER 1/6/2021 4:21:39 PM 12956 (0x329C)

STATMSG: ID=6703 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" SYS=InternalServerFQDN SITE=P01 PID=10796 TID=12956 GMTDATE=Wed Jan 06 15:21:39.964 2021 ISTR0="SqlExec" ISTR1="SQL error" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 LE=0X80004005 SMS_WSUS_SYNC_MANAGER 1/6/2021 4:21:39 PM 12956 (0x329C)

Sync failed. Will retry in 60 minutes SMS_WSUS_SYNC_MANAGER 1/6/2021 4:21:40 PM 12956 (0x329C)

I have removed the SUP role and completly removed WSUS. Reinstalled WSUS with a completly new database.
Have it sync with Microsoft update. after it was done (took 1 day) i reinstalled the SUP role and got the same error again.
I have no idea where to look now.. The communication is working, but for some reason there is an SQL error? And the database it is talking to is new.... Someone please help I have no clue

Answer 1

WSUS Automated Maintenance (WAM) © is a possibility - https://www.ajtek.ca/wam/what-is-wsus-automated-maintenance/

Full disclosure: WAM is our product.

Answer 2

Hi Amandayou-MSFT,

I followed your link, but at the step where you need to sync software updates from within the SCCM console it gives the error.
and the error pops up in the wsyncmgr.log. WSUS gives no errors on the other hand.
When I go so Software Updates within the SCCM console the last update that was released there is also from 2 weeks ago.
Within WSUS the updates are much newer.

Answer 3

Hi Amanda,

Yes this query indeed gives me the error:
Msg 512, Level 16, State 1, Procedure Update_SyncStatus_SUM_iu, Line 13 [Batch Start Line 0]
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

I have opened case at MS, because I knew this had to be something within the SQL database. Hope to get an answer soon!
Ty for responding much appreciated!