WMI Query Failure for MSDTC Performance Counters (4228688)

Foglight agents may report the following error when collecting data from the DBSS_DTC_Information collection:

ERROR com.quest.qsi.fason.core.collection.processor.InstanceProcessor - 
Failed to run DBSSNumberOfDTCProcessor processor of DBSS_DTC_Information collection.
java.lang.RuntimeException: Failed to execute collection [DBSS_DTC_Information], 
reason=com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkQueryException: 
The query 'select AbortedTransactions,ActiveTransactions,CommittedTransactionsPersec,
InDoubtTransactions,ResponseTimeAverage,TransactionsPersec from 
Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator' has failed (0x80041010)
    

Additionally, the following message may appear in logs:

The WMI Class [Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator] is not 
available in this host. 
You may need to refresh the Performance Counter Classes by executing the following 
command in the command prompt: "%windir%\system32\wbem\wmiadap.exe /f."

The error code 0x80041010 indicates that the WMI class Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator is not registered or available on the target system. This typically occurs when:

• The MSDTC service is not installed or running.
• Performance counters for MSDTC are missing or corrupted.
• The WMI repository is damaged or incomplete.

Follow these steps on the affected host (e.g., HOSTNAME):

1. Ensure the Distributed Transaction Coordinator service is running:
   • Open services.msc
   • Locate and start the Distributed Transaction Coordinator service
2. Refresh WMI performance counters:

   %windir%\system32\wbem\wmiadap.exe /f

3. Rebuild all performance counters:

   lodctr /R

4. Restart the MSDTC service:

   net stop msdtc
   net start msdtc
               

5. Verify MSDTC counters are available:

   Get-Counter -ListSet MSDTC

6. Check if the WMI class is now available:

   Get-CimInstance -ClassName Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator

7. If counters are still missing, reinstall MSDTC:

   msdtc -uninstall
   msdtc -install
   lodctr /R
   %windir%\system32\wbem\wmiadap.exe /f
   net start msdtc

After performing these steps, check the Foglight agent logs to confirm that the error no longer appears.

Ensure the Foglight agent has sufficient permissions to query WMI remotely. DCOM and WMI namespace security may need to be configured appropriately.