So there was a delete operation sent to an AD MA. It was deleted successfully but on import (Full / Delta) MIM was still seeing the object with a staging error
Error: The dimage indicates an update or replace operation, but the image doesn’t exist.
Cause: Unknown – The Object Information was corrupted in connector space.
Resolution: Did some digging with Microsoft and came up with the solution
- Open SQL Server management studio and logon. Backup FIMSynchronizationService database.
- In a new query script, input the below command
|
1 2 3 4 |
USE [FIMSynchronizationService] GO SELECT * FROM dbo.mms_connectorspace WHERE RDN ='RDN value' |
- You can get the RDN from the object corrupted.
- After that, record the object_id from the query result, which we will use in the later statements.
- Run the below statements to turn it into a phantom
|
1 2 3 4 5 6 |
USE [FIMSynchronizationService] GO UPDATE [mms_connectorspace] SET [creation_date]=NULL,[is_provisioned]=NULL,[disconnection_id]=NULL,[disconnection_modification_date]=NULL,[last_import_modification_date]=NULL,[last_export_modification_date]=NULL,[count_import_modications]=NULL,[count_export_modications]=NULL,[is_connector]=0,[connector_state]=0,[pending]=0,[is_rename_retry]=0,[is_reference_retry]=0,[is_rebuild_in_progress]=0,[is_seen_by_import]=1,[is_phantom_parent]=0,[is_phantom_link]=1,[is_phantom_delete]=0,[is_full_sync]=0,[is_obsoletion]=0,[is_pending_reference_delete]=NULL,[import_operation]=NULL,[export_operation]=NULL,[is_import_error]=0,[count_import_error_retries]=0,[initial_import_error_date]=NULL,[last_import_error_date]=NULL,[import_error_code]=0,[is_export_error]=0,[count_export_error_retries]=0,[initial_export_error_date]=NULL,[last_export_error_date]=NULL,[export_error_code]=0,[current_export_batch_number]=NULL,[current_export_sequence_number]=NULL,[unapplied_export_batch_number]=NULL,[unapplied_export_sequencer_number]=NULL,[original_export_batch_number]=NULL,[original_export_sequencer_number]=NULL,[key_id]=NULL,[hologram]=NULL,[deltas]=NULL,[import_error_detail]=NULL,[export_error_detail]=NULL WHERE object_id='<object ID from the previous statement>' |
- Stop the FIM service.
- Delete the record via the below commands
|
1 2 3 4 5 |
DELETE FROM mms_cs_link WHERE object_id='<object ID from the previous statement>' DELETE FROM mms_csmv_link WHERE cs_object_id='<object ID from the previous statement>' DELETE FROM mms_connectorspace WHERE object_id='<object ID from the previous statement>' |
- Restarted the FIM Services
- Run the FIM Sync to see if the issue fixed.
0 Comments