SCCM Software Update Deployment Package Distribution Error | Content/Package does no exist

Hold on there! Don’t take the step to create a new package and re-download all the content into new package yet!

My customer has a 10GB software update deployment package. It will cost a lot of replication traffic if he create a new package and re-download the entire package.

Copy the SQL query from this blog, https://blogs.technet.microsoft.com/ken_brumfield/2013/01/10/troubleshooting-sccm-software-update-deployment-package-distribution-due-to-missing-directories/

1. Copy the SQL query and replace @missingSourceDirectory and @PackageId
2. Execute the query and this should give you the KB Article and the Software Update Name
3. Open the Software Update Deployment Package, and search for that KB Article
4. Delete it from the deployment package
5. Back to the Content Status monitoring, and check the status.
6. Repeat the steps above if you see a new GUID error

SQL Query:

DECLARE
@MissingSourceDirectory
NVARCHAR(512)
DECLARE
@PackageId
NVARCHAR(8)
SET
@MissingSourceDirectory =
'c34e2458-681f-4a8b-8941-a460c2de314a'
SET
@PackageId
= '0020000D'

SELECT
CASE
         WHEN
ci.BulletinID LIKE
''
OR ci.BulletinID IS
NULL
THEN
'Non Security Update'
         ELSE ci.BulletinID
         END
As
BulletinID
     , ci.ArticleID
     , loc.DisplayName
     , loc.Description
     , ci.IsExpired
     , ci.DatePosted
     , ci.DateRevised
     , ci.Severity
     , ci.RevisionNumber
     , ci.CI_ID
FROM dbo.v_UpdateCIs
AS
ci
LEFT
OUTER
JOIN dbo.v_LocalizedCIProperties_SiteLoc
AS
loc
ON
loc.CI_ID = ci.CI_ID
WHERE ci.CI_ID IN
(
     SELECT [FromCI_ID]
     FROM
[dbo].[CI_ConfigurationItemRelations]
cir
     INNER
JOIN [dbo].[CI_RelationTypes]
rt
ON
cir.RelationType = rt.RelationType
     WHERE
cir.ToCI_ID IN
     (
         SELECT
CI_ID
         FROM
[dbo].[CI_ContentPackages]
cp
         INNER
JOIN [dbo].[CI_ConfigurationItemContents]
cic
ON
cp.Content_ID = cic.Content_ID
         WHERE
cp.ContentSubFolder = @MissingSourceDirectory AND cp.PkgID = @PackageId
     )
)