Check Infrastructure -> Monitoring -> Logs and see if errors are being thrown. You must ensure the name of your vCenter endpoint matches the name you provided when adding it to vRA.
By going through the logs found error logs as below.
attached screenshot.
Error log.
------
at DynamicOps.VMPS.DataAccess.ConnectionFactory`1.ExecuteReader(RecordReader`1 recordReader, String storedProcedure, String whereClause, Boolean firstRecordOnly, SqlParameter[] collection)
at DynamicOps.VMPS.DataAccess.DataAccessLayer.<>c__DisplayClass1.<EnumerateAgentsWithRetry>b__0()
at DynamicOps.Common.Exceptions.RetryTransactionException.RetryIfNecessary(Action action)
at DynamicOps.VMPS.Service.PhysicalHostPingService.PhysicalHostPingCallback(Object state)
Inner Exception: at DynamicOps.VMPS.DataAccess.ConnectionFactory`1.ExecuteReader(RecordReader`1 recordReader, String storedProcedure, String whereClause, Boolean firstRecordOnly, SqlParameter[] collection)
at DynamicOps.VMPS.DataAccess.AgentManager.GetAgentCapabilities(Guid agentID)
at DynamicOps.VMPS.DataAccess.AgentManager.ReadInstance(IDataRecord record, Agent& agent)
at DynamicOps.VMPS.DataAccess.RecordReader`1.ReadRecord(IDataRecord record, List`1 instances)
at DynamicOps.VMPS.DataAccess.ConnectionFactory`1.ExecuteReaderNoRetry(RecordReader`1 recordReader, String storedProcedure, String whereClause, SqlParameter[] collection, Boolean firstRecordOnly)
at DynamicOps.VMPS.DataAccess.ConnectionFactory`1.ExecuteReader(RecordReader`1 recordReader, String storedProcedure, String whereClause, Boolean firstRecordOnly, SqlParameter[] collection)
----------------------
You have MSDTC issues. Search this forum for possible solutions as this is covered almost weekly.
Hi,
MSDTC is configured but still I am getting below error.
Error message: Timeout reached waiting for data collection statuses to be created (Workflow:vSphere Initial Setup / Data Collect Endpoint resources (item33)#172)
did you also check if firewall allows DTC port?
Even after enabling DTC port on firewall, getting same error.
No compute resources found for endpoint [vCenter] (Workflow:vSphere Initial Setup / Wait to discover compute resorces (item3)#25)
You need to give us more to go on than this. What does your architecture look like? Can you post screenshots of the DTC configuration on SQL and Manager boxes? What versions are involved across the board? Are things domain joined? Is everything in the same DNS zone? Help us help you by providing enough details to know what to check next.
1. Attached environment design.
2. Single domain Zone.
3. TDC screen shot attached
4. I can bale to rename the cluster name using Orchestrator and I can able to perform many take using VRO.
5. I have disabled the Firewall on SQL and IaaS for testing purpose( currently its in disable state )
Ok, a couple things.
Ans: DTC setting changed to Mutual Authentication.
Ans: built-in vRealize Orchestrator Server, using vRealize Orchestrator Client I can perform built in Workflow tasks without any error ( example -- Rename VM, add CPU memory to VM ext.. )
Ans: VMware vRealize Automation Appliance version 7.3.0.1650 (build 5604410 and IAAS -- My SQL 2012.
Ans: Command successful.
Ans: Service is started and automatic.
MySQL is not supported, only Microsoft SQL server is. That's probably the issue.