Q&A BY TAG 'CACHE ERROR'
cache error with the fresh configuration of cache
answered
15-12-2020 07:18:25 -0500
getting an error after making a fresh connection and cache configuration Error modifying view: There was an error inserting a new row in the table 'vdb_cache_names' of the cache database. : The table does not comply with the requirements by an externa...
Answers:
1
Error modifying view: View names not available
answered
22-09-2020 08:29:57 -0400
Hi , I am creating simple derived view from 2 base views , while enabling cache on the derived view i'm getting "Error modifying view: View names not available" error . Thanks for your help in advance....!
Answers:
1
No data returned when activating cache
answered
04-05-2020 15:13:22 -0400
Hi, I'm folowwing the tutorial and at page https://community.denodo.com/tutorials/browse/basics/5cache3types, the request returns no row when activating cache. It relates to "client_with_bills" view. Please help, Thank you
Answers:
6
Error obtaining the expressions to delegate the projected fields to source vdpcachedatasource
answered
31-03-2020 09:36:18 -0400
Hi, We are obtaining randomly this error (we run the job daily, but sometimes it produces failure, other days not): "Error obtaining the expressions to delegate the projected fields to source vdpcachedatasource" Last time we had to delete the view ...
Answers:
3
Fields Truncation
answered
05-03-2020 07:41:57 -0500
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 ...
Answers:
1
incremental cache stored procedure finishing with error
answered
10-10-2019 08:21:35 -0400
incremental cache stored procedure finishing with "error getting rows to update in cache" . i followed the installation manual, where could i have gone wrong?
Answers:
1
Schema change and Source Refresh with Denodo and Cache store
answered
24-04-2019 17:23:09 -0400
Hello, We have snowflake as our cache store. When we add a new column to source, our cache refresh jobs fails with "Number of columns in file (25) does not match that of the corresponding table (23),". Any process we ned to follow to update cache schem...
Answers:
1
Full Caching in Denodo Express
answered
12-03-2019 08:35:16 -0400
I'm trying to enable caching on a view that I have created based off of a JDBC connection to a SQL server. I'm using Denodo express and when I try to turn on full caching, i get the following error: Error loading jdbc data source 'vdpcachedatasource'...
Answers:
3
Cache error by inserting null data
answered
18-05-2018 11:45:40 -0400
When I make a query to save in cache, at the end I get the following error: "ERROR_LOAD_CACHE", "Error loading cache: There was an error while inserting data: null", in the fields use the function: COALESCE to avoid null values someone would have some...
Answers:
2
Cache invalid rows.
answered
04-12-2017 07:38:13 -0500
Hi guys, There is a situation when we created a view which uses two different data sources (db2 as/400 and ms sql server). Also this view has denodo parameter "IN_Role" with three values: 'DB2' - choose from db2 'MSSQL' - choose from ms sql ser...
Answers:
2