Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

filipp_tokarev

Error occurred while decoding OAEP padding

Submitted by on ‎10-12-2017 05:35 AM

 

Hello,
I have a problem with "On-premises data gateway". When connecting to the MySQL server in the corporate local area network via the "On-premises data gateway", I getting an error where: "Error code: DM_GWPipeline_UnknownError" and the "Basic error message: An error occurred while decoding OAEP filling."
The MySQL server and "One-premises data gateway" are protected by firewall. Firewall is allowing traffic form "One-premises data gateway" to Azure Web Services IPs listed here: https://www.microsoft.com/en-us/download/confirmation.aspx?id=41653
"One-premises data gateway" installed on Windows 2012 R2.

error_gateway.jpg

 

Status: Needs Info
See more ideas labeled with:
5 Comments (5 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎10-13-2017 12:06 AM

Hi @filipp_tokarev,

 

Was on-premise data gateway installed on the same machine as MySQL database hosted? 

 

Please update the on-premise data gateway to the latest version 14.16.6464.1. If issue persists, please share the the gateway log with us: 

 

q2.PNG

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Impactful Individual
‎10-13-2017 12:06 AM
Status changed to: Needs Info
 
filipp_tokarev
New Member
‎10-15-2017 09:17 PM

Hello,

The gateway and MySQL server are separate virtual machines, that could transparently see each other. The gateway version matches the one you proposed (14.16.6464.1)

Screen_PB.jpg

 

Starting trace on 13.10.2017 11:18:04 UTC
Version: 13.0.2506.0


EnterpriseGatewayConfigurator.exe Information: 0 : Initialize MainViewModel
EnterpriseGatewayConfigurator.exe Information: 0 : GetConfiguratorStateAsync
EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client is not defined in registry.
EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client is not defined in registry.
EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client is not defined in registry.
EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client is not defined in registry.
EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client is not defined in registry.
EnterpriseGatewayConfigurator.exe Information: 0 : Value SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client is not defined in registry.
EnterpriseGatewayConfigurator.exe Information: 0 : Found SOFTWARE\Microsoft\.NETFramework\v4.0.30319/SchUseStrongCrypto data in registry, value: 1.
EnterpriseGatewayConfigurator.exe Information: 0 : Found SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319/SchUseStrongCrypto data in registry, value: 1.
EnterpriseGatewayConfigurator.exe Information: 0 : Configuration Id: '212860'
EnterpriseGatewayConfigurator.exe Information: 0 : Configuration ObjectId: '743968e1-6e00-49ea-a23d-88ae35fdaad8'
EnterpriseGatewayConfigurator.exe Information: 0 : Configuration IsDisconnected: 'False'
EnterpriseGatewayConfigurator.exe Information: 0 : Configuration SB Endpoint: 'sb://wabi-west-europe-relay49.servicebus.windows.net/0d51e0c7-5cfb-4a2c-b9d9-d2e702e27e21/'
EnterpriseGatewayConfigurator.exe Information: 0 : Configuration BackendUri: 'https://wabi-west-europe-redirect.analysis.windows.net/'
EnterpriseGatewayConfigurator.exe Information: 0 : Create web request for Uri: http://www.msftncsi.com/ncsi.txt
EnterpriseGatewayConfigurator.exe Information: 0 : Response status: OK
EnterpriseGatewayConfigurator.exe Information: 0 : Create httpClient request for Uri: http://www.msftncsi.com/ncsi.txt
EnterpriseGatewayConfigurator.exe Information: 0 : Response status: OK
EnterpriseGatewayConfigurator.exe Information: 0 : Sign In
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 10/13/2017 11:18:22:  - AuthenticationContext: ADAL .NET with assembly version '2.28.3.860', file version '2.28.31117.1411' and informational version '78bd21073cfd91768d97894ace1ba90c5b904eec' is running...
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:22:  - AuthenticationContext: ADAL .NET with assembly version '2.28.3.860', file version '2.28.31117.1411' and informational version '78bd21073cfd91768d97894ace1ba90c5b904eec' is running...
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 10/13/2017 11:18:22: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - AcquireTokenHandlerBase: === Token Acquisition started:
	Authority: https://login.microsoftonline.com/common/
	Resource: https://analysis.windows.net/powerbi/api
	ClientId: ea0616ba-638b-4df5-95b9-636659ae5121
	CacheType: Microsoft.IdentityModel.Clients.ActiveDirectory.TokenCache (0 items)
	Authentication Target: User
	
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:22: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - AcquireTokenHandlerBase: === Token Acquisition started:
	Authority: https://login.microsoftonline.com/common/
	Resource: https://analysis.windows.net/powerbi/api
	ClientId: ea0616ba-638b-4df5-95b9-636659ae5121
	CacheType: Microsoft.IdentityModel.Clients.ActiveDirectory.TokenCache (0 items)
	Authentication Target: User
	
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:22: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: Looking up cache for a token...
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:22: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: Looking up cache for a token...
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 10/13/2017 11:18:22: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: No matching token was found in the cache
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:22: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: No matching token was found in the cache
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:22:  - WindowsFormsWebAuthenticationDialogBase: Navigating to 'https://login.microsoftonline.com/common/oauth2/authorize?resource=https://analysis.windows.net/powerbi/api&client_id=ea0616ba-638b-4df5-95b9-636659ae5121&response_type=code&haschrome=1&redirect_uri=urn:ietf:wg:oauth:2.0:oob&client-request-id=d79080f4-03c6-409a-88fb-f07f91ebb7e9&x-client-SKU=.NET&x-client-Ver=2.28.3.860&x-client-CPU=x64&x-client-OS=Microsoft Windows NT 6.2.9200.0&prompt=select_account&msafed=0&login_hint=stanislav.kirzhakov@stroylandiya.ru'.
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:22:  - WindowsFormsWebAuthenticationDialogBase: Navigating to 'https://login.microsoftonline.com/common/oauth2/authorize?resource=https://analysis.windows.net/powerbi/api&client_id=ea0616ba-638b-4df5-95b9-636659ae5121&response_type=code&haschrome=1&redirect_uri=urn:ietf:wg:oauth:2.0:oob&client-request-id=d79080f4-03c6-409a-88fb-f07f91ebb7e9&x-client-SKU=.NET&x-client-Ver=2.28.3.860&x-client-CPU=x64&x-client-OS=Microsoft Windows NT 6.2.9200.0&prompt=select_account&msafed=0&login_hint=stanislav.kirzhakov@stroylandiya.ru'.
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:25:  - WindowsFormsWebAuthenticationDialogBase: Navigated to 'https://login.microsoftonline.com/common/oauth2/authorize?resource=https://analysis.windows.net/powerbi/api&client_id=ea0616ba-638b-4df5-95b9-636659ae5121&response_type=code&haschrome=1&redirect_uri=urn:ietf:wg:oauth:2.0:oob&client-request-id=d79080f4-03c6-409a-88fb-f07f91ebb7e9&x-client-SKU=.NET&x-client-Ver=2.28.3.860&x-client-CPU=x64&x-client-OS=Microsoft Windows NT 6.2.9200.0&prompt=select_account&msafed=0&login_hint=stanislav.kirzhakov@stroylandiya.ru'.
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:25:  - WindowsFormsWebAuthenticationDialogBase: Navigated to 'https://login.microsoftonline.com/common/oauth2/authorize?resource=https://analysis.windows.net/powerbi/api&client_id=ea0616ba-638b-4df5-95b9-636659ae5121&response_type=code&haschrome=1&redirect_uri=urn:ietf:wg:oauth:2.0:oob&client-request-id=d79080f4-03c6-409a-88fb-f07f91ebb7e9&x-client-SKU=.NET&x-client-Ver=2.28.3.860&x-client-CPU=x64&x-client-OS=Microsoft Windows NT 6.2.9200.0&prompt=select_account&msafed=0&login_hint=stanislav.kirzhakov@stroylandiya.ru'.
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:33:  - WindowsFormsWebAuthenticationDialogBase: Navigating to 'https://login.microsoftonline.com/common/login'.
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:33:  - WindowsFormsWebAuthenticationDialogBase: Navigating to 'https://login.microsoftonline.com/common/login'.
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:33:  - WindowsFormsWebAuthenticationDialogBase: WebBrowser state: IsBusy: True, ReadyState: Complete, Created: True, Disposing: False, IsDisposed: False, IsOffline: False
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:33:  - WindowsFormsWebAuthenticationDialogBase: WebBrowser state: IsBusy: True, ReadyState: Complete, Created: True, Disposing: False, IsDisposed: False, IsOffline: False
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:33:  - WindowsFormsWebAuthenticationDialogBase: WebBrowser state (after Stop): IsBusy: False, ReadyState: Complete, Created: True, Disposing: False, IsDisposed: False, IsOffline: False
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:33:  - WindowsFormsWebAuthenticationDialogBase: WebBrowser state (after Stop): IsBusy: False, ReadyState: Complete, Created: True, Disposing: False, IsDisposed: False, IsOffline: False
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:34: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: Storing token in the cache...
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:34: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: Storing token in the cache...
Microsoft.IdentityModel.Clients.ActiveDirectory Verbose: 1 : 10/13/2017 11:18:34: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: An item was stored in the cache
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:34: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - TokenCache: An item was stored in the cache
Microsoft.IdentityModel.Clients.ActiveDirectory Information: 2 : 10/13/2017 11:18:34: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - AcquireTokenHandlerBase: === Token Acquisition finished successfully. An access token was retuned:
	Access Token Hash: E2J/mktX1LHajMb7xBZIm9OFFNd8N1E+RQ6k7QHewvE=
	Refresh Token Hash: d5EbSxCijAWgeFmzanZNlv4fYJxdoKRV3dFGtfbYrao=
	Expiration Time: 10/13/2017 12:18:33 +00:00
	User Hash: kZQRqHXjc1JDeD9UbXhFr0+yLfl6otvqRvfU3nCNhVo=
	
EnterpriseGatewayConfigurator.exe Information: 0 : 10/13/2017 11:18:34: d79080f4-03c6-409a-88fb-f07f91ebb7e9 - AcquireTokenHandlerBase: === Token Acquisition finished successfully. An access token was retuned:
	Access Token Hash: E2J/mktX1LHajMb7xBZIm9OFFNd8N1E+RQ6k7QHewvE=
	Refresh Token Hash: d5EbSxCijAWgeFmzanZNlv4fYJxdoKRV3dFGtfbYrao=
	Expiration Time: 10/13/2017 12:18:33 +00:00
	User Hash: kZQRqHXjc1JDeD9UbXhFr0+yLfl6otvqRvfU3nCNhVo=
	
EnterpriseGatewayConfigurator.exe Information: 0 : backendUriFromService: https://wabi-west-europe-redirect.analysis.windows.net/
EnterpriseGatewayConfigurator.exe Information: 0 : Service returned 1 gateways for this user
EnterpriseGatewayConfigurator.exe Information: 0 : Model gateway state: Configured
EnterpriseGatewayConfigurator.exe Information: 0 : Local service is configured, verify gateway is setup in Power BI service
EnterpriseGatewayConfigurator.exe Information: 0 : Gateway Name 'pbgateway@stroylandiya.ru', Status 'Installed' (Configured)
EnterpriseGatewayConfigurator.exe Information: 0 : Gateway collection returned no matches for gateway ID '212860', default to unconfigured state
EnterpriseGatewayConfigurator.exe Information: 0 : Gateway status check: Live
EnterpriseGatewayConfigurator.exe Information: 0 : Sign in complete
EnterpriseGatewayConfigurator.exe Information: 0 : Create web request for Uri: http://www.msftncsi.com/ncsi.txt
EnterpriseGatewayConfigurator.exe Information: 0 : Response status: OK
EnterpriseGatewayConfigurator.exe Information: 0 : Create httpClient request for Uri: http://www.msftncsi.com/ncsi.txt
EnterpriseGatewayConfigurator.exe Information: 0 : Response status: OK
filipp_tokarev
New Member
‎10-16-2017 12:18 AM

Hello,

The gateway and MySQL server are separate virtual machines, that could transparently see each other. The gateway version matches the one you proposed (14.16.6464.1)Screen_PB.jpg

v-qiuyu-msft
Community Support
Community Support
‎10-16-2017 07:31 PM

Hi @filipp_tokarev,

 

As MySQL and on-premise data gateway exist on different machines, can you verify from the machine host the data gateway can access the MySQL, make sure those two machines can communicate each other. 

 

Also check if your network requires proxy, if it does, please follow this article to finish settings.

 

Best Regards,
Qiuyun Yu 

Idea Statuses