You can translate the question and the replies:

Unable to open view when concurrent queries reaches the limit set in resource manager

Hi Team In Resource Manager, I have created a rule and plab for concurrent queries.Limit for a particular user to execute concurrent queries is set to 5.When the user is trying to open 6th view, it is showing "Maximum number of concurrent queries by group reached" and unable to open a view. I just want the query to be in queue while executing but the view should be able to open. Please guide me on this?
user
08-06-2023 09:55:47 -0400
code

2 Answers

Hi, This happens because when opening a view in the Administration Tool, a select query is executed to get information about the cache configuration which counts towards the maximum number of concurrent queries. Therefore this query will the queued and you the view will not be opened in the meantime. I recommend using the Design Studio to open your views, because opening a view in the Design Studio uses a different logic which does not include any queries that are counted towards the maximum number of concurrent queries. Hope this helps!
Denodo Team
09-06-2023 05:52:52 -0400
code
Hi Team I have created a plan in which "maximum number of concurrent queries" is set to 2 and "maximum number of queued queries" is set to 2. And I have created a rule for user_name='abc' and useragent='Denodo-VDP-AdminTool'. When I(abc) execute a 3rd and 4thquery, it wont be able to open and will be in queued state in query monitor.But if i am opening 5th view i am able to open. Is this expected?
user
16-06-2023 02:46:19 -0400
You must sign in to add an answer. If you do not have an account, you can register here