Home

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
RahamimL
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies