vSphere Initial Setup - Stuck at Data Collect Endpoint task

[MarcBouchard]

Fresh install of VRA 7.2 in a lab, with vSphere 6.5/vCenter 6.5. I am running the Request from vRA and all goes well until it reaches the "Data Collect Endpoint Resources" task in Orchestrator. Then it just sits there. I have no idea how to troubleshoot this (good enough that I was able to find the task in Orchestrator 🙂 )

Any insight would be very appreciated. I'm starting a new automation project so more questions to come later. 

Thanks!

Marc

[MarcBouchard]

Nobody has any hints on troubleshooting this? Not looking for a perfect answer, just pointers maybe?

Thanks,

Marc

[z001yv0r]

Check the logs--> Infrastructure--> Monitoring--> Log...

[MarcBouchard]

Thanks for that, didn't know where to look.

Found this error:

DataBaseStatsService: ignoring exception:

Error executing query usp_SelectAgent

Inner Exception: Error executing query usp_SelectAgentCapabilities

[z001yv0r · Accepted solution]

check this vmware kb article:  https://kb.vmware.com/kb/2089503

[MarcBouchard]

Indeed, after posting I search the error message and found the same article. MSDTC it was. Fixed and resolved. Thanks for taking the time to help!