Control Center synchronization failing, Error: Enlist operation failed: 0x8004d01c(XACT_E_CONNECTION_DOWN)

  • 7006004
  • 01-May-2012
  • 21-May-2012

Environment

NetIQ AppManager Control Center 7.0.x
NetIQ AppManager Control Center 8.0.x

Situation

The Control Center Cache Manager is showing in an error state. Objects within Control Cetner are not being updated, or cannot be manipulated.
The Distributed Transaction Cordinator services are running on both the QDB and CCDB. They are properly configured and configuration has not recently changed.
Error:
9/23/2011 11:12:25.232:  [EXCEPTION] [Assembly=NQSyncQDB; Method=NetIQ.Utils.TraceEx.WriteSQLException ThreadID=70]
 Message=Enlist operation failed: 0x8004d01c(XACT_E_CONNECTION_DOWN). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.
A severe error occurred on the current command.

Resolution

Please restart the SQL Server service, Distributed Transaction Cordinator, and the NetIQ Control Center Command Queue service. This should allow the SQL Server service to properly interact with DTC. The error should no longer display when a healthcheck cycle for Control Center completes. If the condition persists for more than 30 minutes after the services have been restarted, please contact NetIQ Technical Support.

Cause

The error is due to a synchronization issue between the Microsoft SQL Server service and DTC.