We have the default SSPR install. The only MAs that we use are AD (full import, full sync) and FIM (full sync, export). So, basically we are importing the users from AD into FIM Portal for SSPR.

The process was running fine for a couple of months. Then there was a "server-stopped" error on export operation. Even viewer said that the connection to the database timed out. So the server was restarted.

After that the jobs were run again in order "AD full import, AD full sync, FIM Full sync, and FIM export". This resulted in "completed-export-errors" for FIM export. The user accounts that are in the export error list are already in FIM Portal and hence the error about value violates uniqueness.

I saw a few articles online but wasn't sure if it really pertained to this case. Some talk about creating import attributes, some about running stored process to clear the duplicates (I wasn't able to locate the procedure in the database), some about permissions, etc.

Can anyone please suggest a good resolution to get rid of these duplicates? (since these users are in the portal and registered with SSPR, I don't think deleting them from portal is a good option?)

Are there many of those? if not, you can delete them in FIM and run Delta Import - Delta Sync in FIM

MA.  If they are registered for SSPR, they will have to register.&