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

Petebro  I reproduced the issue as following:

  1. Create new Power BI report with live connection to tabular model. 
  2. Added 4 visual with  existing measures and different dimensions.
  3. publish it to PBIRS. 
  4. Restart PBIRS to see zero RS Portal connection.
  5. Start to drilldown/filter visuals and apply filters via filter sections.
  6. I can see about 2 to 6 new connections for each new combination.

 

btw: I also tried to switch off the "enhanced meta data" feature but still get the issue.

 

 

jbarta_mlchc's avatar
jbarta_mlchc
Helper III
5 years ago

Petebro I turned off the metadata preview feature, restarted desktop, and created a report with six visuals and one slicer. With each slicer change my connections increased by 6 connections even with the "enhanced meta data" off. So I am seeing the same things as Anonymous.