Can't add Oracle data source to gateway

[Mamuka]

Hi, I am not able to add datasource to gateway. I get the following: 

Spoiler

Unable to connect: We encountered an error while trying to connect to PS91PROD. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	2d9989a7-94be-47a5-949f-ffee9091fc6e
Request ID:	ae0a8bbd-9ee1-1c19-7969-a4c8ebf9ca79
Cluster URI:	https://wabi-europe-north-b-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Sun Dec 17 2017 20:42:39 GMT+0400 (Georgian Standard Time)
Version:	13.0.3495.153

PS:	Cannot connect to the mashup data source. See error details for more information.
Underlying error code:	-2147467259
Underlying error message:	Oracle: ORA-12170: TNS:Connect timeout occurred
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	Oracle
Microsoft.Data.Mashup.ValueError.DataSourcePath:	ps91prod
Microsoft.Data.Mashup.ValueError.ErrorCode:	-2147467259
Microsoft.Data.Mashup.ValueError.Message:	ORA-12170: TNS:Connect timeout occurred
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error

attaching link to Log Files

In the log it is visible that several times I got wrong credentials (which was deliberate) to confirm that gateway was getting to the database correctly. Once the correct database user/password is provided it fails with timeout. I know that TNS connection works as I'm using it on Oracle SQL Developer to connect to the Oracle DB without any issues. 

[Anonymous · Accepted solution]

Hi @Mamuka,

Based on your error message, I found it notice your oracle instance not registered valid:

We could not register this data source for all gateway instances within this cluster

After check on your log file, I found the log mentioned: 'your oracle connection provider version not suitable'.

The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'

Please double check on this part, install a valid client version and try again.

Regards,

Xiaoxin Sheng

[deepu299]

Hi @Mamuka 

As @Anonymous mentioned, if you are getting the warning about deprecated client, you need to install ODAC. SQL Developer works fine with Oracle Client but Power BI will be expecting ODAC as mentioned in this blog. Clean up the clients, install this and give a try.  I am able to resolve the warnings with these clients: 

ODTwithODAC122010 – 32-bit

ODAC122010_x64 - 64-bit