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 ...