Monday, August 14, 2017

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 @PackageIdimage
  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
     )
)

10 comments:

  1. this blog is very informative and is highly competent in giving us the bestessays reviews. The blogger through this blog very competently helped us through his experience and i am sure my friends will find it as helpful as i did.

    ReplyDelete
  2. I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. Free App To Hide Pictures -PC - Don't Hang About Browsing, Study About Cellular Desktops On this web page how to encrypt files from folder lock

    ReplyDelete
  3. Hi friends, its an impressive piece of writing concerning culture and completely defined, keep it up all the time. Check out this site: How To Learn To Password Protect Folder In 1 Hour

    ReplyDelete
  4. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me. download office 2007

    ReplyDelete
  5. Around eight years after the fact more proficient machines were accessible which at last delivered the level lined paper sack known as a widespread holder (The Total Package, 60). Europa-Road targonca szállítás Debrecen

    ReplyDelete
  6. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. download do Toca Life HappyMod 2021

    ReplyDelete
  7. WhatsApp Group Links
    blog posts. Any way I'll be subscribing to your feed and I hope you post again soon
    WhatsApp Group Links

    ReplyDelete