Latest Activity
I have created a derived view ('client') on the top of a Excel and partial cache mode is on. Now I am trying to check how partial cache works.Initially I have around 10 rows. I have also created a base view on the top of cache database. I am executing ...
Hello - very new to Denodo and running into a questions I am looking for help with. Esentially, I have created an ODBC connection between our denodo databases and Alteryx. I am querying data from a denodo table, but I am only interested in returning da...
Hi: I'm trying to use fullcache for a DV compound of a join between a ODBC and JDBC base views, when executing this DV dv_customer_calls without cache the result is 2512 rows, however when updating the DV to Full Cache it restuns 0 rows. Is this the ex...
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...
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...
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...
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...
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...
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.
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...