locked
Deleted DP is still referenced under packages that were previously copied to it RRS feed

  • Question

  • We had a multicast DP setup as a site system, but now we don't need it anymore and take it out of production.  Under Site Systems node, I don't see it anymore, but packages that were previously copied to it still think the DP is there and indicate that the package fails to copy over and keep on retrying after I updated the packages for all distribution points. Is there anyway I can make SCCM get rid any references to the multicast DP completely? I alreaydy tried to restart the server, but doesn't work.

    Thursday, March 31, 2011 8:41 PM

Answers

  • If the normal methods are not working for you, you need to call CSS, they are the only ones that can help you.


    http://www.enhansoft.com/
    Thursday, March 31, 2011 10:48 PM

All replies

  • use this SQL syntax to locate the DP's in the DB and then you can remove them.  In the display 1 syntax, replace the sitecode with the sitecode of site B.  This should give you a list of known DP's to that site.  

    Careful when deleting. works tih SMS alright. Let me know if it works with SCCM

    Display 1
    Select * from pkgstatus where Sitecode = 'XXX'
    Select * from pkgservers where Sitecode = 'XXX'


    In display 2, choose the name of the DP you'd wish to remove.

    Display 2
    Select * from pkgstatus where Sitecode = 'XXX' and pkgserver like '%dp-name%'
    Select * from pkgservers where Sitecode = 'XXX' and nalpath like '%dp-name%'

    Once your satisifed that you have the DP you wish to delete listed in the syntax of Display 2, then enter that Dp's name into the Delete 1.

    Delete 1
    Delete from pkgstatus where Sitecode = 'XXX' and pkgserver like '%dp-name%'
    Delete from pkgservers where Sitecode = 'XXX' and nalpath like '%dp-name%'

    Thursday, March 31, 2011 9:24 PM
  • The queries above is completely unsupported  by MS and this is NOT the way to handle removing packages from DPs. Editing the db without CSS, make your setup unsupported.


    http://www.enhansoft.com/
    Thursday, March 31, 2011 10:21 PM
  • What is the correct way to removing the ghost DP then? I imagine there are other people who have the same issue too so there must be a supported solution out there by MS.

    Thursday, March 31, 2011 10:37 PM
  • If the normal methods are not working for you, you need to call CSS, they are the only ones that can help you.


    http://www.enhansoft.com/
    Thursday, March 31, 2011 10:48 PM