MIM 2016 Troubleshooting: SQL Connection issues

 

↑ Back to top

Background

This article provides a list of specific events related to an unstable or even disconnected SQL connection.

As there are very distinct and clear error messages related to these events, the content of these events is very useful to track and trace these errors.

You might find these errors documented elsewhere or directly related to the SQL environment or to SQL application environment, but you'll rarely find documentation of these errors in a MIM or FIM setup.  

 

↑ Back to top

Symptoms

MIM Sync Engine

• You cannot (re-)connect to the Synchronization engine GUI
• When you have the Sync Engine GUI open, any action or operations fails
• You cannot run any operations on the management agent
• The MIM Service management agent operations fail with errors (see below).

 

MIM Service / Portal Server

• "Forefront Identity Manager Service" fails to start, while the SQL connection to the server works 
• You cannot open the MIM portal
• Any operation / navigation in the MIM portal fails or stalls... 

 

↑ Back to top

Error Messages

MIM Sync Engine Event Viewer - Application log

Event ID 6301: Cannot continue the execution because the session is in the kill state.

Log Name:      Application
Source:        FIMSynchronizationService
Date:          dd/mm/yyyy hh:mm:00
Event ID:      6301
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MIMSYNC.URL
Description:
The server encountered an unexpected error in the synchronization engine:
  
"ERR_: MMS(11300): ..\sql.cpp(5804): Query (Commit()) performed with error
ERR_: MMS(11300): ..\sql.cpp(5804): Cannot continue the execution because the session is in the kill state.
ERR_: MMS(11300): ..\sql.cpp(5804): hrError: 0x8000ffff, dwMinor: 596
ERR_: MMS(11300): ..\sql.cpp(5804): SQL error: HY000, native: 596
ERR_: MMS(11300): ..\sql.cpp(5804): Warning: Fatal error 9001 occurred at Apr  5 2018  8:01AM. Note the error and time, and contact your system administrator.
ERR_: MMS(11300): ..\sql.cpp(5804): hrError: 0x8000ffff, dwMinor: 21
ERR_: MMS(11300): ..\sql.cpp(5804): SQL error: HY000, native: 21
BAIL: MMS(11300): ..\sql.cpp(5807): 0x80230406 (An error has occurred at the store)
BAIL: MMS(11300): ..\session.cpp(1593): 0x80230406 (An error has occurred at the store)
ERR_: MMS(11300): ..\syncmonitor.cpp(2453): Failed to commit SQL transaction 0x80230406
ERR_: MMS(11300): ..\syncmonitor.cpp(2528): SE: Rollback SQL transaction for: 0x80230406
Forefront Identity Manager 4.4.1749.0"
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="FIMSynchronizationService" />
    <EventID Qualifiers="49152">6301</EventID>
    <Level>2</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT06:01:04.000000000Z" />
    <EventRecordID>575418</EventRecordID>
    <Channel>Application</Channel>
    <Computer>MIMSYNC.URL</Computer>
    <Security />
  </System>
  <EventData>
    <Data>ERR_: MMS(11300): ..\sql.cpp(5804): Query (Commit()) performed with error
ERR_: MMS(11300): ..\sql.cpp(5804): Cannot continue the execution because the session is in the kill state.
ERR_: MMS(11300): ..\sql.cpp(5804): hrError: 0x8000ffff, dwMinor: 596
ERR_: MMS(11300): ..\sql.cpp(5804): SQL error: HY000, native: 596
ERR_: MMS(11300): ..\sql.cpp(5804): Warning: Fatal error 9001 occurred at Apr  5 2018  8:01AM. Note the error and time, and contact your system administrator.
ERR_: MMS(11300): ..\sql.cpp(5804): hrError: 0x8000ffff, dwMinor: 21
ERR_: MMS(11300): ..\sql.cpp(5804): SQL error: HY000, native: 21
BAIL: MMS(11300): ..\sql.cpp(5807): 0x80230406 (An error has occurred at the store)
BAIL: MMS(11300): ..\session.cpp(1593): 0x80230406 (An error has occurred at the store)
ERR_: MMS(11300): ..\syncmonitor.cpp(2453): Failed to commit SQL transaction 0x80230406
ERR_: MMS(11300): ..\syncmonitor.cpp(2528): SE: Rollback SQL transaction for: 0x80230406
Forefront Identity Manager 4.4.1749.0</Data>
  </EventData>
</Event>

 

↑ Back to top

Event 6401:Unusual error code reported 0x80004005

Log Name:      Application
Source:        FIMSynchronizationService
Date:          dd/mm/yyyy 00:00:00
Event ID:      6401
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MIMSYNC.URL
Description:
The management agent controller encountered an unexpected error.
  
 "ERR_: MMS(8076): ..\libutils.cpp(10613): Unusual error code reported 0x80004005
Forefront Identity Manager 4.4.1749.0"
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="FIMSynchronizationService" />
    <EventID Qualifiers="49152">6401</EventID>
    <Level>2</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT07:00:02.000000000Z" />
    <EventRecordID>575469</EventRecordID>
    <Channel>Application</Channel>
    <Computer>MIMSYNC.URL</Computer>
    <Security />
  </System>
  <EventData>
    <Data>ERR_: MMS(8076): ..\libutils.cpp(10613): Unusual error code reported 0x80004005
Forefront Identity Manager 4.4.1749.0</Data>
  </EventData>
</Event>

 

↑ Back to top

Event 6322: The server encountered an error because the connection to SQL Server failed.

Log Name:      Application
Source:        FIMSynchronizationService
Date:          dd/mm/yyyy 09:00:02
Event ID:      6322
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MIMSYNC.url
Description:
The server encountered an error because the connection to SQL Server failed.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="FIMSynchronizationService" />
    <EventID Qualifiers="49152">6322</EventID>
    <Level>2</Level>
    <Task>6</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT07:00:02.000000000Z" />
    <EventRecordID>575474</EventRecordID>
    <Channel>Application</Channel>
    <Computer>MIMSYNC.URL</Computer>
    <Security />
  </System>
  <EventData>
  </EventData>
</Event>

 

↑ Back to top

Event ID 6306: Temp db not available

Log Name:      Application
Source:        FIMSynchronizationService
Date:          dd/mm/yyyy hh:mm:00
Event ID:      6306
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MIMSYNC.url
Description:
The server encountered an unexpected error while performing an operation for the client.
  
 "ERR_: MMS(3420): ..\sql.cpp(3285): Query (delete from mms_step_object_details where step_history_id in  (    select step_history_id   from mms_step_history   where run_history_id = '{E4C19745-1372-4944-A2A1-5BF35207C37F}')) performed with error
ERR_: MMS(3420): ..\sql.cpp(3285): The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
ERR_: MMS(3420): ..\sql.cpp(3285): hrError: 0x80004005, dwMinor: 9001
ERR_: MMS(3420): ..\sql.cpp(3285): SQL error: HY000, native: 9001
BAIL: MMS(3420): ..\sql.cpp(3288): 0x80004005 (Unspecified error)
BAIL: MMS(3420): ..\sql.cpp(3180): 0x80004005 (Unspecified error)
BAIL: MMS(3420): ..\exechist.cpp(1268): 0x80230406 (An error has occurred at the store)
BAIL: MMS(3420): ..\server.cpp(5959): 0x80230406 (An error has occurred at the store)
Forefront Identity Manager 4.4.1749.0"
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="FIMSynchronizationService" />
    <EventID Qualifiers="49152">6306</EventID>
    <Level>2</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddThh:mm:00.000000000Z" />
    <EventRecordID>575574</EventRecordID>
    <Channel>Application</Channel>
    <Computer>MIMSYNC.url</Computer>
    <Security />
  </System>
  <EventData>
    <Data>ERR_: MMS(3420): ..\sql.cpp(3285): Query (delete from mms_step_object_details where step_history_id in  (    select step_history_id   from mms_step_history   where run_history_id = '{E4C19745-1372-4944-A2A1-5BF35207C37F}')) performed with error
ERR_: MMS(3420): ..\sql.cpp(3285): The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
ERR_: MMS(3420): ..\sql.cpp(3285): hrError: 0x80004005, dwMinor: 9001
ERR_: MMS(3420): ..\sql.cpp(3285): SQL error: HY000, native: 9001
BAIL: MMS(3420): ..\sql.cpp(3288): 0x80004005 (Unspecified error)
BAIL: MMS(3420): ..\sql.cpp(3180): 0x80004005 (Unspecified error)
BAIL: MMS(3420): ..\exechist.cpp(1268): 0x80230406 (An error has occurred at the store)
BAIL: MMS(3420): ..\server.cpp(5959): 0x80230406 (An error has occurred at the store)
Forefront Identity Manager 4.4.1749.0</Data>
  </EventData>
</Event>

 

↑ Back to top

Event ID 6311: Bail error

Log Name:      Application
Source:        FIMSynchronizationService
Date:          dd/mm/yyyy hh:mm:00
Event ID:      6311
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      mimsync.environment.customer.root
Description:
The server encountered an unexpected error while performing a callback operation.
  
 "BAIL: MMS(6552): ..\sql.cpp(2620): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\sql.cpp(2391): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\session.cpp(505): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\session.cpp(358): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\syncimport.cpp(885): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\syncimport.cpp(102): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\ma.cpp(4610): 0x80004005 (Unspecified error)
Forefront Identity Manager 4.4.1749.0"
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="FIMSynchronizationService" />
    <EventID Qualifiers="49152">6311</EventID>
    <Level>2</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddThh:mm:02.000000000Z" />
    <EventRecordID>575575</EventRecordID>
    <Channel>Application</Channel>
    <Computer>mimsync.environment.customer.root</Computer>
    <Security />
  </System>
  <EventData>
    <Data>BAIL: MMS(6552): ..\sql.cpp(2620): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\sql.cpp(2391): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\session.cpp(505): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\session.cpp(358): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\syncimport.cpp(885): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\syncimport.cpp(102): 0x80004005 (Unspecified error)
BAIL: MMS(6552): ..\ma.cpp(4610): 0x80004005 (Unspecified error)
Forefront Identity Manager 4.4.1749.0</Data>
  </EventData>
</Event>

 

↑ Back to top

Event ID 2004 - 0x80230621

Log Name:      Application
Source:        FIMSynchronizationService
Date:          dd/mm/yyyy hh:mm:00
Event ID:      2004
Task Category: Server
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      MIMSYNC.environtment.customer.root
Description:
The FIM Synchronization Service failed to update the timestamp. Verify that SQL Server is running.
 Error Code: 0x80230621
 Error Message: (A connection to SQL Server could not be established)
 
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="FIMSynchronizationService" />
    <EventID Qualifiers="16384">2004</EventID>
    <Level>3</Level>
    <Task>6</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT08:21:47.000000000Z" />
    <EventRecordID>575604</EventRecordID>
    <Channel>Application</Channel>
    <Computer>MIMSYNC.environtment.customer.root</Computer>
    <Security />
  </System>
  <EventData>
    <Data>FIM Synchronization Service</Data>
    <Data>0x80230621</Data>
    <Data>(A connection to SQL Server could not be established)</Data>
  </EventData>
</Event>

 

↑ Back to top

Event ID 2004 - 0x80230406

Log Name:      Application
Source:        FIMSynchronizationService
Date:          dd/mm/yyyy hh:mm:00
Event ID:      2004
Task Category: Server
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      MIMSYNC.environment.customer.root
Description:
The FIM Synchronization Service failed to update the timestamp. Verify that SQL Server is running.
 Error Code: 0x80230406
 Error Message: (An error has occurred at the store)
 
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="FIMSynchronizationService" />
    <EventID Qualifiers="16384">2004</EventID>
    <Level>3</Level>
    <Task>6</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT08:24:28.000000000Z" />
    <EventRecordID>575605</EventRecordID>
    <Channel>Application</Channel>
    <Computer>MIMSYNC.environment.customer.root</Computer>
    <Security />
  </System>
  <EventData>
    <Data>FIM Synchronization Service</Data>
    <Data>0x80230406</Data>
    <Data>(An error has occurred at the store)</Data>
  </EventData>
</Event>

 

↑ Back to top

MIM Service / Portal Server

MIM Service not starting

SQL CLient error 2754

Log Name:      Forefront Identity Manager
Source:        Microsoft.ResourceManagement
Date:          dd/mm/yyyy 00:00:00
Event ID:      3
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MIMPORTAL.environment.client.root
Description:
.Net SqlClient Data Provider: 2754 : ReRaiseException : System.Data.SqlClient.SqlException: Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.
   at Microsoft.ResourceManagement.Utilities.ExceptionManager.ThrowException(Exception exception)
   at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.ThrowException(SqlException innerException, TransactionAndConnectionScope scope)
   at Microsoft.ResourceManagement.Data.DataAccess.UpdateRequestStatusForCompletedActionWorkflows(Int16 serviceId, Int16 maxRequestsToProcess, Int64& lastRequestKeyProcessed)
   at Microsoft.ResourceManagement.Workflow.PostProcessingManager.Execute()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft.ResourceManagement" />
    <EventID Qualifiers="0">3</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT06:06:22.000000000Z" />
    <EventRecordID>21795</EventRecordID>
    <Channel>Forefront Identity Manager</Channel>
    <Computer>MIMPORTAL.environment.client.root</Computer>
    <Security />
  </System>
  <EventData>
    <Data>.Net SqlClient Data Provider: 2754 : ReRaiseException : System.Data.SqlClient.SqlException: Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.
   at Microsoft.ResourceManagement.Utilities.ExceptionManager.ThrowException(Exception exception)
   at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.ThrowException(SqlException innerException, TransactionAndConnectionScope scope)
   at Microsoft.ResourceManagement.Data.DataAccess.UpdateRequestStatusForCompletedActionWorkflows(Int16 serviceId, Int16 maxRequestsToProcess, Int64& lastRequestKeyProcessed)
   at Microsoft.ResourceManagement.Workflow.PostProcessingManager.Execute()</Data>
  </EventData>
</Event>

 

↑ Back to top

SQL Client error

Log Name:      Forefront Identity Manager
Source:        Microsoft.ResourceManagement
Date:          dd/mm/yyyy 00:00:00
Event ID:      3
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MIMPORTAL.invironment.customer.root
Description:
.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ResourceManagement.Data.DataAccess.RegisterService(String serviceName, String servicePartitionName, Boolean processSystemPartition, Nullable`1& serviceId, Nullable`1& servicePartitionId)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft.ResourceManagement" />
    <EventID Qualifiers="0">3</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT00:00:00.000000000Z" />
    <EventRecordID>21841</EventRecordID>
    <Channel>Forefront Identity Manager</Channel>
    <Computer>MIMPORTAL.environment.client.root</Computer>
    <Security />
  </System>
  <EventData>
    <Data>.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ResourceManagement.Data.DataAccess.RegisterService(String serviceName, String servicePartitionName, Boolean processSystemPartition, Nullable`1& serviceId, Nullable`1& servicePartitionId)</Data>
  </EventData>
</Event>

 

↑ Back to top

Resource management error 1

Log Name:      Forefront Identity Manager
Source:        Microsoft.ResourceManagement
Date:          dd/mm/yyyy 00:00:00
Event ID:      3
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      MIMPORTAL.environment.customer.root
Description:
Requestor: urn:uuid:89dad16a-cdba-4187-9588-0f78d42c3d4d
Correlation Identifier: 95b55d75-325f-4ea6-8345-813720868bf9
Microsoft.ResourceManagement.WebServices.Exceptions.UnwillingToPerformException: Other ---> System.Data.SqlClient.SqlException: Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.CreateRequest(UniqueIdentifier requestor, UniqueIdentifier targetIdentifier, OperationType operation, String businessJustification, List`1 requestParameters, CultureInfo locale, Boolean isChildRequest, Guid cause, Boolean doEvaluation, Nullable`1 serviceId, Nullable`1 servicePartitionId, UniqueId messageIdentifier, UniqueIdentifier requestContextIdentifier, Boolean maintenanceMode)
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.CreateRequest(UniqueIdentifier requestor, UniqueIdentifier targetIdentifier, OperationType operation, String businessJustification, List`1 requestParameters, CultureInfo locale, Boolean isChildRequest, Guid cause)
   at Microsoft.ResourceManagement.WebServices.ResourceManagementService.Get(Message request)
   --- End of inner exception stack trace ---
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft.ResourceManagement" />
    <EventID Qualifiers="0">3</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="yyyy-mm-ddT00:00:00.000000000Z" />
    <EventRecordID>21805</EventRecordID>
    <Channel>Forefront Identity Manager</Channel>
    <Computer>MIMPORTAL.environment.client.root</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Requestor: urn:uuid:89dad16a-cdba-4187-9588-0f78d42c3d4d
Correlation Identifier: 95b55d75-325f-4ea6-8345-813720868bf9
Microsoft.ResourceManagement.WebServices.Exceptions.UnwillingToPerformException: Other ---> System.Data.SqlClient.SqlException: Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option.
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.CreateRequest(UniqueIdentifier requestor, UniqueIdentifier targetIdentifier, OperationType operation, String businessJustification, List`1 requestParameters, CultureInfo locale, Boolean isChildRequest, Guid cause, Boolean doEvaluation, Nullable`1 serviceId, Nullable`1 servicePartitionId, UniqueId messageIdentifier, UniqueIdentifier requestContextIdentifier, Boolean maintenanceMode)
   at Microsoft.ResourceManagement.WebServices.RequestDispatcher.CreateRequest(UniqueIdentifier requestor, UniqueIdentifier targetIdentifier, OperationType operation, String businessJustification, List`1 requestParameters, CultureInfo locale, Boolean isChildRequest, Guid cause)
   at Microsoft.ResourceManagement.WebServices.ResourceManagementService.Get(Message request)
   --- End of inner exception stack trace ---</Data>
  </EventData>
</Event>

 

↑ Back to top

Resource management error 2

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="Microsoft.ResourceManagement" /> 
  <EventID Qualifiers="0">3</EventID> 
  <Level>2</Level> 
  <Task>0</Task> 
  <Keywords>0x80000000000000</Keywords> 
  <TimeCreated SystemTime="yyyy-mm-ddT00:00:00.000000000Z" /> 
  <EventRecordID>21842</EventRecordID> 
  <Channel>Forefront Identity Manager</Channel> 
  <Computer>MIMPORTAL.environment.customer.root</Computer> 
  <Security /> 
  </System>
- <EventData>
  <Data>.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option. at Microsoft.ResourceManagement.Utilities.ExceptionManager.ThrowException(Exception exception) at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.ThrowException(SqlException innerException, TransactionAndConnectionScope scope) at Microsoft.ResourceManagement.Data.DataAccess.RegisterService(String serviceName, String servicePartitionName, Boolean processSystemPartition, Nullable`1& serviceId, Nullable`1& servicePartitionId) at Microsoft.ResourceManagement.Service.PlatformBasics.RegisterService(Boolean isService) at Microsoft.ResourceManagement.Service.PlatformBasics.Initialize(Boolean isService) at Microsoft.ResourceManagement.Service.Application.CreatePlatformBasics(Boolean initialize, Boolean isService) at Microsoft.ResourceManagement.Service.Application.Start()</Data> 
  </EventData>
  </Event>

 

↑ Back to top

Portal not able to connect to FIM Service

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="Microsoft.ResourceManagement.PortalHealthSource" /> 
  <EventID Qualifiers="0">10</EventID> 
  <Level>2</Level> 
  <Task>0</Task> 
  <Keywords>0x80000000000000</Keywords> 
  <TimeCreated SystemTime="yyyy-mm-ddT00:00:00.000000000Z" /> 
  <EventRecordID>2279965</EventRecordID> 
  <Channel>Application</Channel> 
  <Computer>PORTALSERVER.environment.customer.root</Computer> 
  <Security /> 
  </System>
- <EventData>
  <Data>The Portal cannot connect to the middle tier using the web service interface. This failure prevents all portal scenarios from functioning correctly. The cause may be due to a missing or invalid server url, a downed server, or an invalid server firewall configuration. Ensure the portal configuration is present and points to the resource management service.</Data> 
  </EventData>
  </Event>

 

 

↑ Back to top

Root cause

• the SQL Server suffers from performance issues
• the SQL Server is not tuned for performance and other applications (or MIM itself) take too many resources,
• the SQL server has insufficient resources
• MIM cannot connect to one of the MIM databases
• one of the MIM databases is offline on the SQL Server
• ...

↑ Back to top

Solution

1. Check the SQL Server Connection (https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server)
2. Check if the MIM Databases are available
3. Check SQL Server Performance issues

 

↑ Back to top

See also

• FIM Troubleshooting: Synchronization Service setup is having trouble contacting SQL server

 

↑ Back to top

References

• https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server
• SQL Server availability solutions for Microsoft Identity Manager services databases

 

↑ Back to top