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
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.