Hi all,
I'm trying to sync third party catalog and get a partial success where a few updates don't sync because of the following error example:
Exception type: SqlException
Exception HRESULT: -2146232060
Exception Message: Violation of PRIMARY KEY constraint 'PK__tbRevisi__43332583980A813A'. Cannot insert duplicate key in object 'dbo.tbRevisionSupersedesUpdate'. The duplicate key value is (300392, 00004850-0000-0000-5350-000000084500).~~error populating dbo.tbRevisionSupersedesUpdate table for update 00004850-0000-0000-5350-000000092225\1~~The statement has been terminated.
Exception source .Net SqlClient Data Provider
Exception TargetSite Void DeserializeAndThrow(System.Web.Services.Protocols.SoapException)
Stack at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)~~ at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ImportUpdateForPublishing(String susXml, String uspXml, ServerSyncUrlData[] urlData, Boolean sdpOnly)~~ at Microsoft.UpdateServices.Internal.BaseApi.Publisher.VerifyAndPublishPackage()~~ at Microsoft.UpdateServices.Internal.BaseApi.Publisher.PublishPackage(String sourcePath, String additionalSourcePath, String packageDirectoryName, Boolean dualSign, String httpTimeStamp)~~ at Microsoft.ConfigurationManager.ISVUpdatesSyncAgent.WSUS.UpdateServicesWrapper.PublishUpdateMetadataOnly(ILogger logger, SoftwareDistributionPackage updateSdp, StatusMessageReporter statusMessageReporter)
Tried searching with no luck. WSUS DB is maintained and the catalog was removed and re added.
Any help would be appreciated.
Rahamim.
