Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Every week we get the error (cannot find gateway) when it tries to connect to the oracle server it starts on saturday and seems to resolve itself by Tuesday. However the dataflows that connect to oracle seem to work fine with no errors and can find the gateway.
What reason could it be that the oracle using the connector cant find the gateway during those days but the dataflow can?
We are using DEC 2023 gateway.
Thanks
Hi @jak8282
That certainly is unusual that your data flows still continue to work. What I would suggest doing is upgrading new gateway to the latest version as well as also ensuring that your gateway server can successfully connect to the Oracle server over the weekend. If that store fails, I will chat your Oracle DBA to help troubleshoot the issue.
Yeah we are going to try and access the event logs - if it was failure to conenct though - why would the dataflows refresh okay? Yeah we are in discussion with the Oracle DBA
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.