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 Petebro. The report I have been testing with does have a larger amount of visuals and slicers. But I have similar reports built with prior desktop versions that do not create the same amount of connections. So if it is related to the enhanced model metaddata feature I can try testing that. The report was originally created with that feature on, so I would have to recreate the report with the feature off, right? I can't just turn the feature off and redeploy the original report? 

 

Additionally, if I increase the max connection in the config file, is there a best practice for where to set that?  If I set it to 200 and the report is creating 10 to 20 connections per filter slice, those will be used up very quickly.