Re: Service cannot reach gateway Status code: BadR...

josem · ‎08-09-2016

I installed on-site data gateway successfully and after installing, I logged in to register gateway but I got the message: The service cannot reach the gateway. I can confirm that I can access internet from this server (via proxy server) and all ports are open.

Full error message below:

The service cannot reach the gateway.
Request error: Id: 'ddfbb5c2-985c-4638-9bc6-a6dbf6a52e51', Status code: 'BadRequest', Timestamp: '08/10/2016 06:32:28 +00:00', ErrorCode: 'DM_GWPipeline_UnknownError', Detail: ''
at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<EnsureSuccessfulDMMSRequest>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<DiscoverUnifiedGatewayStatusAsync>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.ConfiguratorClientExtensions.<DiscoverUnifiedGatewayStatusAsyncRetry>d__a.MoveNext()

josem · ‎08-09-2016

I have successfully installed On-premises data gateway but after installation, I logged in to register Gateway and during configuration, I got the message: The service cannot reach the gateway." Complete error message is below:

The service cannot reach the gateway.
Request error: Id: 'ddfbb5c2-985c-4638-9bc6-a6dbf6a52e51', Status code: 'BadRequest', Timestamp: '08/10/2016 06:32:28 +00:00', ErrorCode: 'DM_GWPipeline_UnknownError', Detail: ''
   at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<EnsureSuccessfulDMMSRequest>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<DiscoverUnifiedGatewayStatusAsync>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.ConfiguratorClientExtensions.<DiscoverUnifiedGatewayStatusAsyncRetry>d__a.MoveNext()

v-ljerr-msft · ‎08-16-2016

@josem

According to the official documentation Troubleshooting the On-Premises Data Gateway:

Error: Power BI service reported local gateway as unreachable. Please restart the gateway and try again.
At the end of configuration, the Power BI service will be called again to validate the gateway. The Power BI service does not report the gateway as live. Restarting the windows service may allow the communication to be successful. You can collect, and review, the logs as mentioned above to get more details.

So please update the gateway into latest version, restart the gateway and try again. Following is how we can restart the gateway from the command prompt:

On the machine where the enterprise gateway is running, launch an admin command prompt.
Use the following command to stop the service.
net stop PBIEgwService
Use the following command to start the service.
net start PBIEgwService