Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error RSPortal: obtaining a connection from the pool

Hi, we use Oct. 2020 release  (product version 1.9.7627.11028)  and have the following Internal Server Error:   2021-02-01 10:54:28.3246|ERROR|190|OData exception occurred: System.Exception: Rep...
Connection
Report Server
RSPortal
  • ChrisMuthmann's avatar
    ChrisMuthmann
    5 years ago

    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.
ChrisMuthmann's avatar
ChrisMuthmann
Resolver II
5 years ago

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.
jbarta_mlchc's avatar
jbarta_mlchc
Helper III
5 years ago

ChrisMuthmann Thanks for the response. I will increase the pool size to 500. But it seems like that could still be reached quickly with a small to medium-size company. If you have 20 employees and they use a report with 8 to 10 visuals on it. You get to 160 to 200 connections very quickly. With a few filter or slicer changes, you are at 500. Is this a temporary solution until they fix the issue?