locked
Distribution Point un-installation failed to complete on the server - How to remove DP from SCCM DB manually RRS feed

  • Question

  • Hello and thanks in advance for helping on this question,

    The sms_distribution_manager component keeps flagging an error "Distribution Point un-installation failed to complete" and "failed to connect to distribution point" for a server that was decommissioned a while ago.

    How do I remove the DP server from SCCM to stop the error messages, I want to upgrade the server to current branch so would like to remove any errors etc. before running the upgrade tasks.


    many thanks

    Tuesday, August 30, 2016 11:44 AM

Answers

  • You should have to to uninstall the DP before server decommisioned,

    IF the server was already decommissioned then there is no method to uninstall the DP from console. <o:p></o:p>

    make sure the package and applications are removed from the DP. <o:p></o:p>

    following query you can use,<o:p></o:p>

    Note:- Using SQL query to remove anything is not supported and not recommended. these query are as is, no warranty 

    Delete from pkgservers where NALpath like '%\\DP%'  and pkgID=''
    Delete from pkgstatus where pkgserver like '%\\DP%'  and ID=''
    Delete from contentdpmap where serverpath like '%\\Dp%'  and contentID=''
    delete from PkgServers_L where NALPath like '%DP%' and pkgID=''
    delete from PkgStatus_l where PkgServer like '%DP%' and ID=''
    Delete from SC_SysResUse where NALPath like '%dp%'
    
    Delete from SysResList where ServerName like '%DP%' 
    
    Delete from SC_SysResUse where NALPath like '%DP%'
    
    Delete from v_DistributionPoint where ServerNALPath like '%DP%'
    
    Delete from PkgServers where NALPath like '%DP%'
    
    Delete from PkgStatus where Location like '%DP%'
    
    Delete from DistributionContentVersion where DPNALPath like '%DP%'
    
    Delete from DistributionStatus where DPNALPath like '%DP%'
    
    Delete from DPGroupMembers where DPNALPath like '%DP%'
    
    Delete from DistributionPoints where NALPath like '%DP%'


    <o:p></o:p>


    Sharad Singh | My blogs: SharadTech | Twitter: @SinghSharaad | | Please remember to click “Mark as Answer” on the post that helps you.This can be beneficial to other community members reading the thread.

    Tuesday, August 30, 2016 12:52 PM

All replies

  • Check distmgr.log and the status messages to find out why it can't remove the DP.

    Jason | http://blog.configmgrftw.com | @jasonsandys

    Tuesday, August 30, 2016 12:19 PM
  • Hi Jason,

    The server has been been decommissioned, so it no longer exists.


    many thanks

    Tuesday, August 30, 2016 12:42 PM
  • You should have to to uninstall the DP before server decommisioned,

    IF the server was already decommissioned then there is no method to uninstall the DP from console. <o:p></o:p>

    make sure the package and applications are removed from the DP. <o:p></o:p>

    following query you can use,<o:p></o:p>

    Note:- Using SQL query to remove anything is not supported and not recommended. these query are as is, no warranty 

    Delete from pkgservers where NALpath like '%\\DP%'  and pkgID=''
    Delete from pkgstatus where pkgserver like '%\\DP%'  and ID=''
    Delete from contentdpmap where serverpath like '%\\Dp%'  and contentID=''
    delete from PkgServers_L where NALPath like '%DP%' and pkgID=''
    delete from PkgStatus_l where PkgServer like '%DP%' and ID=''
    Delete from SC_SysResUse where NALPath like '%dp%'
    
    Delete from SysResList where ServerName like '%DP%' 
    
    Delete from SC_SysResUse where NALPath like '%DP%'
    
    Delete from v_DistributionPoint where ServerNALPath like '%DP%'
    
    Delete from PkgServers where NALPath like '%DP%'
    
    Delete from PkgStatus where Location like '%DP%'
    
    Delete from DistributionContentVersion where DPNALPath like '%DP%'
    
    Delete from DistributionStatus where DPNALPath like '%DP%'
    
    Delete from DPGroupMembers where DPNALPath like '%DP%'
    
    Delete from DistributionPoints where NALPath like '%DP%'


    <o:p></o:p>


    Sharad Singh | My blogs: SharadTech | Twitter: @SinghSharaad | | Please remember to click “Mark as Answer” on the post that helps you.This can be beneficial to other community members reading the thread.

    Tuesday, August 30, 2016 12:52 PM
  • Hi,

    Thanks for the information, the decomm was actioned before I took over the site, so I was not involved with it unfortunately.

    I will update the management team, thank you for the advice.


    many thanks

    Tuesday, August 30, 2016 1:28 PM