You can translate the question and the replies:

Fields Truncation

We have a delimited data source of weblogs, when we try to cache the data results in below error. Finished with error: Error loading cache: There was an error during a batch insertion: String or binary data would be truncated.. total time: 14 seconds [14277 ms] The cache database is SQL server. one of the column has a value of max length = 8645, will that be an issue? Is there a limit any limit on max string length?
user
28-02-2020 02:10:36 -0500

1 Answer

Hi, 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!
Denodo Team
05-03-2020 07:41:57 -0500
You must sign in to add an answer. If you do not have an account, you can register here