Unable to install On-Premise Data Gateway on Windows Server 2016

[ambarishkunte]

Hi,

We are Unable to install the latest available installer for On-Premise Data Gateway on Windows Server 2016 . We are using a proxy and followed the article https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-proxy However as soon as we make changes to the files to enter proxy details as mentioned in the article the service is unable to start.

Following errors are seen in the event viewer.

Under Source : Application Error

Faulting application name: EnterpriseGatewayConfigurator.exe, version: 3000.54.8.0, time stamp: 0x9831a26a
Faulting module name: KERNELBASE.dll, version: 10.0.14393.3659, time stamp: 0x5e9140ed
Exception code: 0xe0434352
Fault offset: 0x0000000000034f38
Faulting process id: 0x1888
Faulting application start time: 0x01d691a36e1ad3ee
Faulting application path: D:\On-premises data gateway\EnterpriseGatewayConfigurator.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report Id: 724fac14-c3a3-4676-b3c8-37a2a67c454c
Faulting package full name:
Faulting package-relative application ID:

Under Source: .Net RunTime

Application: EnterpriseGatewayConfigurator.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Xml.XmlException
at System.Xml.XmlTextReaderImpl.Throw(System.Exception)
at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData)
at System.Xml.XmlTextReaderImpl.ParseEndElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Configuration.XmlUtil.StrictSkipToNextElement(System.Configuration.ExceptionAction)
at System.Configuration.BaseConfigurationRecord.ScanSectionsRecursive(System.Configuration.XmlUtil, System.String, Boolean, System.String, System.Configuration.OverrideModeSetting, Boolean)
at System.Configuration.BaseConfigurationRecord.ScanSectionsRecursive(System.Configuration.XmlUtil, System.String, Boolean, System.String, System.Configuration.OverrideModeSetting, Boolean)
at System.Configuration.BaseConfigurationRecord.ScanSections(System.Configuration.XmlUtil)
at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()

Exception Info: System.Configuration.ConfigurationErrorsException
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(System.Configuration.ConfigurationSchemaErrors)
at System.Configuration.ClientConfigurationSystem.EnsureInit(System.String)

Exception Info: System.Configuration.ConfigurationErrorsException
at System.Configuration.ConfigurationManager.PrepareConfigSystem()
at System.Configuration.ConfigurationManager.GetSection(System.String)
at System.Configuration.PrivilegedConfigurationManager.GetSection(System.String)
at System.Diagnostics.DiagnosticsConfiguration.GetConfigSection()
at System.Diagnostics.DiagnosticsConfiguration.Initialize()
at System.Diagnostics.DiagnosticsConfiguration.get_IndentSize()
at System.Diagnostics.TraceInternal.InitializeSettings()
at System.Diagnostics.TraceInternal.TraceEvent(System.Diagnostics.TraceEventType, Int32, System.String, System.Object[])
at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.MainWindow..ctor()

Exception Info: System.Windows.Markup.XamlParseException
at System.Windows.Markup.XamlReader.RewrapException(System.Exception, System.Xaml.IXamlLineInfo, System.Uri)
at System.Windows.Markup.WpfXamlLoader.Load(System.Xaml.XamlReader, System.Xaml.IXamlObjectWriterFactory, Boolean, System.Object, System.Xaml.XamlObjectWriterSettings, System.Uri)
at System.Windows.Markup.WpfXamlLoader.LoadBaml(System.Xaml.XamlReader, Boolean, System.Object, System.Xaml.Permissions.XamlAccessLevel, System.Uri)
at System.Windows.Markup.XamlReader.LoadBaml(System.IO.Stream, System.Windows.Markup.ParserContext, System.Object, Boolean)
at System.Windows.Application.LoadBamlStreamWithSyncInfo(System.IO.Stream, System.Windows.Markup.ParserContext)
at System.Windows.Application.DoStartup()
at System.Windows.Application.<.ctor>b__1_0(System.Object)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
at System.Windows.Threading.DispatcherOperation.InvokeImpl()
at MS.Internal.CulturePreservingExecutionContext.CallbackWrapper(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Windows.Threading.DispatcherOperation.Invoke()
at System.Windows.Threading.Dispatcher.ProcessQueue()
at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
at MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)
at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr)
at MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef)
at System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame)
at System.Windows.Application.RunDispatcher(System.Object)
at System.Windows.Application.RunInternal(System.Windows.Window)
at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.App.Main()

Under Source : SidebySide

Activation context generation failed for "D:\On-premises data gateway\EnterpriseGatewayConfigurator.exe".Error in manifest or policy file "D:\On-premises data gateway\EnterpriseGatewayConfigurator.exe.Config" on line 18. Invalid Xml syntax.

Any assistance to resolve the issue ?

Regards,

Ambarish Kunte

[GilbertQ]

Can you confirm that you have edited the right file and that you got the right user?

It would appear that the config file is not 100% correct with the details entered?

[lbendlin]

uninstall the gateway, and reinstall on drive C:

Which files did you modify for your proxy settings?  Note that the file locations have changed recently, so provide full path.

[ambarishkunte]

Yes, we did observe the changes in the location of Mashup file which moved to the "/m" folder. Tried uninstalling and installing several times but issue persist.

Following are the files which were modified successfully. 

1. D:\On-premises data gateway\enterprisegatewayconfigurator.exe.config
2. D:\On-premises data gateway\Microsoft.PowerBI.EnterpriseGateway.exe.config
3. D:\On-premises data gateway\m\Microsoft.Mashup.Container.NetFX45.exe.config

As soon as we make the proxy changes in "1" or "2" config file , we are unable to launch the gateway & the errors pasted in the orginal post are observed in the event viewer. If we revert back the changes we are able to launch but without proxy modifications.

Please note : We already have 1 On-Prem gateway successfully installed on another machine but with an installer before April 2020.

Regards,

Ambarish Kunte

[lbendlin]

Looks ok apart from the D :  drive - personally I don't trust that.

For what it's worth here is my checklist of things to install and configure when standing up a new gateway cluster member:

.Net TCP Listener
IE Proxy
Trusted Sites
CMD proxy
.Net 4.8
VC_Redist
Turn off Smartscreen
Max Performance
Paging file to F:
Vertica 9.1.1
MySQL 8.0.21 ODBC
MySQL 8.0.21 /Net
Oracle
TNSNAMES.ORA
Hortonworks
Windows Update
Update Shortcut
Disable Firewall
CARoot cert
sharepoint
ODBC shortcut
ODBC registry
TLS1.2 registry
gateway installed
Installer shortcut
custom connector folder
gateway config shortcut
gateway proxy
gateway login

A recent addition is the multitude of trusted sites you need to add when allowing the gateway to refresh cloud data sources like sharepoint folders. Still getting angry just thinking about that.

[ambarishkunte]

Is there a way we could have the the previous installer available somewhere , just before April 2020.

We would like to test that .

[lbendlin]

That's a little pointless as the mashup engine will be mismatched.  Usually you want the desktop, service, and gateway mashup engines to do the same transforms.

But if you must, use your stored installer from pre-april to test.  Microsoft will also give you older installer versions on request (as part of a ticket process)

[ambarishkunte]

Unfortunately, the installer that we have pre-april is a Web installer , hence it downloads & install the latest available gateway.

Anything from the error that could help us troubleshoot the issue. 

[lbendlin]

Did you test installing in the default folder rather than on D : ?

[ambarishkunte]

Yes, No change !

[lbendlin]

Raise a ticket.