Q&A BY TAG 'cache'

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

Cached view - Tableau Server will not pull in data
answered 19-06-2020 08:10:31 -0400

I have a view that I can see cached results for in the VDP. I have scheduler set to refresh this cache daily. For some reason Tableau Server will not succefully connect to this data source (it is visible in the connections list). It has ~250k rows and ...

Answers: 2

Automic scheduler Full Cache denodo with tableau Cache

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