Identity Manager Troubleshooting: Event ID 6309 - Connection is busy with results for another command

  • Article

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