Syncing third party updates partial success

%3CLINGO-SUB%20id%3D%22lingo-sub-777883%22%20slang%3D%22en-US%22%3ESyncing%20third%20party%20updates%20partial%20success%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777883%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20sync%20third%20party%20catalog%20and%20get%20a%20partial%20success%20where%20a%20few%20updates%20don't%20sync%20because%20of%20the%20following%20error%20example%3A%3C%2FP%3E%3CP%3EException%20type%3A%20SqlException%3CBR%20%2F%3EException%20HRESULT%3A%20-2146232060%3CBR%20%2F%3EException%20Message%3A%20Violation%20of%20PRIMARY%20KEY%20constraint%20'PK__tbRevisi__43332583980A813A'.%20Cannot%20insert%20duplicate%20key%20in%20object%20'dbo.tbRevisionSupersedesUpdate'.%20The%20duplicate%20key%20value%20is%20(300392%2C%2000004850-0000-0000-5350-000000084500).~~error%20populating%20dbo.tbRevisionSupersedesUpdate%20table%20for%20update%2000004850-0000-0000-5350-000000092225%5C1~~The%20statement%20has%20been%20terminated.%3CBR%20%2F%3EException%20source%20.Net%20SqlClient%20Data%20Provider%3CBR%20%2F%3EException%20TargetSite%20Void%20DeserializeAndThrow(System.Web.Services.Protocols.SoapException)%3CBR%20%2F%3EStack%20at%20Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException%20soapException)~~%20at%20Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ImportUpdateForPublishing(String%20susXml%2C%20String%20uspXml%2C%20ServerSyncUrlData%5B%5D%20urlData%2C%20Boolean%20sdpOnly)~~%20at%20Microsoft.UpdateServices.Internal.BaseApi.Publisher.VerifyAndPublishPackage()~~%20at%20Microsoft.UpdateServices.Internal.BaseApi.Publisher.PublishPackage(String%20sourcePath%2C%20String%20additionalSourcePath%2C%20String%20packageDirectoryName%2C%20Boolean%20dualSign%2C%20String%20httpTimeStamp)~~%20at%20Microsoft.ConfigurationManager.ISVUpdatesSyncAgent.WSUS.UpdateServicesWrapper.PublishUpdateMetadataOnly(ILogger%20logger%2C%20SoftwareDistributionPackage%20updateSdp%2C%20StatusMessageReporter%20statusMessageReporter)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-777883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECM%20current%20branch%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Escup%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESoftware%20Update%20Management%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Contributor

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.

0 Replies