Forum Discussion

zeel801p's avatar
zeel801p
Frequent Visitor
9 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

    Well what i found out about open Oracle connections when using PBI Reportserver Schedules: They stay open -until closed by killing the processes or by reboot  - so we do regular reboots of the PBI server - sorry for the short service interruption - but MS is not giving any parameters to get the connections closed otherwise.

  • 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.