Text only | Text with Images

Support Forum: Get Support for Patch My PC Products and Services

Commercial Products: Support for Our Enterprise Product for Microsoft ConfigMgr and Intune => Commercial/Paid Products: Support and General Questions (ConfigMgr and Intune) => Topic started by: tim_env on September 13, 2023, 02:22:24 PM

Title: Downstream server won't syncronize after deployment
Post by: tim_env on September 13, 2023, 02:22:24 PM
Last month we were only monitoring, this is our first month deploying 3rd party patches and after enabling the downstream WSUS can no longer synchronize and throws a SQL error.

Code Select
SqlException: Can not create an install deployment to an update that does not support install
The transaction ended in the trigger. The batch has been aborted.
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
   at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
   at Microsoft.UpdateServices.Internal.SingleResultSetSPHandler.ExecuteStoredProcedure(DBConnection connection)
   at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds)
   at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler)
   at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleResultSet(String spName, DBParameterCollection args, Type resultType, Int32 queryTimeoutInSeconds)
   at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleResultSet(String spName, DBParameterCollection args, Type resultType)
   at Microsoft.UpdateServices.Internal.DatabaseAccess.Admin
Title: Re: Downstream server won't syncronize after deployment
Post by: Raunak Desai (Patch My PC) on September 14, 2023, 09:29:18 PM
Hey Kim !

Hope you are keeping well.

This issue requires a detailed troubleshooting and I would suggest you to create a support case with us :https://patchmypc.com/technical-support

Regards,
Raunak
Title: Re: Downstream server won't syncronize after deployment
Post by: Ben Whitmore (Patch My PC) on September 22, 2023, 02:26:14 AM
Hi Tim,

Are you syncing Oracle Java SE Development Kit 8/11/21 out of interest?
Title: Re: Downstream server won't syncronize after deployment
Post by: Ben Whitmore (Patch My PC) on September 22, 2023, 02:30:03 AM
Ah, we are working on this with Lukas today :)
Title: Re: Downstream server won't syncronize after deployment
Post by: tim_env on September 22, 2023, 07:45:18 AM
I am not sure on JDK.  We disabled it for the time being and my coworker will open a ticket before we look at it again.
Title: Re: Downstream server won't syncronize after deployment
Post by: Ben Whitmore (Patch My PC) on September 22, 2023, 08:52:54 AM
Thanks Tim,

We resolved this today with Lukas. The downstream WSUS server had corrupt column information for some of the updates in the database. We cleared those up and the errors were resolved.
Text only | Text with Images