Search the VMware Knowledge Base (KB)
View by Article ID

Provisioning a machine using VMware vRealize Automation fails with the error: Error executing query usp_SelectHostReservation (2038943)

  • 3 Ratings

Symptoms

  • Cannot provision a machine using VMware vRealize Automation (formerly known as VMware vCloud Automation Center)
  • Provisioning a machine using VMware vRealize Automation fails
  • You see the error:

    Error executing query usp_SelectHostReservation

  • In the Event Viewer on the portal, you see an error similar to:

    INNER EXCEPTION: System.ApplicationException: INNER EXCEPTION: System.ApplicationException: Error executing query usp_SelectGroup
    System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed.
    System.Runtime.InteropServices.COMException: 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)
    System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed.
    System.Runtime.InteropServices.COMException: 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)

Cause

This issue occurs if MSDTC is disabled on the Model Manager portal and/or the SQL server.

Resolution

To resolve this issue, enable MSDTC on all VMware vRealize Automation (formerly known as vCloud Automation Center) and associated SQL servers.
 
To enable MSDTC on all VMware vRealize Automation and associated SQL servers:
  1. Go to Start > Administrative Tools.
  2. Open Component Services.
  3. Expand Component Service > ComputersMy Computer > Distributed Transaction Coordinator.
  4. Right-click Local DTC and click Properties.
  5. Click the Security tab.
  6. Select the Network DTC Access option.
  7. Select Allow Remote Client and Allow Remote Administration options. 
  8. Select the Allow Inbound and Allow Outbound options.
  9. Specify NetworkService for DTC Log in Account.
  10. Click OK.

Impact/Risks

Caution: Ensure that all Windows servers have unique SIDs for MSDTC configuration.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 3 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 3 Ratings
Actions
KB: