Forum Discussion
Gateway connection to Oracle server Error
We have a data gateway setup that connects to a SQL server and an Oracle server. We installed the Oracle client (12102 version). Didn't do an ODAC install, it's just the client. Everything connects successfully. I setup a refresh schedule. Here's my issue: sometimes it runs and refreshes successfully, and sometimes it fails (about half the time). What would cause this? I need to figure out if it's network connectivity issues or truly something with the client. The error message is below.
Note: I have a couple of times run into a refresh failure in Power BI Desktop, and it said it couldn't connect to the Oracle server. 5 minutes later I hit refresh again and it refreshed fine.
Error Message:
| Underlying error code: | -2147467259 Table: TLSOpenOrders. |
| Underlying error message: | The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider. |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
| Cluster URI: | WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net |
| Activity ID: | 6af7eccc-1edc-4980-823d-9c1b21476549 |
| Request ID: | 507e5e01-6c3f-43d6-befa-821176e65b24 |
| Time: | 2018-12-03 20:39:29Z |
3 Replies
- Hi there
I would suggest following my blog post to ensure that it is setup successfully.
https://www.fourmoo.com/2017/04/26/power-bi-on-premise-gateway-configuration-steps-to-an-oracle-database/
I have had it working well in the past.- Hi there
If that is the case I would suspect connectivity issues to the Oracle server. If possible to chat to your network Admin?
