FIM/MIM Troubleshooting : Event ID: 1000: Faulting application name: miiserver.exe, version: 4.0.2592.0, time stamp: 0x4b6790ea

Article
2024-01-17

OVERVIEW / PURPOSE / GOAL

The purpose of this wiki is to share knowledge of an issue that I recently worked concerning a stopped-server error message with a SQL Server Management Agent.

PROBLEM STATEMENT

The SQL Server Management Agent was running fine, and then in

APPLICATION EVENT LOG

Log Name:      Application

Source:        Application Error

Date:          7/24/2012 8:22:10 PM

Event ID:      1000

Task Category: Application Crashing Events

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      <COMPUTER NAME>

Description:

Faulting application name: miiserver.exe, version: 4.0.2592.0, time stamp: 0x4b6790ea

Faulting module name: MSVCR90.dll, version: 9.0.30729.4940, time stamp: 0x4ca2e32e

Exception code: 0xc0000005

Fault offset: 0x000000000001e654

Faulting process id: 0x%9

Faulting application start time: 0x%10

Faulting application path: %11

Faulting module path: %12

Report Id: %13

EXPORT OF RUN HISTORY

<run-history>

<run-details>

<ma-id>{GUID}</ma-id>

<ma-name>SQL Server Management Agent</ma-name>

<run-number>1997</run-number>

<run-profile-name>Full Import</run-profile-name>

<security-id>DOMAIN1\sqlmaacct</security-id>

<step-details step-number="1" step-id="{D2A88A69-A662-496D-976B-666A1792E960}">

   <start-date>2012-07-25 00:22:10.437</start-date>

   <end-date>2012-07-25 00:22:19.127</end-date>

   <step-result>stopped-server</step-result>

   <step-description>



   </step-description>

   <current-export-step-counter>0</current-export-step-counter>

   <last-successful-export-step-counter>0</last-successful-export-step-counter>

   <ma-connection>

   </ma-connection>

   <ma-discovery-errors>

   </ma-discovery-errors>

   <ma-discovery-counters>

   </ma-discovery-counters>

   <synchronization-errors/>

   <mv-retry-errors/>

   <staging-counters>

    <stage-no-change detail="false">0</stage-no-change>

    <stage-add detail="true">0</stage-add>

    <stage-update detail="true">0</stage-update>

    <stage-rename detail="true">0</stage-rename>

    <stage-delete detail="true">0</stage-delete>

    <stage-delete-add detail="true">0</stage-delete-add>

    <stage-failure detail="true">0</stage-failure>

   </staging-counters>

   <inbound-flow-counters>

    <disconnector-filtered detail="true">0</disconnector-filtered>

    <disconnector-joined-no-flow detail="true">0</disconnector-joined-no-flow>

    <disconnector-joined-flow detail="true">0</disconnector-joined-flow>

    <disconnector-joined-remove-mv detail="true">0</disconnector-joined-remove-mv>

    <disconnector-projected-no-flow detail="true">0</disconnector-projected-no-flow>

    <disconnector-projected-flow detail="true">0</disconnector-projected-flow>

    <disconnector-projected-remove-mv detail="true">0</disconnector-projected-remove-mv>

    <disconnector-remains detail="false">0</disconnector-remains>

    <connector-filtered-remove-mv detail="true">0</connector-filtered-remove-mv>

    <connector-filtered-leave-mv detail="true">0</connector-filtered-leave-mv>

    <connector-flow detail="true">0</connector-flow>

    <connector-flow-remove-mv detail="true">0</connector-flow-remove-mv>

    <connector-no-flow detail="true">0</connector-no-flow>

    <connector-delete-remove-mv detail="true">0</connector-delete-remove-mv>

    <connector-delete-leave-mv detail="true">0</connector-delete-leave-mv>

    <connector-delete-add-processed detail="true">0</connector-delete-add-processed>

    <flow-failure detail="true">0</flow-failure>

   </inbound-flow-counters>

   <export-counters>

    <export-add detail="true">0</export-add>

    <export-update detail="true">0</export-update>

    <export-rename detail="true">0</export-rename>

    <export-delete detail="true">0</export-delete>

    <export-delete-add detail="true">0</export-delete-add>

    <export-failure detail="true">0</export-failure>

   </export-counters>

</step-details>

</run-details>

</run-history>

CAUSE

In this particular case, the problem was data corruption in the SQL Server Management Agent Connector Space.

RESOLUTION

To resolve this issue, you will need to delete the SQL Server Management Agent Connector Space. You may be an advanced user of FIM, and maybe familiar with this scenario. However, it is recommended to review the following Microsoft TechNet Wiki before actually deleting the connector space.

Things to think about before deleting a connector space

OTHER POSSIBLE RESOLUTIONS

Run the Management Agent in a separate process
Run a Full Import (Stage Only) followed by a Full Synchronization on the Management Agent
Re-Index all tables in the backend SQL Server - FimSynchronizationService database

POSSIBLE TROUBLESHOOTING STEPS

If the failure is occurring on an import, then execute the import to a drop file. If that completes without error, then it is possible that the problem is within the Connector Space.
If the failure is happening during a synchronization, you might utilize a SQL Server Profiler Trace and/or a Network Monitor trace to ensure that the Synchronization Service Engine is connecting to the backend SQL Server.

ADDITIONAL INFORMATION

FIM Landing Page: Resource Wiki Contents

Share via