Q&A BY TAG 'Cache'

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

Cache - Error modifying view: View names not available
answered 22-05-2020 03:33:28 -0400

Hi, I'm using donedo express. I configured my donedo server with following settings: cache status ON maintenance OFF Defaut time to Live 2160 Specify an existing data source CHECK. I specified one of my existing donedo data source setup. When I try...

Answers: 1

Cache

External cache
answered 22-05-2020 03:13:22 -0400

Hi, When trying enabling external database cache by deslecting the "Specify existing data source as cache" I'm getting following error: "Operation completed with errors: Error saving cache settings: Error creating data source: destination folder '/fi...

Answers: 1

Cache

Cache Refresh Issue
answered 10-03-2020 00:44:36 -0400

Cache DB: Oracle Denodo Version: 7.0 Caching Mode: Full cache Current Setup: There are two prod servers under a load balancer. There is one cache DB that is configured for both the server. Hello, we have a unique situation with the cache DB and sched...

Answers: 3

Cache

Denodo cache storing at external DB
answered 09-03-2020 12:04:09 -0400

Please I want to ask if I can store denodo cache at external database ( as mysql or other) ?

Answers: 1

external Database Cache

SQLServer as Cache with BCP - Best practices ?
answered 05-03-2020 07:28:52 -0500

Hello, When switching from MSSQL "standard" cache load, to a bulk-load using BCP, what are the best practices and recommendations regarding the SQL Server database ? The User Manuals (here) are quite laconic about that. Best regards

Answers: 3

MSSQL bcp Cache

Cache Load Question
answered 10-02-2020 07:49:05 -0500

Source Database: DB2 I have a view say top_level_view, which takes a long time to query and aggregate from the DB2 database. We decided to cache this view with a where clause for 15K keyids. To begin with we tried to run the view without caching to se...

Answers: 1

Full Cache Cache

unavailability of shared cache during deployments in mult-node architecture
answered 28-01-2020 11:10:19 -0500

we have a single cache DB ( shared cache) for multiple Prodution denodo nodes. but problem with this architecture is when we do deployment of views having cache associated with it on any of nodes . this makes the cache unavailable/invalid for other nod...

Answers: 1

shared cache Zero downtime Cache deployment

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 09-01-2020 14:37:07 -0500

Hi Team, We use AWS RDS for Denodo Cache. We have upgraded RDS mysql version from 5.6.41 to 8.0.16. When trying to connect from Denodo VDP to RDS, it is throwing below error. Unable to establish connection: Communications link failure The last packe...

Answers: 1

Cache

Denodo Disparat sources join without Cache.
answered 26-12-2019 14:12:56 -0500

Hi Guys, I am new to Denodo. I have installed Express edition on my laptop and running a sample task. I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join ...

Answers: 3

join Cache

Cache fetch error
answered 12-12-2019 00:34:47 -0500

Hi Team, Denodo 6.0 source DB : SQL Server cache DB : SQL Server cache type : Full Cache , Never Expire normal query : runs successfully, 10230397 rows cache query : when loading cache : error Error: [BASE] [ERROR] There was an error during a batch...

Answers: 4

Cache