Latest Activity

code

Clean cache database

Hi Team, Even after having a scheduler job for cleaning the cache database on a daily basis, still getting the below error. Could you please help. There was an error while inserting data : The database 'xx' has reached its size quota. Partition or d...

Cache Error

code

Denodo Cache refresh gets stuck when a SELECT is already being executed on the VDB

Hello, We have a VDB with cache db configured on Azure PostgreSQL v11. Assume a scenario when a SELECT is already running on Denodo VDB, accessing data from the configured cache. Now, if the Cache refresh job starts, at a set time, through Denodo Sched...

Cache Error Cache

code

Problem with Amazon Athena Cache

Hello, We have Denodo VDP 8.0 running in a Linux server. We add Amazon Athena Cache and we have a problem when try to store results in cache. The logs registered: FATAL YYYY-MM-DDTHH:MI:SS.FFF com.denodo.vdb.engine.thread.ReusableThread [] - runWork ...

Cache Error AWS S3 Athena athena Athena AWS athena Cache

code

The data source does not support 'cache_invalidate'='matching_pk'.

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...

primary keys Cache Error API

code

INetCache 1,000,000 Javascript Files

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 ...

Cache Error ITPilot

code

cache error with the fresh configuration of cache

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...

Cache Error

code

Error modifying view: View names not available

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....!

Cache Error

code

No data returned when activating cache

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

Cache error

code

Error obtaining the expressions to delegate the projected fields to source vdpcachedatasource

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 ...

Cache error

code

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 ...

Cache error