VMware Cloud Community
rfunk
Enthusiast
Enthusiast

Warning! The maximum key length is 900 bytes

I'm in the process of installing Virtual Center 5.0.  When running the VCDB_mssql.sql script i'm getting the following error.

Warning! The maximum key length is 900 bytes. The index 'PK_VPX_ALARM_RUNTIME' has maximum length of 1032 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPXI_VM_FILE_NAME' has maximum length of 4000 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPX_DVPORT_M3' has maximum length of 1630 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'PK_VPX_EXT_MANAGEDBY_INFO' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPX_HOST_DISABLEADMIN_U1' has maximum length of 1126 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPX_VDEVICE_FILE_BACKING_U1' has maximum length of 904 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPX_HOSTMULTIPATH_POLICY_M1' has maximum length of 1028 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'PK_HOSTMULTIPATHINFO_PATH' has maximum length of 1028 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPX_HOSTMULTIPATHINFO_PATH_M1' has maximum length of 1028 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPXI_PSA_PATH' has maximum length of 1028 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'PK_VPX_DATASTORE_INFO' has maximum length of 1028 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'VPX_VM_FLE_FILE_INFO_M3' has maximum length of 944 bytes. For some combination of large values, the insert/update operation will fail.

Does anyone know how to correct this error?

Thanks

Reply
0 Kudos
0 Replies