Azure Analysis Services从本地Oracle数据库部署模型 [英] Azure Analysis Services deploying model from on-prem Oracle database
问题描述
您好我有一个Oracle数据库11g 11.2.0.4，我已下载了许多客户端和ODAC工具，最后我获得了32位Oracle运行时11.2.0.4和XCopy ODAC for 11.2.0.4 32位版本。 / p>
我已经设法安装网关，在Azure Analysis服务上注册它，也使用Visual Studio 2017连接到数据库，检索表和数据。我能够在VS2017上构建项目，但是当我想部署项目时，我得到
这个错误令人沮丧，因为没有多说：
无法保存对服务器的修改。返回错误：'与内部部署网关相关的活动发生错误。其他错误详细信息：DM_GWPipeline_Gateway_MashupDataAccessError
从网关服务收到的错误有效负载ID为396333：异步操作777b2521-cea2-46a7-a364-9f9c80e1b816是故障[0] Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException：Mashup表达式评估错误。原因：
。
GatewayPipelineErrorCode = DM_GWPipeline_Gateway_MashupDataAccessError
GatewayVersion = 3000.2.52
原因= --->
[1] Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException：Substituted：MashupValueException：< pi> Microsoft.Data.Mashup.MashupValueException（0x80004005）：提供者正在使用的是：'System.Data.OracleClient
需要Oracle客户端软件版本8.1.7或更高版本。'。请访问https://go.microsoft.com/fwlink/p/?LinkID=272376安装官方提供商。
请帮助
您好GZ80，
如果您没有安装Oracle客户端，当您尝试安装Oracle客户端时会看到错误创建或使用连接：
不推荐使用的提供程序：'System.Data.OracleClient需要Oracle客户端软件版本8.1.7或更高版本。'。请访问 https://go.microsoft.com/fwlink/p/?LinkID=272376 到
安装官方提供商。如果在运行本地数据网关的计算机上未安装Oracle客户端SDK，则会出现上述错误。
要解决此问题，请下载并安装
Oracle客户端SDK 。
作为先决条件：连接对于Oracle，您还需要在已安装本地数据网关的计算机上安装Oracle客户端软件。 具体而言，Oracle数据库连接需要安装64位Oracle Data Provider for .NET的
。 您可以使用以下链接下载并安装Oracle客户端：
适用于Windows x64的64位ODAC 12c第4版（12.1.0.2.4）
希望这会有所帮助。
Hi I have an Oracle database 11g 11.2.0.4, I have downloaded many clients and ODAC tools, finally I got the 32 bit Oracle runtime 11.2.0.4 and XCopy ODAC for 11.2.0.4 32-bit version.
I have managed to install the gateway, registered it on Azure Analysis services, have also connected to the database, retrieved tables and data using Visual Studio 2017. I am able to build the project on VS2017, but when I want to deploy the project I get this error which is frustrating because doesn't say much:
Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_MashupDataAccessError
Received error payload from gateway service with ID 396333: Async operation 777b2521-cea2-46a7-a364-9f9c80e1b816 is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Reason:
.
GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
GatewayVersion=3000.2.52
Reason= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): 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.
Please help
Hi GZ80,
If you do not have the Oracle client installed, you will see an error when you try to create or use the connection:
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. You get the above error if the Oracle client SDK is not installed on the machine where the on-premises data gateway is running.
To fix this issue, download and install the Oracle client SDK.
As a prerequisites: To connect to Oracle, you will also need to install the Oracle client software on the machine where you have installed the on-premises data gateway. Specifically, the Oracle Database connection requires the installation of the 64-bit Oracle Data Provider for .NET. You can use the following link to download and install the Oracle client:
64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64
Hope this helps.
这篇关于Azure Analysis Services从本地Oracle数据库部署模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
