What I would do to try to troubleshoot this issue is to go to the data source and compare the original table to the cache table in terms of metadata. I would find the cache table on the SQL Server cache. Cache tables have a name starting with ‘C_’ followed by the view name and a control number. There I would expect to find a column with a type that causes trouble when trying to store data from the original table of that same source.
Then, to fix this I would go back to Denodo and [change the type](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/viewing_the_schema_of_a_base_view#viewing-the-schema-of-a-base-view), by clicking on the pencil icon, in the appropriate field to something suitable in terms of size. Say varchar(10) to varchar(20). This change would then propagate to the cache and should fix a problem of this kind
Hope this helps!