Forum Discussion

zeel801p's avatar
zeel801p
Frequent Visitor
8 years ago

Oracle Connector Leaving Open Connections

So I recently started using Power BI with our oracle server to build some reports. What I have noticed and it has caused severe issues is that when I go to refresh my data, Power BI (via "Oracle Conn...
Need Help
wobi's avatar
wobi
Frequent Visitor
4 years ago

We too face open Oracle connections - when PBI reports are scheduled on our PBI Server - any hints how to get them closed automatically - cleaning up from Oralce site is not a solution!

Wobi

wobi's avatar
wobi
Frequent Visitor
4 years ago

We observerd that hanging / not closed mesh container processes keep the connection open - kill the process and the connection @ oracle is closed - are there any options to controll the mesh container prozesses cleanup - would be helpful!

Wobi

  • Rafaelhk's avatar
    Rafaelhk
    Frequent Visitor
    4 years ago

    We are trying to avoid rebooting the servers (DB server is unthinkable, PBIRS server is not recommended, but not off the table).

     

    We found that manually refreshing, by opening the report in the PBI desktop and refreshing from there, has a different behavior and actually closes the connections as the refresh ends.

    We cheched th ODAC driver from our desktops and servers and they are both running the same versoin, so it`s not a problem with the driver version.