Resolve Endpoint Syslog error report in configuration IaaS: ignoring exception:Error executin gquery usp

After configuring Endpoint for vRA Infrastructure, the system prompts for the failure shown in the following figure:

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

This failure is caused by a problem with the MSDTC service, so click Administrative Tools > Component Services > Component Services > Computers > My Computer > Distributed Transaction

Coordinator, right-click Local DTC and select Properties, as shown below:

Click the Security tab, check the options in the red box, click Ok and restart the service.

If this doesn't work, you need to reinstall the MSDTC service and execute the command:

1. Msdtc-uninstall

2. Msdtc-install

Then follow the previous steps to configure it again.

There is no royal road to learning。

Calm down and forge ahead.

Opportunities are always left to those who are prepared.