Error: "Unable to refresh the codebase information for package: '"Package Name"' ({Package GUID} Could not access the package path.

Products

• Patch Management Solution for Windows
• IT Management Suite

Issue/Introduction

During the Package Refresh process codebases are unable to be created for various Patch Management related software updates as the files are no longer physically present on the Notification Server. The following error is seen in the logs:

Unable to refresh the codebase information for package: 'install_flash_player_18_plugin.exe' (36f01079-be58-9694-6b16-0f91093b3688)
Could not access the package path. Package: 'install_flash_player_18_plugin.exe' (36f01079-be58-9694-6b16-0f91093b3688), Path: D:\Patch Management\Packages\Updates\APSB15-16\{32812b6d-68f1-42dc-9d2a-00430933bc9e}

Environment

ITMS 8.x

Cause

In this case there were ~1,000 Patch packages that no longer have the binaries downloaded (they really aren't needed) and the 'Check Software Update Package Integrity' task did not remove these packages from the CMDB.

Resolution

With our ITMS 8.8 Release, now you can identify what packages have an invalid source path. Refer to:
"Identify what packages need to be deleted due to invalid package paths"

 

Assuming that the Package Refresh has done all that it can do and there are Patch packages that it cannot build, then the following SQL should help.

NOTE: PLEASE ENSURE YOU HAVE A RECENT BACKUP OF THE SYMANTEC_CMDB!

The SQL will do the following:

1. Identify all packages that have the ProductGuid for Patch Management
2. Of all Patch packages it will only pull those that have no codebases generated by the NS
3. Of those that belong to Patch and have no codebases, include only those that aren't already in "ItemToDelete"

insert into ItemToDelete (Guid,DeleteDate)
select distinct p.Guid, GETDATE()
from vRM_Package_Item p
left join ItemToDelete d on d.Guid = p.Guid
left join SWDPackageCodebase cb on cb.PackageId = p.Guid
  and cb.[Source] is NULL
where p.ProductGuid = 'B1338338-5575-4A27-9808-23BEC40D79FA'
and cb.PackageId is null
and d.Guid is null