Deleted package continuously trying to distribute to DP...

[MRaybone]

Hi guys,

 

One of my primary child sites is continuously trying to download a package which was deleted from the central site ages ago. No trace of the package exists on the central site, and the broken primary spends all it's time attempting and waiting every few seconds for the package to appear, so much so that I think it won't receive any new packages until this broken process stops. Does anyone have any idea how I cleanse the site of this phantom package?

 

Many thanks,

 

MRaybone.

[MRaybone]

Received help from a myitforum.com member who suggested, with the help of some SQL queries...

[ http://www.myitforum...&mpage=1#226481 ]

 

1) Locating the package on sites...

 

/****** Script for SelectTopNRows command from SSMS ******/

SELECT [PkgID]

,[Name]

,[Version]

,[Language]

,[Manufacturer]

,[Description]

,[source]

,[sourceSite]

,[storedPkgPath]

,[RefreshSchedule]

,[LastRefresh]

,[shareName]

,[PreferredAddress]

,[storedPkgVersion]

,[storePkgFlag]

,[shareType]

,[Permission]

,[useForcedDisconnect]

,[ForcedRetryDelay]

,[DisconnectDelay]

,[ignoreSchedule]

,[Priority]

,[PkgFlags]

,[MIFFilename]

,[MIFPublisher]

,[MIFName]

,[MIFVersion]

,[sourceVersion]

,[sourceDate]

,[sourceSize]

,[sourceCompSize]

,[updateMask]

,[Action]

,[icon]

,[Hash]

,[ExtData]

,[imageFlags]

,[updateMaskEx]

,[iSVData]

,[HashVersion]

,[NewHash]

,[imagePath]

,[Architecture]

,[PackageType]

,[AlternateContentProviders]

,[sourceLocaleID]

,[rowversion]

FROM [dbo].[sMSPackages]

 

 

2) Finding the package...

First Query to find the package

select * from SMSPackages where PkgID = 'XXX00001'

select * from PkgStatus where ID = 'XXX00001'

select * from PkgServers where PkgID = 'XXX00001'

 

 

3) Then deleting the package from the DB...

 

Second Query to delete the package

delete from SMSPackages where PkgID = 'XXX00001'

delete from PkgStatus where ID = 'XXX00001'

delete from PkgServers where PkgID = 'XXX00001'

[anyweb]

nice, did it work ? and did you do this on the primary or central ?