You can translate the question and the replies:

Error executing a query due to memory restriction

I have 12 dervied views, using which I have 1 final view with 12 left joins, when I execute the final view I end getting this following error **error analysing the query to decide the necessary memory restrictions based on the query limit specified:null ** I tried incresing the memory in server configuration, but still ended up getting the same issue. I am using denodo platform 8 I have not cached any views during the above task. underlying data source is DB2.
21-10-2021 10:24:08 -0400

1 Answer

Hi, This error can occur if the memory needed by Virtual DataPort for this operation exceeds the limit specified in the server configuration. I would examine the [memory usage settings]( using the Virtual DataPort Administration Tool. It may be useful to increase the maximum query size settings. I would further examine the query plan to make sure that the joins are being pushed down to the underlying data source if possible. If they aren’t I’d make sure that [Automatic Simplification of Queries]( is enabled and also review the [Streaming vs. Non-Streaming Operators]( I would check the <DenodoHome>\logs\vdp\vdp.log file for more information regarding the error. Hope this helps!
Denodo Team
22-10-2021 11:04:22 -0400
You must sign in to add an answer. If you do not have an account, you can register here