Written by Simon Eady on 14/1/2015 · Read in about 2 min (262 words)
Published under vRealize Automation

Recently when do a fresh install of vRealize Automation (vRA) 6.2 I came across the following error after configuring the first end point.


Error log example





DataBaseStatsService: ignoring exception: Error executing query usp_SelectAgent Inner Exception: Error executing query usp_SelectAgentCapabilities

First of all I checked to see if the end points were working which in this case they appeared to be, but I wanted to clear the error before continuing the install.

It was clear from the error log at least one machine was affected by the error, IaaS.

After a little bit of effort searching I came across this extremely helpful article - “Using a Cloned VM as a SQL Server - Gotcha for vCAC Install

Essentially because I had deployed my VMs from the template or clone with MSDTC already installed the deployed VMs shared the same GUID for their MSDTC thus causing problems.

The fix as explained in the article is as follows (from an elevated command prompt) You will need to do this on your vRA IaaS and SQL server instances.

msdtc -uninstall

msdtc -install

Then reconfigure the security settings for MSDTC as outlined below.

  1. Click Start > Control Panel > Administrative Tools > Component Services.
  2. Expand the Component Services menu item on the left hand side until you can see “Local DTC”.
  3. Right click on Local DTC and select Properties.
  4. Select the Security tab.
  5. Click the selection boxes for Network DTC Access, Allow Remote Clients, Allow Remote Administration, Allow InBound, and Allow OutBound.
  6. Click OK.
  7. Restart the MSDTC services. (in some cases you may need to restart the VM)
Share this post