Forum Discussion
Error RSPortal: obtaining a connection from the pool
I've worked on this issue with the support. Issue number is 121020321001710.
There is a demo dashboard with Adventure Works Tabular Model and some slicers and filters.
We've fixed the issue by increasing
<MaxCatalogConnectionPoolSizePerProcess> to 500.
This should be a temporary solution. I've heard that the support is collecting the issues to decide how important that bugfix is. At least they will clarify the parameter in the documentation of the next version.
We have just tested with a few developers our most critical dashboard. One user can reach approx. 130 connections in 2 minutes. Four users could not reach more than 246 connections. So it is not an easy calculation where you can multiply the dashboard, visuals and filters by the number of users. If 500 is not enough, we can improve the value to 1000. I've not seen a real impact on memory or other resources.
ChrisMuthmann Thanks again for your response! I appreciate the information! I will change the pool size and monitor. I am hoping there will be a permanent fix in the near future! Thanks again!