SCCM SUP WSUS error

Question

Hi I want to create this on the english forum, but I am unable to select a catogory when I select english in 3 different browsers. 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

Hi RubenWelle,

I'm Donata, an independent advisor. Community is just a consumer forum. Due to the scope of your question, can you please post this question on Microsoft Q&A: https://docs.microsoft.com/en-us/answers/products/

Kind regards.