"ERROR ! User created statistics" error on migration assistant utility.

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• While trying to migrate vCenter Server on migration assistant utility you will see an error:
• Logs can be found on this location, %temp%\vcsMigration\migration-assistant.log

1 [42000](50000) [Microsoft][SQL Server Native Client 11.0][SQL Server]ERROR ! User created statistics:VPX_HIST_STAT1_79.STAT_VAL; VPX_HIST_STAT4_128.STAT_VAL; VPX_SN_OPAQUE_NET_BACKING.OPAQUE_NETWORK_ID; VPX_SN_OPAQUE_NET_BACKING.OPAQUE_NETWORK_TYPE; VPX_SN_OPAQUE_NET_BACKING.SN_ID; VPX_SN_OPAQUE_NET_BACKING.UPDATE_KEY; VPX_HIST_STAT3_26.STAT_VAL; VPX_HOST_DISABLEADMIN.ENTITY_TYPE; VPX_HOST_DISABLEADMIN.ENTITY_MOID; VPX_HOST_DISABLEADMIN.PRINCIPAL_NAME; VPX_HOST_DISABLEADMIN.GROUP_FLG; VPX_HOST_DISABLEADMIN.PROPAGATE_FLG; VPX_HOST_DISABLEADMIN.ROLE_ID_VAL; VPX_HIST_STAT1_214.STAT_VAL; VPX_DVS_RULE_QUALIFIER.SRC_IP_ADDRESS; VPX_DVS_RULE_QUALIFIER.SRC_IP_NOT_FLG; VPX_DVS_RULE_QUALIFIER.SRC_IP_PREFIX_LENGTH; VPX_DVS_RULE_QUALIFIER.SRC_IP_CONTAINER_ID; VPX_DVS_RULE_QUALIFIER.SRC_IP_TYPE; VPX_DVS_RULE_QUALIFIER.DST_IP_ADDRESS; VPX_DVS_RULE_QUALIFIER.DST_IP_NOT_FLG; VPX_DVS_RULE_QUALIFIER.DST_IP_PREFIX_LENGTH; VPX_DVS_RULE_QUALIFIER.DST_IP_CONTAINER_ID; VPX_DVS_RULE_QUALIFIER.DST_IP_TYPE; 

 

Environment

VMware vCenter Server 6.5.x
VMware vCenter Server 6.0.x

Resolution

1. Take a valid backup of the MS SQL Database.
2. Take a snapshot for both vCenter Server and SQL Server (if  SQL Server is external).
3. Stop the vpxd service on the Windows vCenter.
   • Open command prompt as administrator
   • Navigate to below location
     • cd C:\Program Files\VMware\vCenter Server\bin
   • Run the below command to stop vpxd
     • service-control --stop vpxd
4. Open SQL Management Studio and access the vCenter Server Database.
5. Drop the User Defined Statistics by running the following query:
   • ​DROP STATISTICS <statistic name>;
     
     For Example:
     DROP STATISTICS VPX_HIST_STAT1_79.STAT_VAL;
6. Repeat the above step and make sure you drop all the User Defined Statistics mentioned in the logs.
7. Once all the statistics are dropped, re-start the vpxd service using below command,
   • service-control --start vpxd

8. Re-r​​un the migration assistant and complete the migration process.