Q&A BY TAG 'cache'

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

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 31-07-2020 13:13:16 -0400

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: 3

Cache

Denodo 7.0 not invalidating matching rows with dynamic VQL, working in 6.0
answered 10-07-2020 01:43:08 -0400

I have a cache update query with the paramaters: select * from view_name where "PeriodMonth" in ( cast('text',substr(FORMATDATE('MMM', ADDMONTH(CURRENT_DATE(),-1)),1,1)||lower(substr(FORMATDATE('MMM', ADDMONTH(CURRENT_DATE(),-1)),2,3))||'-'||FORMATDAT...

Answers: 1

7.0 Cache

Incremental Cache Stored Procedure times out after 80 seconds
answered 29-06-2020 06:16:49 -0400

We are running the incremental cache stored procedure to insert/update records since the @LASTCACHEREFRESH. The procedure continues to fail with a generic error 'Finished with error: ERROR executing query update of cache [Rows updated in cache: 0].'. ...

Answers: 2

Incremental Cache Cache

Where is the incremental cache jar located in the Denodo program files?
answered 29-06-2020 06:07:22 -0400

The instructions to setup an incremental cache reference the .jar denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar. Where is this jar located? I cannot find it anywhere in our program files for our installation of Denodo 7...

Answers: 2

Cache

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