Generally, the error "**There was an error during a batch insertion: Data truncation**" could have occurred when you are trying to insert data has larger value than the column can allow in the cache table. I was able to resolve this error by following below steps:
* Click on '**Edit**' tab of the view which was cached.
* Click on the pencil icon of the field under the **FIELD TYPE** which has large data.
* Configure "**Type size**" with a value higher than the existing value.
* Click on "OK" to save the changes.
For more information on modifying properties of the base view please refer the section [Viewing the Schema of a Base View](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/viewing_the_schema_of_a_base_view/viewing_the_schema_of_a_base_view) of the Virtual DataPort Administration Guide.
If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you.
Hope this helps!