The error "error getting rows to update in cache" usually occurs for the following reasons:
* When the cache configured in Denodo is having some difficulty in getting the rows from the Data Source.
* Could be related to deadlock in the cache system. Re-running the query when system is not at peak will solve your problem. But we would suggest to recheck the logic on how the parameters are defined for the incremental stored procedure.
So, I would check the "vdp.log" file found under the ''<DENODO_HOME>\logs\vdp'' folder which will contain more information about this error.
Hope this helps!