Forum Discussion
Can't add Oracle data source to gateway
Hi, I am not able to add datasource to gateway. I get the following:
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.
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
2 Replies
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
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
