Power BI On-premises data gateway installation.

[jacobq]

Hi, is anyone could help to solve my issue with On-premises data gateway installation ?

I receive the error "On-premises data gateway installation has failed" and tell me to check the log, however I couldn't figure out why...  

Below is the log: 

=== Verbose logging started: 04/06/2019  9:54:27  Build type: SHIP UNICODE 5.00.7601.00  Calling process: C:\Users\jqiu1\AppData\Local\Temp\{12EB99EE-3F80-432D-9E8A-57A08814D8DD}\.be\On-premises data gateway.exe ===
MSI (c) (24:2C) [09:54:27:295]: Resetting cached policy values
MSI (c) (24:2C) [09:54:27:295]: Machine policy value 'Debug' is 0
MSI (c) (24:2C) [09:54:27:295]: ******* RunEngine:
           ******* Product: C:\ProgramData\Package Cache\{E7C6AFE7-DEAE-4842-A471-03E596756885}v15.5.185\DataMovement.GatewayComponents.msi
           ******* Action: 
           ******* CommandLine: **********
MSI (c) (24:2C) [09:54:27:295]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (24:2C) [09:54:27:295]: Grabbed execution mutex.
MSI (c) (24:2C) [09:54:27:297]: Cloaking enabled.
MSI (c) (24:2C) [09:54:27:297]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (24:2C) [09:54:27:297]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (AC:48) [09:54:27:300]: Running installation inside multi-package transaction C:\ProgramData\Package Cache\{E7C6AFE7-DEAE-4842-A471-03E596756885}v15.5.185\DataMovement.GatewayComponents.msi
MSI (s) (AC:48) [09:54:27:300]: Grabbed execution mutex.
MSI (s) (AC:08) [09:54:27:301]: Resetting cached policy values
MSI (s) (AC:08) [09:54:27:301]: Machine policy value 'Debug' is 0
MSI (s) (AC:08) [09:54:27:301]: ******* RunEngine:
           ******* Product: C:\ProgramData\Package Cache\{E7C6AFE7-DEAE-4842-A471-03E596756885}v15.5.185\DataMovement.GatewayComponents.msi
           ******* Action: 
           ******* CommandLine: **********
MSI (s) (AC:08) [09:54:27:674]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (AC:08) [09:54:27:768]: SRSetRestorePoint skipped for this transaction.
Property(S): dir65E446E022E2CAC8000F5A6BE7CFC7C3 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Impala ODBC Driver\saslGSSAPI\
Property(S): dir294B550D02754C0898C4139AD489F551 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Impala ODBC Driver\saslSSPI\
Property(S): dir76F3A6516B4445D64929F6C172CC17C6 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Impala ODBC Driver\sv-SE\
Property(S): dir46F0CDD9DA968A3410C23406BC1B2C3E = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Impala ODBC Driver\tr-TR\
Property(S): dir181A50CCF50B5A3D1F909EC7BC63B127 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Impala ODBC Driver\zh-CN\
Property(S): dir6B4B65A7F40E20E54E5E2DDE8E7D0AD9 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Impala ODBC Driver\zh-TW\
Property(S): dir8706DE649C8D24F9415F94887EA57B71 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Netezza ODBC Driver\
Property(S): dirB76F14C8916E86DA2637111421307E8B = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Netezza ODBC Driver\en-US\
Property(S): dir8AAF2869D8EE1116E2B1A3540F3DE1C4 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\
Property(S): dir8D8A10E424FF0B48B2800E115A366293 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\cs-CZ\
Property(S): dir69FC24C6D7D2CF181C96D79BC9A30B6D = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\de-DE\
Property(S): dir5E4208AD26962A962338237C22322847 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\en-US\
Property(S): dir33860B1D0F63FC741C1142D443FFD3CA = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\es-ES\
Property(S): dirCEE1E32464E276B5946A2AFB57F228E4 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\fr-FR\
Property(S): dir16DD7B646F6B19EDC36B5A5871CCC3E3 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\hu-HU\
Property(S): dirA5439CA14D0EF87771F9AE737AA5AA9B = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\it-IT\
Property(S): dir44CD0E1401ED96DAED21D820632CFF4D = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\ja-JP\
Property(S): dirC1D9AC8BF26258F97D582F08814D9E5B = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\ko-KR\
Property(S): dir419746A08336D1373DFED7CD9F9F1CB4 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\LibCurl64.DllA\
Property(S): dirAEE8DE76549AF4DFCC3C361EE9CC2007 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\LibCurl64.DllA\OpenSSL64.DllA\
Property(S): dirD4EED350280C3C11423DD3FB3E08F027 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\nl-NL\
Property(S): dir853EAF5C55A2A04B5DC26F4F704F804B = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\OpenSSL64.DllA\
Property(S): dir9D1B2EC11075C5F13E0314AB1AE4B35B = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\pl-PL\
Property(S): dir0653A6EB09A4F9F87900368B29D2638A = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\pt-BR\
Property(S): dir5AE64A1F1CA6E5DC5965176B5AACA8B7 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\pt-PT\
Property(S): dirA992C58BDDF8203FEBE7D9AE85AE8420 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\ru-RU\
Property(S): dir88C5128E526F8D73DA15469FF1E571BE = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\sasl2\
Property(S): dir486B82AB23727C2359D020EF54935AF9 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\saslGSSAPI\
Property(S): dirEA33762150615F44313D1D1B1AF17BF6 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\saslSSPI\
Property(S): dirDC66B75394C7EC94FD24C0A8A87A4C3C = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\sv-SE\
Property(S): dir8D3EFD8D0DA873078E2985CC0FE5B0CF = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\tr-TR\
Property(S): dir5D5B1A321ED68C3D48D43721291F51BA = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\zh-CN\
Property(S): dirBE533F7C6589E70426963BDF773AF13B = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Spark ODBC Driver\zh-TW\
Property(S): dirCF3F181B4D655AA120E4A1FFAB47BE9D = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Vertica ODBC Driver\
Property(S): dir1AC583252ACBDEFF221DE46E549CF391 = C:\Program Files\On-premises data gateway\ODBC Drivers\Simba Vertica ODBC Driver\en-US\
Property(S): dir02AEA1B34DA6754B436E25E7A3C332C0 = C:\Program Files\On-premises data gateway\pt-pt\
Property(S): dirBB6DB3C635E472AA58C237D247A8B33A = C:\Program Files\On-premises data gateway\Resources\1033\
Property(S): dirD6161CF1D9EE271DBE85D1F0B8329F4F = C:\Program Files\On-premises data gateway\sr-Cyrl\
Property(S): dirEAA091970954F2AB8C7185ABA993AA15 = C:\Program Files\On-premises data gateway\sr-Latn\
Property(S): dir7C2C83F6CC8AC47D9022A8AD6554F0C1 = C:\Program Files\On-premises data gateway\x64\
Property(S): dirE62C75B0DFC66B1F221D6A7BDE116F3B = C:\Program Files\On-premises data gateway\x86\
Property(S): RegisterPerfCounterData = **********
Property(S): RollbackRegisterPerfCounterData = **********
Property(S): ExecServiceConfig = SchedServiceConfig€PBIEgwService€1€restart€none€none€0€0€€
Property(S): RollbackServiceConfig = SchedServiceConfig
Property(S): ProgramFiles64Folder = C:\Program Files\
Property(S): SourceDir = C:\ProgramData\Package Cache\{E7C6AFE7-DEAE-4842-A471-03E596756885}v15.5.185\
Property(S): dir4DC39E28E88A7F1F26918FEF6A2132A1 = C:\Program Files\On-premises data gateway\Resources\
Property(S): ProgramMenuFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\
Property(S): VersionNT = 601
Property(S): ALLUSERS = 1
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductCode = {E7C6AFE7-DEAE-4842-A471-03E596756885}
Property(S): ProductLanguage = 1033
Property(S): ProductName = GatewayComponents
Property(S): ProductVersion = 15.5.185
Property(S): SecureCustomProperties = WIX_DOWNGRADE_DETECTED;WIX_UPGRADE_DETECTED
Property(S): MsiHiddenProperties = RegisterPerfCounterData;RollbackRegisterPerfCounterData;RollbackUnregisterPerfCounterData;UnregisterPerfCounterData
Property(S): MsiLogFileLocation = C:\Users\jqiu1\AppData\Local\Temp\On-premises_data_gateway_20190604095416_001_DataMovement.GatewayComponents.msi.log
Property(S): PackageCode = {08034DD5-4CC9-4ECE-9312-199C53C489CF}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): ARPSYSTEMCOMPONENT = 1
Property(S): MSIFASTINSTALL = 7
Property(S): SERVICEENVIRONMENT = prod
Property(S): REBOOT = ReallySuppress
Property(S): CURRENTDIRECTORY = C:\Users\jqiu1\Downloads
Property(S): CLIENTUILEVEL = 3
Property(S): MSICLIENTUSESEXTERNALUI = 1
Property(S): CLIENTPROCESSID = 1572
Property(S): VersionDatabase = 200
Property(S): VersionMsi = 5.00
Property(S): VersionNT64 = 601
Property(S): WindowsBuild = 7601
Property(S): ServicePackLevel = 1
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 1
Property(S): WindowsFolder = C:\windows\
Property(S): WindowsVolume = C:\
Property(S): System64Folder = C:\windows\system32\
Property(S): SystemFolder = C:\windows\SysWOW64\
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = C:\Users\jqiu1\AppData\Local\Temp\
Property(S): ProgramFilesFolder = C:\Program Files (x86)\
Property(S): CommonFilesFolder = C:\Program Files (x86)\Common Files\
Property(S): CommonFiles64Folder = C:\Program Files\Common Files\
Property(S): AppDataFolder = C:\Users\jqiu1\AppData\Roaming\
Property(S): FavoritesFolder = C:\Users\jqiu1\Favorites\
Property(S): NetHoodFolder = C:\Users\jqiu1\AppData\Roaming\Microsoft\Windows\Network Shortcuts\
Property(S): PersonalFolder = C:\Users\jqiu1\Documents\
Property(S): PrintHoodFolder = C:\Users\jqiu1\AppData\Roaming\Microsoft\Windows\Printer Shortcuts\
Property(S): RecentFolder = C:\Users\jqiu1\AppData\Roaming\Microsoft\Windows\Recent\
Property(S): SendToFolder = C:\Users\jqiu1\AppData\Roaming\Microsoft\Windows\SendTo\
Property(S): TemplateFolder = C:\ProgramData\Microsoft\Windows\Templates\
Property(S): CommonAppDataFolder = C:\ProgramData\
Property(S): LocalAppDataFolder = C:\Users\jqiu1\AppData\Local\
Property(S): MyPicturesFolder = C:\Users\jqiu1\Pictures\
Property(S): AdminToolsFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools\
Property(S): StartupFolder = C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup\
Property(S): StartMenuFolder = C:\ProgramData\Microsoft\Windows\Start Menu\
Property(S): DesktopFolder = C:\Users\Public\Desktop\
Property(S): FontsFolder = C:\windows\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): MsiAMD64 = 6
Property(S): Msix64 = 6
Property(S): Intel = 6
Property(S): PhysicalMemory = 32658
Property(S): VirtualMemory = 56009
Property(S): AdminUser = 1
Property(S): MsiTrueAdminUser = 1
Property(S): LogonUser = jqiu1
Property(S): UserSID = S-1-5-21-2792348667-40916348-2774707896-107930
Property(S): UserLanguageID = 4105
Property(S): ComputerName = T57-MJ03XC9Q
Property(S): SystemLanguageID = 4105
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 22
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): TextInternalLeading = 3
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 9:55:50
Property(S): Date = 04/06/2019
Property(S): MsiNetAssemblySupport = 4.6.1087.0
Property(S): MsiWin32AssemblySupport = 6.1.7601.17514
Property(S): RedirectedDllSupport = 2
Property(S): MsiRunningElevated = 1
Property(S): Privileged = 1
Property(S): USERNAME = Bank of Nova Scotia User
Property(S): COMPANYNAME = Bank of Nova Scotia
Property(S): DATABASE = C:\windows\Installer\bc73b00.msi
Property(S): OriginalDatabase = C:\ProgramData\Package Cache\{E7C6AFE7-DEAE-4842-A471-03E596756885}v15.5.185\DataMovement.GatewayComponents.msi
Property(S): UILevel = 2
Property(S): MsiUISourceResOnly = 1
Property(S): ACTION = INSTALL
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): INSTALLLEVEL = 1
Property(S): SOURCEDIR = C:\ProgramData\Package Cache\{E7C6AFE7-DEAE-4842-A471-03E596756885}v15.5.185\
Property(S): SourcedirProduct = {E7C6AFE7-DEAE-4842-A471-03E596756885}
Property(S): SERVICE_INSTALLED_WITH_DIFF_USER = 0
Property(S): ProductToBeRegistered = 1
MSI (s) (AC:08) [09:55:50:630]: Note: 1: 1708 
MSI (s) (AC:08) [09:55:50:630]: Product: GatewayComponents -- Installation failed.

MSI (s) (AC:08) [09:55:50:631]: Windows Installer installed the product. Product Name: GatewayComponents. Product Version: 15.5.185. Product Language: 1033. Manufacturer: Microsoft Corporation. Installation success or error status: 1603.

MSI (s) (AC:08) [09:55:50:653]: Deferring clean up of packages/files, if any exist
MSI (s) (AC:08) [09:55:50:654]: MainEngineThread is returning 1603
MSI (s) (AC:48) [09:55:50:656]: RESTART MANAGER: Session closed.
MSI (s) (AC:48) [09:55:50:656]: No System Restore sequence number for this installation.
=== Logging stopped: 04/06/2019  9:55:50 ===
MSI (s) (AC:48) [09:55:50:658]: User policy value 'DisableRollback' is 0
MSI (s) (AC:48) [09:55:50:658]: Machine policy value 'DisableRollback' is 0
MSI (s) (AC:48) [09:55:50:658]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (AC:48) [09:55:50:658]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
MSI (s) (AC:48) [09:55:50:658]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
MSI (s) (AC:48) [09:55:50:659]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (s) (AC:48) [09:55:50:659]: Restoring environment variables
MSI (s) (AC:48) [09:55:50:660]: Destroying RemoteAPI object.
MSI (s) (AC:70) [09:55:50:660]: Custom Action Manager thread ending.
MSI (c) (24:2C) [09:55:50:661]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (24:2C) [09:55:50:661]: MainEngineThread is returning 1603
=== Verbose logging stopped: 04/06/2019  9:55:50 ===

[v-xuding-msft]

Hi  @jacobq 

Please  check if your computer have meet the requirements for installing the On-premise data gateway. And  take a try to re-start your computer, and then re-install the latest vision of On-premise data gateway . More details about the requirements for installing the On-premise data gateway, please check the following article:

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

then check if the issue is solved.

Best Regards,

Xue Ding

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

[jacobq]

Hi @v-xuding-msft ,

I have checked and tried all the steps in the article, as well as have done other research. still can't resolve the issue.

Regards,

Jacob

[v-xuding-msft]

Hi @jacobq ,

More details about the troubleshooting for installing the On-premise data gateway, please check the following article:

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#installation

If you install failed again, please fill out a support ticket and you will be replied soon.

https://powerbi.microsoft.com/en-us/support/

Best Regards,

Xue Ding

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