[TROUBLESHOOTING] Event ID 6309 - Connection is busy with results for another command

PROBLEM DESCRIPTION
APPLICATION EVENT LOGS
CAUSE
RESOLUTION

PROBLEM DESCRIPTION

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 LOGS

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

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.

Forefront Identity Manager 4.0.3627.2