Connection Error with On-Premises Data Gateway

[Leonardo8182]

Initially, the On-Premises Data Gateway was installed and running correctly, but it started showing connection errors. After extracting the logs from the program, I found the following error:

DM.EnterpriseGateway Error: 0 : 2025-01-08T02:05:36.1201080Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 3A73468E [DM.GatewayCore] Swallowing non-fatal exception encountered during attempt 1/2147483647 for startup of Transfer service: Microsoft.ServiceBus.RelayNotFoundException: Relay must be created at this address before using the binding with IsDynamic set to false. TrackingId:ed9c0b4d-9a3c-43ad-9762-fb4ffe1c51ca_G43, SystemTracker:wabi-brazil-south-b-primary-relay39.servicebus.windows.net:67570b6e-02df-46a5-9132-f642de43c151, Timestamp:2025-01-08T02:05:39 ---> Microsoft.ServiceBus.Messaging.Amqp.AmqpException: Relay must be created at this address before using the binding with IsDynamic set to false. TrackingId:ed9c0b4d-9a3c-43ad-9762-fb4ffe1c51ca_G43, SystemTracker:wabi-brazil-south-b-primary-relay39.servicebus.windows.net:67570b6e-02df-46a5-9132-f642de43c151, Timestamp:2025-01-08T02:05:39

I attempted to reinstall the gateway, but now I cannot configure it. The Windows Event Viewer displays the following error for the program:

Watch dog failed to start process. Exception System.AggregateException: One or more errors occurred. ---> System.ArgumentNullException: Value cannot be null. Parameter name: first at System.Linq.Enumerable.Zip[TFirst,TSecond,TResult](IEnumerable`1 first, IEnumerable`1 second, Func`3 resultSelector) at Microsoft.DataTransfer.DataProxyAgent.ProcessManagement.RemoteService.RemoteServiceEnvironment.<CreateServiceProxiesAsync>d__3.MoveNext() --- End of inner exception stack trace --- at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification) at Microsoft.DataTransfer.TridentIntegrationRuntime.Host.TridentIntegrationRuntimeInstanceOperations.set_Messenger(IMessenger value) at Microsoft.DataTransfer.TridentIntegrationRuntime.Host.Utils.TridentChildProcess.CreateProcess(Boolean isRestart) at Microsoft.DataTransfer.DataProxyAgent.ProcessManagement.SingleProcessWatchDog.WatchDogTask(SingleProcessWatchDog watchDog, CancellationToken token) ---> (Inner Exception #0) System.ArgumentNullException: Value cannot be null. Parameter name: first at System.Linq.Enumerable.Zip[TFirst,TSecond,TResult](IEnumerable`1 first, IEnumerable`1 second, Func`3 resultSelector) at Microsoft.DataTransfer.DataProxyAgent.ProcessManagement.RemoteService.RemoteServiceEnvironment.<CreateServiceProxiesAsync>d__3.MoveNext()<---

[Leonardo8182]

I reinstalled the gateway and the .NET Framework again, this time using version 4.8 instead of 4.8.1. This seems to have resolved the issue. Thank you!

[v-jianpeng-msft · Accepted solution]

Hi, @Leonardo8182 

Before reconfiguring the gateway, first make sure that the previous gateway has been completely uninstalled:

Then re-download the gateway installation file:

Power BI Gateway | Microsoft Power BI

During the installation process, make sure that the antivirus software is turned off:

Sign back in to your Power BI account:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.