vCenter upgrade / migration fails with error "error in populating profiles"

[sbkurid]

Hi,

Setup details :

Current setup :

vCenter 5.5 U3 Embedded SSO

Database - Microsoft SQL 2008 R2 (External DB)

Issue :

Tried Migrating vCenter 5.5 U3 Embedded SSO to VCSA 6.0 U3 Appliance using migration utility and got an error "Error in populating profiles" in Step-5 "Select Appliance Size"

Also referred the below articles which didnt help much.

"Error in populating profiles" @ vcs 5.5 U2 (Windows) to VCSA 6.0 U2M migration

VMware Knowledge Base

Please let me know if any one came across such issues.

[Vijay2027]

Execute this query on SQL DB and share the output:

SELECT * FROM VPX_TEXT_ARRAY

WHERE NOT EXISTS(SELECT 1 FROM VPX_ENTITY WHERE ID=VPX_TEXT_ARRAY.MO_ID)

Do you use VMware View in your environment?

[arsovmar]

This does not resolve the issue. Any other suggestions?

[sbkurid]

No VMware View in the Environment.

Tried the below but no luck.

1. Update manager was running on the same vCenter Server, so as per the recommendation we have removed the VUM and tried but the issue is same.

2. ESXi 4.x version is running on the same vCenter, so suspecting this is the culprit and awaiting the customer to update as we proposed to remove the unsupported ESXi version from the vCenter.

[Vijay2027]

You might find logs in %temp% which will give more information regarding this.