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

Thanks for that information josef78 . I was able to change this in the configuration file, but I don't think this is the answer most of us are looking for. I believe for most of us the concern is the number of connections that are occurring with each filter/slicer change. I am seeing between 10 to 20 connections per change depending on the report, so even if I change the config file to 200 connections, it does not take very long for it to get to 200 connections. So what has changed in the October 2020 version (Still exists in January 2021) to make all these connections appear? Reports created with desktop versions prior to October 2020 do not appear to have this same issue. Is it related to the enhanced metadata format preview feature? Has anyone tested with that feature off?