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.
user
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](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy) 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](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/queries_optimization/queries_optimization) is enabled and also review the [Streaming vs. Non-Streaming Operators](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/memory_management/streaming_vs_non-streaming_operators/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