It works for me in all the cases. In your case, I recommend you to enable VDP-requests.log file, to view the queries sent to the Server. Using which you could view the executed queries and the one which returns error.
I would do the following steps to enable requests log,
* Change the log category ‘com.denodo.vdp.requests’ to 'INFO' level by calling the LogController Stored Procedure in the VQL shell as,
CALL LOGCONTROLLER('com.denodo.vdp.requests', 'INFO')
* The request information sent to the server are logged in to the directory <Denodo-Home>\logs\vdp\vdp-requests.log.
Hope this helps you!