Overview:
When loading or reprocessing an Analytics File, the file disappears from the Analytics Admin page.
An admin receives an error: Data truncated for column 'field_vod__c'.
An end-user receives an error when opening Vinsights: "An embedded page at crm-08-app-us.veevacrm.com says: There was a problem establishing a connection to the database.
Root Cause:
This error is commonly caused by too many decimals in the analytics file than what is defined in the Decimal Places field of the Analytics File.
Solution:
Be sure no fields contain decimal values longer than what is listed on the Analytics File.
Related Documentation:
CRM Help Documentation: Processing Sales Data Files Using the Analytics Admin Page