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 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 error Cache

Cache bulk load onto sql server using bcp is failing with bcp error
answered 20-09-2017 03:42:45 -0400

I'm trying to do a bulkload cache, and facing the below error. If run manually the bcp command we can put a file to write the errors during execution. But since this is triggered by Denodo how do catch the errors during bcp execution. Below is the erro...

Answers: 4

bulkload error bcp Cache

Mismatch between source table count and cache table count
answered 12-09-2017 09:22:39 -0400

My source table has 6239797 rows and when applied full cache and did a pre cache load I could see row count as 6239794, 3 records are missing. There were no search conditions used. What could be the possibility of count mismatch ? I have ran the denodo...

Answers: 1

Cache

Triger cache load job when no records
answered 29-08-2017 10:20:58 -0400

Hi, Is it possible to trigger a cache load query for a view whenever the count for the view doesn't gives any record. Basically i want to run a count on the view and when it doesn't give any record a cache load should happen.

Answers: 1

cache VDP

Caching Service Views
answered 23-08-2017 08:29:10 -0400

There are 14 Service Views in my database which gives data from 2011 - 2018 (joining different combinedviews). We created partial service views for each of the service view by giving a where condition inside the Partial service view (less than 2016 and...

Answers: 1

cache DENODO Denodo Scheduler 6.0 SQL Server

Unable to cache some views
answered 14-08-2017 09:24:58 -0400

I am trying to cache on Service Views Layer (14 Service Views). In the scheduler, I created VDPCahce jobs for every individual service view. After starting those jobs, I started the monitoring tool to see the status of caching. After 3 hours, 6 of the ...

Answers: 1

cache DENODO denodo scheduler SQL Server

Avoid deleting the cached data at the time of deployment to upper environments
answered 08-08-2017 09:09:02 -0400

We have some views created in the local environment and when we deploy it the upper environment, we cache the views. So, every time we do a deployment we turn the cache back on all the views. This is making the tables which are cached previously in the...

Answers: 1

cache DENODO SQL Server deploy

Partial Cache- Explicit loads
answered 19-07-2017 07:45:26 -0400

Denodo 6.0 express edition Created a derived view coming from a soap web service and a mysql database. Enabled cache at the server level. Enabled partial cache with explicit loads for the derived view. I executed the query "Select * from derived_view_...

Answers: 1

cache Partial cache cache configuration explicit loads

Scheduler: Delay till the data gets loaded in actual databases
answered 27-06-2017 12:36:19 -0400

I have a scheduled VDPCache job which starts every Saturday at 12:00. The actual databases from where the cache data gets loaded will undergo a weekend processing and gets new data. Sometimes this processing will takes long time than expected. If I kee...

Answers: 2

cache DENODO denodo scheduler SQL Server

Incremental Caching
answered 15-06-2017 06:16:36 -0400

Hello, I am in a situation where I am currently caching on the combined views layer. When I am done caching using Full mode for all the combined views for the first time, I want to keep the scheduled VDPCache jobs every weekend which must do increm...

Answers: 1

cache DENODO denodo scheduler