MIM Sync Issue with User Profile and AD

Question

MIM Sync Issue with User Profile and AD

Sajith Gopalakrishnan Hema 1,056

The user nalkoohiji is removed from the AD. But it still shows in the SharePoint User Profile . The MIM shows the below error.

Export retry FAILED for Entry[ObjectType: user, Anchor: DOMAINNAME_nalkoohiji__753af5b6-1064-4898-b204-50504be1c185]..
Error: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> The MERGE statement conflicted with the FOREIGN KEY constraint "FK_ADImportFailedItems_DCId". The conflict occurred in database "Profile_DB", table "dbo.ADImportDCMapping", column 'DCId'.
The statement has been terminated.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.IdentityManagement.Connector.Sharepoint.SharePointProfileImportExportService.ProfileImportExportService.UpdateWithProfileChangeData(Int64 importExportId, ProfileChangeData[] profileChangeData)
at Microsoft.IdentityManagement.Connector.Sharepoint.SharepointServiceProvider.UpdateWithProfileChangeData(Int64 importExportId, ProfileChangeData[] profileChangeData)
at Microsoft.IdentityManagement.Connector.Sharepoint.SharepointConnector.PutExportEntries(IList`1 csEntries)

trevorseward 11,711 Reputation points

2021-01-26T15:44:30.83+00:00

Why are you deleting the user account from the UPSA? Instead, you should be deleting the account from Active Directory or moving the account out of scope of the MIM sync. This will automatically delete the user during the synchronization process.

You will need to manually delete this particular user from MIM since you deleted the account from the UPSA.

1 answer

Your answer

trevorseward 11,711 Reputation points

2021-01-26T15:44:30.83+00:00

Why are you deleting the user account from the UPSA? Instead, you should be deleting the account from Active Directory or moving the account out of scope of the MIM sync. This will automatically delete the user during the synchronization process.

You will need to manually delete this particular user from MIM since you deleted the account from the UPSA.

Answer 1

Chelsea Wu 6,341 Moderator

You can manually delete the user “nalkoohiji” from user profile service application under Manage User Profiles and then perform a full sync in MIM again.

Here is a post with similar issue for your reference: MIM Server SPMA Agent Error.

If an Answer is helpful, please click "Accept Answer" and upvote it.
**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. **

Sajith Gopalakrishnan Hema 1,056 Reputation points

2021-01-26T11:55:14.843+00:00

That was my old post, still I did not get a resolution.

Instead of deleting the user manually from the user profile, how it can be make it automatic from the MIM ?
Chelsea Wu 6,341 Reputation points Moderator

2021-01-27T01:49:24.09+00:00

Please see the references below for removing orphaned users in MIM Portal:

MIM 2016: finding & removing orphaned users and groups in MIM Portal.
SharePoint: The complete guide to user profile cleanup – Part 4 – 2016.
Chelsea Wu 6,341 Reputation points Moderator

2021-02-01T01:08:53.4+00:00

Hi @Sajith Gopalakrishnan Hema , do you have any progress on this thread? Please feel free to let us know if you need further assistance.

Share via

MIM Sync Issue with User Profile and AD

1 answer

Your answer