Each time a full AD import is attempted, the error, "Cannot insert duplicate key row in object," is shown in the log files.
The cause of this problem is that there is a duplicate entry in one of the resource tables.
This can happen if machines are moved in Active Directory but the Synchronization Schedule has not moved them in Notification Server. It can also happen if you are using virtual machines and any Discovery process (AD import, Network discovery, Resource Discovery) because virtual machines get listed as virtual machine not standard computer resources we create duplicates every time we do a discovery and the duplicate is put in the resource tree. Causing the problem.
If this error occurs, then the NSE created by the import will end up failing to actually import into the database.
SET ClassGuid = '539626D8-A35A-47EB-8B4A-64D3DA110D01'
WHERE (ClassGuid LIKE '1F54FC7C-6DFB-4EFE-AB2B-97194CDD75E8')
Active Directory Import