Summary:

Merge Person functionality is not working on Integrated Systems

Symptoms:

1. Select a company were duplicate people will be found. Click on the person to be merged.
2. Click on the Merge Person Button. The merge person panel appears 

Description

3. When clicking on the search for source person to be merged, no people are found. 
Description

Cause: 

If we look at the sql logs, it fires a query that says 

SELECT TOP 51  Pers_PersonId, Pers_FullName,pers_phonecountrycode,pers_phoneareacode,pers_phonenumber

FROM vSearchListPerson  WITH (NOLOCK) 

WHERE (Pers_FullName LIKE N'%' ESCAPE '|' OR COALESCE(Pers_FullName, N'') = N'')

and pers_Deleted is Null and (Pers_CompanyID=28 AND  (Pers_AccountID IS NULL) 

AND  (Pers_PersonID<>47)) order by Pers_FullName

It is taking Pers_AccountID as NULL that’s why it is showing no records.


Description

Resolution: 

If we remove AND  (Pers_AccountID IS NULL)  it will show the records

Description

More information:

Occurs on most of the Murano integrated systems. Found in 7.3 SP3, 2017 R1.1 and will be fixed in 2017 R3