Re: on-premise power bi intermittence

charlyrosero · ‎07-09-2018

I have the gateway configured for the daily update. but currently the connection is intermittent, constantly updates are disabled by the following error.

The gateway is installed on a server which never shuts down and keeps on-premise session open.

The server is also configured to browse the domain names suggested on the page https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

thanks for your help

v-shex-msft · ‎07-09-2018

Hi @charlyrosero,

I'd like some detail content to clarify your scenario.(e.g. refresh history, gateway log, datasource type, connection mode, data source credentials setting, proxy settings...)

Reference link:

Troubleshooting the On-premises data gateway

Configuring proxy settings for the On-premises data gateway

Spoiler

Tools for troubleshooting

Collecting logs from the gateway configurator

There are several logs you can collect for the gateway, and you should always start with the logs. The simplest way to collect logs after installing the gateway is through the user interface. In the On-premises data gateway user interface, select Diagnostics and then select the Export logs link near the bottom of the page, as shown in the following image.

On-prem-data-gateway-UI-logs

Installer logs

Copy

%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs

Copy

%localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log

On-premises data gateway service logs

Copy

C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log

Event Logs

The On-premises data gateway service event logs are present under Application and Services Logs.

On-prem-data-gateway-event-logs

Fiddler Trace

Fiddler is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

Refresh History

When using the gateway for scheduled refresh, Refresh History can help you see what errors have occurred, as well as provide useful data if you should need to create a support request. You can view both scheduled, as well as on demand, refreshes. Here is how you can get to the Refresh History.

In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.
In Settings for... > Schedule Refresh, select Refresh History.

Tools for troubleshootingCollecting logs from the gateway configuratorThere are several logs you can collect for the gateway, and you should always start with the logs. The simplest way to collect logs after installing the gateway is through the user interface. In the On-premises data gateway user interface, select Diagnostics and then select the Export logs link near the bottom of the page, as shown in the following image.Installer logsCopy%localappdata%\Temp\On-premises_data_gateway_*.logConfiguration logsCopy%localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.logOn-premises data gateway service logsCopyC:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.logEvent LogsThe On-premises data gateway service event logs are present under Application and Services Logs.Fiddler TraceFiddler is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.Refresh HistoryWhen using the gateway for scheduled refresh, Refresh History can help you see what errors have occurred, as well as provide useful data if you should need to create a support request. You can view both scheduled, as well as on demand, refreshes. Here is how you can get to the Refresh History.In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.In Settings for... > Schedule Refresh, select Refresh History.

BTW, did you update gateway to newest version?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

charlyrosero · ‎07-18-2018

Hi

thank you for your answers.

the gateway version is 14.16.6745.2 (June 2018)

the only error that I could detect is the highlight in red. I have attached the last log that I exported. if you can help me detecting any other error I would appreciate it!

DM.EnterpriseGateway Error: 0 : 2018-07-18T14:50:55.6774476Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 C5D40FCF [DM.GatewayCore] Swallowing non-fatal exception encountered during attempt 71/2147483647 for startup of Transfer service: System.ServiceModel.CommunicationException: Unable to reach wabi-south-central-us-relay14.servicebus.windows.net HTTP (80, 443) ---> System.AggregateException: One or more errors occurred. ---> System.ServiceModel.CommunicationException: Unable to connect to factory endpoint. -- Response:<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-88591">
<meta http-equiv="Refresh" content="1; URL=http://cms.coomeva.com.co/publicaciones.php?id=9147">
<meta name="GENERATOR" content="Mozilla/4.8 [en] (Windows NT 5.0; U) [Netscape]">
<title>Coomeva IT Security</title>
</head>
<body></body>
</html> ---> System.Net.WebException: The remote server returned an error: (403) Forbidden.
at System.Net.HttpWebRequest.GetResponse()
at Microsoft.ServiceBus.WebStream.CreateSession(Uri& endpointLocation1, Uri& endpointLocation2)
--- End of inner exception stack trace ---
at Microsoft.ServiceBus.WebStream.CreateSession(Uri& endpointLocation1, Uri& endpointLocation2)
at Microsoft.ServiceBus.WebStream.Connect()
at Microsoft.ServiceBus.WebStream.IsSupportingScheme(Uri factoryEndpointUri, Exception& exception)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.ServiceBus.NetworkDetector.DetectInternalConnectivityModeForHttp(Uri uri)
at Microsoft.ServiceBus.ConnectivityModeHelper.GetInternalConnectivityMode(ConnectivitySettings connectivitySettings, HttpConnectivitySettings httpConnectivitySettings, Uri uri)
at Microsoft.ServiceBus.ConnectivityModeConnectionElement..ctor(TokenProvider tokenProvider, SocketSecurityRole socketSecurityMode, BindingContext context, NameSettings nameSettings, ConnectivitySettings connectivitySettings, HttpConnectivitySettings httpConnectivitySettings, Nullable`1 sslProtocolOverride)
at Microsoft.ServiceBus.TcpRelayTransportBindingElement.BuildInnerBindingElement(BindingContext context)
at Microsoft.ServiceBus.TcpRelayTransportBindingElement.BuildChannelListener[TChannel](BindingContext context)
at System.ServiceModel.Channels.Binding.BuildChannelListener[TChannel](Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, BindingParameterCollection parameters)
at System.ServiceModel.Description.DispatcherBuilder.MaybeCreateListener(Boolean actuallyCreate, Type[] supportedChannels, Binding binding, BindingParameterCollection parameters, Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, ServiceThrottle throttle, IChannelListener& result, Boolean supportContextSession)
at System.ServiceModel.Description.DispatcherBuilder.BuildChannelListener(StuffPerListenUriInfo stuff, ServiceHostBase serviceHost, Uri listenUri, ListenUriMode listenUriMode, Boolean supportContextSession, IChannelListener& result)
at System.ServiceModel.Description.DispatcherBuilder.InitializeServiceHost(ServiceDescription description, ServiceHostBase serviceHost)
at System.ServiceModel.ServiceHostBase.InitializeRuntime()
at System.ServiceModel.ServiceHostBase.OnBeginOpen(TimeSpan timeout, AsyncCallback callback, Object state)
at System.ServiceModel.Channels.CommunicationObject.OpenAsyncResult.InvokeOpen()
at System.ServiceModel.Channels.CommunicationObject.OpenAsyncResult..ctor(CommunicationObject communicationObject, TimeSpan timeout, AsyncCallback callback, Object state)
at System.ServiceModel.Channels.CommunicationObject.BeginOpen(TimeSpan timeout, AsyncCallback callback, Object state)
at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<ExecuteRunnerIterationAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<StartRunnerAsync>d__14.MoveNext()
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:05.7035429Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 CAB8F9C3 [DM.GatewayCore] Attempting to create and start service host for 'Transfer service'
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:05.7035429Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 45ADCDD3 [DM.GatewayCore] Using configured 'Https' for ServiceBus ConnectivityMode
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:05.7035429Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 394043F7 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-south-central-us-relay14.servicebus.windows.net/3dec22a1-ecd7-4170-9fd8-186be62dc186/' with following binding configuration: {"ReliableSession":{"Enabled":false,"Ordered":true,"InactivityTimeout":"00:10:00"},"HostNameComparisonMode":0,"ConnectionMode":0,"TransferMode":0,"MaxBufferPoolSize":8500000,"MaxBufferSize":8500000,"MaxConnections":1500,"ListenBacklog":10,"IsDynamic":false,"MaxReceivedMessageSize":8500000,"ReaderQuotas":{"MaxStringContentLength":8192,"MaxArrayLength":16384,"MaxBytesPerRead":4096,"MaxDepth":32,"MaxNameTableCharCount":16384,"ModifiedQuotas":0},"Scheme":"sb","EnvelopeVersion":{"NextDestinationActorValue":"http://www.w3.org/2003/05/soap-envelope/role/next"},"Security":{"Mode":1,"RelayClientAuthenticationT..."}
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:06.2697280Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 E5F6199B [DM.GatewayCore] Ignoring Faulted event for 'Transfer service' because it happened before the service host was actually opened
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:06.2697280Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 9EA26F93 [DM.GatewayCore] Transfer service faulted
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:06.2697280Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 612F4B3D [DM.GatewayCore] Aborting service host for 'Transfer service' that failed to create
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:06.2697280Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 47CFB9DF [DM.GatewayCore] Transfer service aborted
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:06.2697280Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 294F8B2E [DM.GatewayCore] Transfer service closed
DM.EnterpriseGateway Error: 0 : 2018-07-18T14:51:06.2853522Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 07CB6792 [DM.GatewayCore] Swallowing non-fatal exception encountered during attempt 72/2147483647 for startup of Transfer service: System.ServiceModel.CommunicationException: Unable to reach wabi-south-central-us-relay14.servicebus.windows.net HTTP (80, 443) ---> System.AggregateException: One or more errors occurred. ---> System.ServiceModel.CommunicationException: Unable to connect to factory endpoint. -- Response:<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-88591">
<meta http-equiv="Refresh" content="1; URL=http://cms.coomeva.com.co/publicaciones.php?id=9147">
<meta name="GENERATOR" content="Mozilla/4.8 [en] (Windows NT 5.0; U) [Netscape]">
<title>Coomeva IT Security</title>
</head>
<body></body>
</html> ---> System.Net.WebException: The remote server returned an error: (403) Forbidden.
at System.Net.HttpWebRequest.GetResponse()
at Microsoft.ServiceBus.WebStream.CreateSession(Uri& endpointLocation1, Uri& endpointLocation2)
--- End of inner exception stack trace ---
at Microsoft.ServiceBus.WebStream.CreateSession(Uri& endpointLocation1, Uri& endpointLocation2)
at Microsoft.ServiceBus.WebStream.Connect()
at Microsoft.ServiceBus.WebStream.IsSupportingScheme(Uri factoryEndpointUri, Exception& exception)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.ServiceBus.NetworkDetector.DetectInternalConnectivityModeForHttp(Uri uri)
at Microsoft.ServiceBus.ConnectivityModeHelper.GetInternalConnectivityMode(ConnectivitySettings connectivitySettings, HttpConnectivitySettings httpConnectivitySettings, Uri uri)
at Microsoft.ServiceBus.ConnectivityModeConnectionElement..ctor(TokenProvider tokenProvider, SocketSecurityRole socketSecurityMode, BindingContext context, NameSettings nameSettings, ConnectivitySettings connectivitySettings, HttpConnectivitySettings httpConnectivitySettings, Nullable`1 sslProtocolOverride)
at Microsoft.ServiceBus.TcpRelayTransportBindingElement.BuildInnerBindingElement(BindingContext context)
at Microsoft.ServiceBus.TcpRelayTransportBindingElement.BuildChannelListener[TChannel](BindingContext context)
at System.ServiceModel.Channels.Binding.BuildChannelListener[TChannel](Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, BindingParameterCollection parameters)
at System.ServiceModel.Description.DispatcherBuilder.MaybeCreateListener(Boolean actuallyCreate, Type[] supportedChannels, Binding binding, BindingParameterCollection parameters, Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, ServiceThrottle throttle, IChannelListener& result, Boolean supportContextSession)
at System.ServiceModel.Description.DispatcherBuilder.BuildChannelListener(StuffPerListenUriInfo stuff, ServiceHostBase serviceHost, Uri listenUri, ListenUriMode listenUriMode, Boolean supportContextSession, IChannelListener& result)
at System.ServiceModel.Description.DispatcherBuilder.InitializeServiceHost(ServiceDescription description, ServiceHostBase serviceHost)
at System.ServiceModel.ServiceHostBase.InitializeRuntime()
at System.ServiceModel.ServiceHostBase.OnBeginOpen(TimeSpan timeout, AsyncCallback callback, Object state)
at System.ServiceModel.Channels.CommunicationObject.OpenAsyncResult.InvokeOpen()
at System.ServiceModel.Channels.CommunicationObject.OpenAsyncResult..ctor(CommunicationObject communicationObject, TimeSpan timeout, AsyncCallback callback, Object state)
at System.ServiceModel.Channels.CommunicationObject.BeginOpen(TimeSpan timeout, AsyncCallback callback, Object state)
at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<ExecuteRunnerIterationAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<StartRunnerAsync>d__14.MoveNext()
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.3036757Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 CAB8F9C3 [DM.GatewayCore] Attempting to create and start service host for 'Transfer service'
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.3036757Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 45ADCDD3 [DM.GatewayCore] Using configured 'Https' for ServiceBus ConnectivityMode
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.3036757Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 394043F7 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-south-central-us-relay14.servicebus.windows.net/3dec22a1-ecd7-4170-9fd8-186be62dc186/' with following binding configuration: {"ReliableSession":{"Enabled":false,"Ordered":true,"InactivityTimeout":"00:10:00"},"HostNameComparisonMode":0,"ConnectionMode":0,"TransferMode":0,"MaxBufferPoolSize":8500000,"MaxBufferSize":8500000,"MaxConnections":1500,"ListenBacklog":10,"IsDynamic":false,"MaxReceivedMessageSize":8500000,"ReaderQuotas":{"MaxStringContentLength":8192,"MaxArrayLength":16384,"MaxBytesPerRead":4096,"MaxDepth":32,"MaxNameTableCharCount":16384,"ModifiedQuotas":0},"Scheme":"sb","EnvelopeVersion":{"NextDestinationActorValue":"http://www.w3.org/2003/05/soap-envelope/role/next"},"Security":{"Mode":1,"RelayClientAuthenticationT..."}
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.9911792Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 E5F6199B [DM.GatewayCore] Ignoring Faulted event for 'Transfer service' because it happened before the service host was actually opened
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.9911792Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 9EA26F93 [DM.GatewayCore] Transfer service faulted
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.9911792Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 612F4B3D [DM.GatewayCore] Aborting service host for 'Transfer service' that failed to create
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.9911792Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 47CFB9DF [DM.GatewayCore] Transfer service aborted
DM.EnterpriseGateway Information: 0 : 2018-07-18T14:51:16.9911792Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 294F8B2E [DM.GatewayCore] Transfer service closed
DM.EnterpriseGateway Error: 0 : 2018-07-18T14:51:16.9911792Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 C7AADD51 [DM.GatewayCore] Swallowing non-fatal exception encountered during attempt 73/2147483647 for startup of Transfer service: System.ServiceModel.CommunicationException: Unable to reach wabi-south-central-us-relay14.servicebus.windows.net HTTP (80, 443) ---> System.AggregateException: One or more errors occurred. ---> System.ServiceModel.CommunicationException: Unable to connect to factory endpoint. -- Response:<html>