10 Replies Latest reply on Jul 23, 2017 7:08 PM by mvr007

    vRA 7: Error executing query usp_SelectAgentCapabilities

    wllp Novice

      Hi,

       

      I am having the following errors in the vRA 7

       

      • CollectedDataImportService: Ignoring exception: Error executing query usp_SelectManagementEndpoint Inner Exception: Error executing query usp_SelectEntityProperties
      • DataBaseStatsService: ignoring exception: Error executing query usp_SelectAgent Inner Exception: Error executing query usp_SelectAgentCapabilities

      I have followed the solutions that are found online

      1. Make sure that DTC is running - On both IaaS and IaaS SQL servers
      2. Uninstall and re-install DTC - On both IaaS and IaaS SQL servers
      3. Restart the VMs (IaaS and IaaS SQL)

       

      However, I am still getting the same error. In the IaaS Server logs, this error was captured:

      The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers. (Exception from HRESULT: 0x8004D02B)

       

      I have downloaded the DTCPing and both the servers are able to communicate with each other. Firewall has been turned off on both servers.

       

      These servers are not joined to domain and all access are configured on the DNS server.

       

      Appreciate any help on this issue. Thanks!