I have found when using the Full cache option with Incremental mode that I have to first do an explicit load of the cache. When running the incremental to update based on a date field (typically a time stamp of last update), I will set the condition
'c_last_modified < @LASTCACHEREFRESH'
More information on using the incremental cache stored procedure can be found in the [Denodo Incremental Cache Load Stored Procedure User Manual](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Incremental%20Cache%20Load%20Stored%20Procedure%20-%20User%20Manual).
Also, since your job uses a stored procedure, the job is likely failing due to reaching the default timeout for stored procedures in the VDP server. To increase this value, navigate to Administration > Server Configuration > Stored procedures. Increase the value for "Query timeout" and retry the job.
Hope this helps!