Attempting to import a VM larger than 2 TB into vCloud Director 5.6.3 from vSphere gives a data truncation error message

By Marco Alcala

This morning, I attempted to import a virtual machine with a hard disk larger than 2 TB into vCloud Director from vSphere.  When I clicked the import from vSphere button, I got the following error message:

[ 5594fe5e-7ad3-429b-a42e-5544bad64d69 ] could not execute query
- Data truncation

Using SQL profiler against my vcloud database, I found that when the following query was executed, SQL server threw an 8115 arithmetic overflow error.