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

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

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 error

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

Cache error

Cache settings error.
answered 24-11-2017 07:30:21 -0500

Hi guys, new issue has been found regarding cache: because of unknown reasons Denodo cannot correctly enable caching on server (Server Configuration -> Cache) with error below after applying settings: Operation completed with errors: Error sav...

Answers: 1

Cache Cache error

Error while fetching dates column from Cache
answered 11-08-2017 07:56:00 -0400

Hi Team, we are facing error while fetching the dates column from cache DB. We are using full cache option for a derived view. It is storing the data in the cache but when we are trying to fetch it dates column is throwing error. Please find the error...

Answers: 1

Cache error

Caching not working while joining two tables.
answered 09-05-2017 08:00:40 -0400

Hi, I have created two tables X, Y and enables the cache. With the current configuration. X, Y caching works individually. But when I do a join query with both tables. The cache is not working. Can some one help me on this. EX: select from X trace; -...

Answers: 1

cache cache configuration Cache error

Cache
answered 07-05-2015 18:28:21 -0400

Denodo 5.0 release 20141023 - Windows Server 2008R2. Have run across issue with cache several times. I have a table that I do a full cache never expire and have a schedule job that updates it once a night. The table is a union view of three tables. Abo...

Answers: 3

Cache error

Cache Error
answered 02-03-2015 15:59:16 -0500

Hello, Can someone help me with below cache error ? We have a scheduled job to load the cache for a table, and the job failed with below error code. We have several tables in the same job to refresh cache and two of them failed with same error as belo...

Answers: 3

Cache error