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/
- Copy the SQL query and replace @missingSourceDirectory and @PackageId
- Execute the query and this should give you the KB Article and the Software Update Name
- Open the Software Update Deployment Package, and search for that KB Article
- Delete it from the deployment package
- Back to the Content Status monitoring, and check the status.
- 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
)
)
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.
ReplyDeleteI 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