question

ThomasButterfield-6545 avatar image
0 Votes"
ThomasButterfield-6545 asked Jason-MSFT answered

SCCM Build 2010 Duplicate Windows Products In Software Update Database

Hello,

In SCCM (Build 2010) I create ADR's every month for our server patching using a scripted process and this month (December 2020) it began to fail.

It seems when creating an ADR using the SCCM PS Module the cmdlet is matching duplicate entries for "Windows Server 2016" and "Windows Server 2019".

New-CMSoftwareUpdateAutoDeploymentRule : The parameters specified matches more than one collection.
At line:11 char:5
+ New-CMSoftwareUpdateAutoDeploymentRule `
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : LimitsExceeded: (Microsoft.Confi...mentRuleCommand:NewSoftwareUpda...mentRuleCommand) [New-CMSoftwareUpdateAutoDeploymentRule], Argu
mentException
+ FullyQualifiedErrorId : TooManyResults,Microsoft.ConfigurationManagement.Cmdlets.Sum.Commands.NewSoftwareUpdateAutoDeploymentRuleCommand

My question is how do I cleanup / remove the duplicate products entries and has anyone else come across this issue?

49752-sccm-duplicate-products.jpg




mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered

@ThomasButterfield-6545
Thank you for posting in Microsoft Q&A forum.
Yes, it seems a random issue for different SCCM version, I have two SCCM labs, version 2010 works well but version 2006 has the same issue.
And @Jason-MSFT has opened a bug on this issue.
For the details, you may refer to this thread:
https://docs.microsoft.com/en-us/answers/questions/197708/how-can-i-download-updates-for-windows-10-2004.html


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

prajwaldesai avatar image
0 Votes"
prajwaldesai answered Jason-MSFT commented

The issue is observed when you have ConfigMgr 2002 as well. So I don't think the issue is related to ConfigMgr build.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Correct. The issue stems from duplicate names being published to the WSUS catalog. These duplicate names are actually new sub-categories and this is acceptable in WSUS but I don't think has ever been done before so has never surfaced as an issue in ConfigMgr which assumes the names will all be unique and does not account for different sub-categories.

We are considering issuing a hotfix for this but I don't know the exact status at this time.

0 Votes 0 ·
prajwaldesai avatar image
0 Votes"
prajwaldesai answered

Thanks Jason. I will be publishing a post letting others know that they don't need to panic if they notice this issue.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

prajwaldesai avatar image
0 Votes"
prajwaldesai answered

Workaround for ConfigMgr SUP showing duplicate entries for Windows Products. Thanks to Jason Sandys for providing additional info - https://www.prajwaldesai.com/configmgr-sup-shows-duplicate-entries/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Viktor-6474 avatar image
0 Votes"
Viktor-6474 answered

I'm not sure this is a problem only in WSUS, because I have the following error with double found malware
72094-screen.jpg



screen.jpg (164.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Jason-MSFT avatar image
0 Votes"
Jason-MSFT answered

Sorry Viktor, I'm not sure exactly what you are trying to point out here, the duplication of items in the malware detected view is completely unrelated to the issue causing the duplication of products in the SUP product list.

I suggest that you start a new thread for your issue if you are seeking help.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.