Issue
AD Contact not being recreated after an accidentally deleted user is pasted back into the Domino Directory.
Solution
1. User is deleted from the Domino Directory through normal means or by accident
2. Deletion gets processed by the DirSync task
3. AD contact is deleted
4. Administrator attempts to paste in the person document of the deleted users from a back of the domino directory
5. DirSync task runs but document is not properly processed which in turn does not create the AD contact
This is a known issue and a workaround for this issue is:
1. Paste the person document of the deleted user back into the Domino Directory from a backup
2. Delete the specific SQL entry for that user in the Coexistence SQL database (basic instructions on how to do so are below, more advanced queries may be necessary in some larger environments)
3. Edit then save the person document that was recently pasted back into the Domino Directory
4. This in turn will cause the DirSync task to recognize the newly updated modified date and push that data to SQL. A new SQL entry will be created. From SQL, a new AD contact will be created. These tasks will occur during the scheduled run times for DirSync which may differ in every environment.
--------------------------------------------------------------------------------------------------------------
How to find and delete a specific SQL entry:
1. After you have SQL Server Management Studio open, navigate to the Coexistence database (typically called BTCodex, but may vary depending on the environment).
2. Expand the database, then expand the Tables section
3. Find the dbo.BT_Person table and right click on it. Select Edit All Rows
4. Depending on how many items are in your environment, this could take some time. When the results finally load, you will need to scan through the items to find the specific individual you would like to delete.
5. After you confirm that you have selected the appropriate individual (verify by name, internet address, etc), select it by clicking on the left side of the row
6. You then should be able to right click when the item is selected and delete the individual (ensure you only have one item selected when doing so as to avoid accidentally deleted other valid entries)
7. After deleting the entry, go back to the person document in the Domino directory and edit the document. After the document is in edit mode, click Save and Close.
8. Ensure that the Domino Directory for which the document was edited/saved is replicated to the appropriate Domino server which runs the Binary Tree DirSync process. Once the change has replicated, it will be processed the next time Dirsync is scheduled to run (that depends on the environment). It can be manually run as well, but it is better to just allow the process to take its course.
Please note, if the environment you are working in is quite large, it will likely require that a SQL query is created to find the specific entry instead of scanning through all the results as noted in step 4 above.
