Q&A BY TAG 'Cache Error'

You must sign in to ask a question. If you do not have an account, you can register here

The data source does not support 'cache_invalidate'='matching_pk'.
answered 04-10-2021 23:16:00 -0400

I have a data source that is doing a series of calls to an API to pull in a full data (the first time) that takes almost 6 hours. I successfully cached that data into a view -- but now want to only update records everyday that have a "last updated date...

Answers: 2

primary keys Cache Error API

INetCache 1,000,000 Javascript Files
answered 19-03-2021 09:04:36 -0400

Hello, We are currently running denodo on one of our machines and only denodo and it appears that the INetCache has over 1,000,000 javascript files in it and is using up almost over 100 GB of storage. Does denodo need these files or are these safe to ...

Answers: 1

Cache Error ITPilot

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

Cache Error

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

Cache Error

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

Cache error

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

Cache error

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

Cache error

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

Cache error

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

Source refresh schema change Cache Cache error

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