SCENARIO:
ITMS 8.x
The Notification Server (NS) had prevously received a status of "Ready" as well as the downloaded codebases from the Package Server prior to the disk failing. As a result, when the SMA requested the Package Server Installation package files to download, the NS referred the Package Server's base agent, for downloading, to itself. However, the files it is told to download do not exist because they were on the disk that failed and therefore no longer exist. The NS was unaware of this.
Modified the database so that the NS does not receive a Ready status for the package(s) when the Package Server requests it. By so doing the NS will allow the SMA to download the package files directly from it, instead of referring the package server to itself.
declare @psName nvarchar(50) = 'SS-Child2'
declare @psGuid uniqueidentifier = (select Guid from vRM_Computer_Item where Name = @psName)
update SWDPackageServer set [Status] = 'Not Ready' where PkgSvrId = @psGuid and [Status] = 'Ready'
delete from SWDPackageCodebase where [Source] = @psGuid
delete from ResourceUpdateSummary where InventoryClassGuid = '9E6F402A-6A45-4CBA-9299-C2323F73A506' and ResourceGuid = @psGuid