Forum Discussion
Solved
Gateway Oracle as Data Source
Hello, I'm getting this error when I refresh via Gateway. I'm certain my problem is ODAC.
My question is, do I need to install SQL Developer and ODAC (ODAC121010Xcopy_x64) or installing ODAC (ODAC121010Xcopy_x64) only on the Gateway server will work?
I installed ODAC121010Xcopy_x64 on Gateway in C:\Oracle and C:\ODAC64 but refresh still fails with this error message:
| Underlying error code: | -2147467259 Table: Measure Summary |
| Underlying error message: | Oracle: |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.ValueError.DataSourceKind: | Oracle |
| Microsoft.Data.Mashup.ValueError.DataSourcePath: | orads |
| Microsoft.Data.Mashup.ValueError.ErrorCode: | -2147467259 |
| Microsoft.Data.Mashup.ValueError.Message: | |
| Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
| Cluster URI: | WABI-CANADA-CENTRAL-redirect.analysis.windows.net |
| Activity ID: | 86ce030e-acc2-4097-9502-100fe508712a |
| Request ID: | 7a14a00f-4571-467e-9494-8ccaa27e924d |
| Time: | 2019-07-10 07:01:10Z |
You may take a look at the post below.
1 Reply
You may take a look at the post below.