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.
Petebro's avatar
Petebro
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

This is likely NOT a desktop specific issue. The reason you see the change when saving with a specific version of desktop is likely just the state of the "enhanced model metadata" feature. There is likely an issue with cleaning up unused connections in PBIRS itself. Working with server team to try to reproduce this issue now, but we were running into some trouble getting it to break. Have you seen this issue on a simple report with slicers or has it been on more complicated reports with many visuals + slicers?

 

For now you can increase the number of connections in the config file as one use suggested, or use reports with enhanced metadata disabled. I will update you when we know more.

ChrisMuthmann's avatar
ChrisMuthmann
Icon for Resolver II rankResolver 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.