Q&A BY TAG 'Cache'

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

Error loading cache timeout after 900seconds
answered 02-01-2018 12:47:17 -0500

Dear all when executing the cache preload VQL command SELECT * FROM "DV_ITSR.T_COSTING_RESULT_J_BV_EAGLE_MAINDB_PROD_SRZMGE_1" CONTEXT( 'cache_preload' = 'true' , 'cache_invalidate' = 'all_rows' , 'cache_wait_for_load' = 'true' , 'cache_return_quer...

Answers: 2

cache query error timeout

Identifying if Cache Maintenance is running
answered 18-12-2017 08:19:41 -0500

I'm going through the process of removing the Cache Maintenance task and replacing with scheduled clean cache calls. Is there a way that I can tell if the current Cache Maintenance task is running? Can I tell when? Since its only configured with time i...

Answers: 1

CALL CLEAN_CACHE_DATABASE Cache

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

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