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.
Anonymous's avatar
Anonymous
Not applicable
5 years ago

This is my understanding of rsportal and a connection pool:

rsportal is configured to use a maximum of 100 pooled connections. When it has reached 100, no new connection may be established. One of the 100 pooled connections must be used. If all connections are still being used (possibly incorrectly), the portal will no longer respond. When the timeout is reached, server logs the error msg.

 

After a few minutes you can see that the number of connections are falling and Report Server is responding again.

 

Petebro  Did you get any feedback from the Desktop RS guys?

josef78's avatar
josef78
Memorable Member
5 years ago

Hi,

it is configurable varialbe, you can set in rsreportserver.config option <MaxCatalogConnectionPoolSizePerProcess>

 

In my production enviroment, is default value =0=100 not enough, but with different symptoms (users waiting too long in some queue to load model to ssas).

I'm using 200.

 

j.