- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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-data...
I have had it working well in the past.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have done this and there are still random failures that happened. As I said, it does sometimes complete successfully. Could it be just an issue with the server connectivity?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If that is the case I would suspect connectivity issues to the Oracle server. If possible to chat to your network Admin?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-05-2024 02:43 AM | |||
03-04-2022 12:44 AM | |||
10-19-2024 11:55 AM | |||
11-27-2024 04:40 PM | |||
02-06-2024 11:38 PM |
User | Count |
---|---|
55 | |
52 | |
49 | |
13 | |
11 |