Reassigning DP to primary site

Question

Hi, I want to reassign DP to primary site but see this error in the log:

*** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]Error! Failed to update sql data for reassign distribution point. : spMoveDistributionPoint SMS Provider 11/9/2022 7:24:53 AM 20920 (0x51B8)
~~[42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]Error! Failed to update sql data for reassign distribution point. : spMoveDistributionPoint ThreadID : 20920 , DbError: 50000 , Sev: 16~~ SMS Provider 11/9/2022 7:24:53 AM 20920 (0x51B8)

SELECT * FROM DistributionContentVersion DCV
LEFT JOIN DistributionPoints DP ON DP.NALPath = DCV.DPNALPath
WHERE DCV.SiteCode <> DP.SMSSiteCode

returns nothing.

What can I do here?

Answer 1

Hi, @Bojan Zivkovic

Thank you for posting in Microsoft Q&A forum.

The query return nothing means there are no duplicate rows in the DistributionContentVersion table after you reassign a DP.
Have we queried the DistributionContentVersion table directly to see if there are no duplicate rows?

Select * from DistributionContentVersion  

Have we also checked distmgr.Log for more details?

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Select * from DistributionContentVersion returns more than 3000 rows ...

Answer 3

I have the same exact problem. We are in the process to flatten our SCCM infrastructure by removing the secondary sites and replace them by distribution points and when necessary MP as well. We have a remote secondary site and a DP assigned to this secondary site. From SCCM console, when I try to reassign the DP to my primary site, I get the following error

****** [42000][50000][Microsoft][SQL Server Native Client 11.0][SQL Server]Error! Failed to update sql data for reassign distribution point. : spMoveDistributionPoint***

There are no other roles installed on the server other than the DP role. I also have checked this query and fortunately I have no records:

SELECT * FROM DistributionContentVersion DCV
LEFT JOIN DistributionPoints DP ON DP.NALPath = DCV.DPNALPath
WHERE DCV.SiteCode <> DP.SMSSiteCode

Still I do not understand what the issue really is!

From SQL, I tried to run this:

EXEC spMoveDistributionPoint 'PRI', '["Display=\FQDN"]MSWNET:["SMS_SITE=SS1"]\FQDN'

But I got the following error

Msg 50000, Level 16, State 1, Procedure spMoveDistributionPoint, Line 321 [Batch Start Line 7]

Error! Failed to update sql data for reassign distribution point.

I have looked at tons of other articles on the web, but none solved my issue