I am getting the following error message while trying to run the Incremental load. This was working fine in the production environment, but now in the test environment I keep getting thsi error even with 1 days' data.
Error executing query. Total time 80.104 seconds. QUERY [PROJECTION] [ERROR] INCREMENTAL_CACHE_LOAD [STORED_PROCEDURE] [ERROR] COM.DENODO.CONNECT.INCREMENTALCACHELOAD.STOREDPROCEDURE.INCREMENTALCACHELOADSTOREPROCEDURE [STORED PROCEDURE] [ERROR] Received exception with message ‘com.denodo.vdb.engine.storedprocedure.StoredProcedureException: ERROR getting rows to update in cache.’
These are the steps I have taken
•Installed the Denodo Incremental cache Load 7 JAR file.
•Create the Incremental Cache Load Stored Procedure
•Set up a job in Denodo Scheduler with Increemental load properties, I used Custom conditions
(snapshot_date between ‘2020-05-01’ and ‘2020-05-02’ )
What else should I do to get it to work ?