Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Problem statement
We experienced an issue to where a Synchronization Cycle was being run less than every 10 minutes. In this particular case, the Synchronization Cycle was being run every 2-3 minutes. The Application Event Log began to fill up with Event ID 6309 with text of "Connection is busy with results for another command".
Application Event log
MMS(4744) - Connection is busy with results for another command
Log Name: Application
Source: FIMSynchronizationService
Date: 8/22/2012 11:32:11 PM
Event ID: 6309
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Description:
The server encountered an unexpected error while performing an operation for a management agent.
ERR: MMS(4744): sql.cpp(5723): Query (select count(*) from [mms_server_configuration]) performed with error
ERR: MMS(4744): sql.cpp(5776): Connection is busy with results for another command
ERR: MMS(4744): sql.cpp(5784): hrError: 0x80004005, dwMinor: 0
BAIL: MMS(4744): sql.cpp(3022): 0x80004005 (Unspecified error)
BAIL: MMS(4744): sql.cpp(4257): 0x80004005 (Unspecified error)
BAIL: MMS(4744): instimp.cpp(150): 0x80004005 (Unspecified error)
BAIL: MMS(4744): session.cpp(1328): 0x80004005 (Unspecified error)
BAIL: MMS(4744): session.cpp(2344): 0x80004005 (Unspecified error)
BAIL: MMS(4744): mastate.cpp(8656): 0x80004005 (Unspecified error)
BAIL: MMS(4744): ma.cpp(3252): 0x80004005 (Unspecified error)
Forefront Identity Manager 4.0.3627.2
MMS(4116): sql.cpp(5776): Connection is busy with results for another command
Log Name: Application
Source: FIMSynchronizationService
Date: 8/22/2012 11:27:11 PM
Event ID: 6309
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Description:
The server encountered an unexpected error while performing an operation for a management agent.
ERR: MMS(4116): sql.cpp(5723): Query (select * from [mms_server_configuration] ) performed with error
ERR: MMS(4116): sql.cpp(5776): Connection is busy with results for another command
ERR: MMS(4116): sql.cpp(5784): hrError: 0x80004005, dwMinor: 0
BAIL: MMS(4116): sql.cpp(3022): 0x80004005 (Unspecified error)
BAIL: MMS(4116): sql.cpp(2794): 0x80004005 (Unspecified error)
BAIL: MMS(4116): instimp.cpp(168): 0x80004005 (Unspecified error)
BAIL: MMS(4116): session.cpp(1328): 0x80004005 (Unspecified error)
BAIL: MMS(4116): session.cpp(2344): 0x80004005 (Unspecified error)
BAIL: MMS(4116): mastate.cpp(8656): 0x80004005 (Unspecified error)
BAIL: MMS(4116): ma.cpp(3252): 0x80004005 (Unspecified error)
Cause
The reason for this is that the Synchronization Cycle running every 2-3 minutes utilizes system resources at the operating system level. Items such as Network Ports which stay active for 2 minutes.
Resolution
In this case, we moved the Synchronization schedule from every 2 - 3 minutes to a synchronization cycle of 10 minutes or greater. This will reduce, if not completely resolve the issue.
Applies to
Forefront Identity Manager 4.0.3627.2