Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

PowerBI Personal Gateway install error - Sequence contains no elements

Hi folks 

Can't seem to install the latest update of the Personal Gateway... To be honest I find this the flakiest and weakest element of PowerBI. Everytime theres a new version I have to uninstall the old version and install the new one three or four times before it works. This time it fails completely. Always dread this update.

 

I get to the "Please wait while we check a few more things" message and then I get a " Sequence contains no elements" error and the whole install hangs.

 

Can anyone shed any light on this as it could be a deal breaker for us using this product?

 

Cheers

J

 

 

 

 

12 Replies

  • I'm also having problems with a recent install attempt of the Persaonal Gateway.  Both our dev and prod machines has the AS Connector installed.  After uninstalling the AS connector and then installing the personal gateway (on BOTH dev and prod machines), the Power BI Personal Gateway confgurator starts on the "Please wait while we check a few more things." and then reads "Time out when registering gateway." at the bottom.  I can't go anywhere from this screen and have hence never been able to configure the gateway.

     

    Also, I've tried uninstalling the Gateway from both Dev and Prod, and it fails with the following message in the log.  Any help would be greatly apprecaited.

     

    === Verbose logging started: 11/26/2015  16:05:48  Build type: SHIP UNICODE 5.00.9600.00  Calling process: C:\Users\Mike.Cornell\AppData\Local\Package Cache\{7fcc8644-e8c0-49b4-912a-c189c1400ddb}\PowerBIGateway-usermode-prod.exe ===
    MSI (c) (C8:10) [16:05:48:373]: Resetting cached policy values
    MSI (c) (C8:10) [16:05:48:373]: Machine policy value 'Debug' is 0
    MSI (c) (C8:10) [16:05:48:373]: ******* RunEngine:
               ******* Product: {351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}
               ******* Action:
               ******* CommandLine: **********
    MSI (c) (C8:10) [16:05:48:373]: Client-side and UI is none or basic: Running entire install on the server.
    MSI (c) (C8:10) [16:05:48:373]: Grabbed execution mutex.
    MSI (c) (C8:10) [16:05:48:377]: Cloaking enabled.
    MSI (c) (C8:10) [16:05:48:378]: Attempting to enable all disabled privileges before calling Install on Server
    MSI (c) (C8:10) [16:05:48:380]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (68:E0) [16:05:48:385]: Running installation inside multi-package transaction {351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}
    MSI (s) (68:E0) [16:05:48:385]: Grabbed execution mutex.
    MSI (s) (68:4C) [16:05:48:387]: Resetting cached policy values
    MSI (s) (68:4C) [16:05:48:387]: Machine policy value 'Debug' is 0
    MSI (s) (68:4C) [16:05:48:387]: ******* RunEngine:
               ******* Product: {351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}
               ******* Action:
               ******* CommandLine: **********
    MSI (s) (68:4C) [16:05:48:387]: Machine policy value 'DisableUserInstalls' is 0
    MSI (s) (68:4C) [16:05:48:422]: Note: 1: 2203 2: C:\Windows\Installer\inprogressinstallinfo.ipi 3: -2147287038
    MSI (s) (68:4C) [16:05:48:422]: SRSetRestorePoint skipped for this transaction.
    MSI (s) (68:4C) [16:05:48:423]: MSCOREE not loaded loading copy from system32
    MSI (s) (68:4C) [16:05:48:426]: End dialog not enabled
    MSI (s) (68:4C) [16:05:48:427]: Original package ==> C:\Windows\Installer\6742fe9d.msi
    MSI (s) (68:4C) [16:05:48:427]: Package we're running from ==> C:\Windows\Installer\6742fe9d.msi
    MSI (s) (68:4C) [16:05:48:427]: APPCOMPAT: Uninstall Flags override found.
    MSI (s) (68:4C) [16:05:48:427]: APPCOMPAT: Uninstall VersionNT override found.
    MSI (s) (68:4C) [16:05:48:427]: APPCOMPAT: Uninstall ServicePackLevel override found.
    MSI (s) (68:4C) [16:05:48:427]: APPCOMPAT: looking for appcompat database entry with ProductCode '{351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}'.
    MSI (s) (68:4C) [16:05:48:427]: APPCOMPAT: no matching ProductCode found in database.
    MSI (s) (68:4C) [16:05:48:433]: Note: 1: 2262 2: File 3: -2147287038
    MSI (s) (68:4C) [16:05:48:434]: Note: 1: 2205 2:  3: MsiFileHash
    MSI (s) (68:4C) [16:05:48:434]: Machine policy value 'DisablePatch' is 0
    MSI (s) (68:4C) [16:05:48:434]: Machine policy value 'AllowLockdownPatch' is 0
    MSI (s) (68:4C) [16:05:48:434]: Machine policy value 'DisableMsi' is 1
    MSI (s) (68:4C) [16:05:48:434]: Machine policy value 'AlwaysInstallElevated' is 0
    MSI (s) (68:4C) [16:05:48:434]: User policy value 'AlwaysInstallElevated' is 0
    MSI (s) (68:4C) [16:05:48:434]: Product {351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26} is not managed.
    MSI (s) (68:4C) [16:05:48:434]: Rejecting product '{351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}': Non-assigned apps are disabled for non-admin users.
    MSI (s) (68:4C) [16:05:48:434]: Machine policy value 'DisableLUAPatching' is 0
    MSI (s) (68:4C) [16:05:48:434]: Machine policy value 'DisableFlyWeightPatching' is 0
    MSI (s) (68:4C) [16:05:48:434]: Note: 1: 2262 2: Media 3: -2147287038
    MSI (s) (68:4C) [16:05:48:435]: APPCOMPAT: looking for appcompat database entry with ProductCode '{351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}'.
    MSI (s) (68:4C) [16:05:48:435]: APPCOMPAT: no matching ProductCode found in database.
    MSI (s) (68:4C) [16:05:48:435]: Transforms are not secure.
    MSI (s) (68:4C) [16:05:48:435]: Note: 1: 2205 2:  3: Control
    MSI (s) (68:4C) [16:05:48:435]: PROPERTY CHANGE: Adding MsiLogFileLocation property. Its value is 'C:\Users\MIKE~1.COR\AppData\Local\Temp\Power_BI_Personal_Gateway_20151126160546_0_ServiceCallsPerUserPackage.msi.log'.
    MSI (s) (68:4C) [16:05:48:435]: Command Line: ARPSYSTEMCOMPONENT=1 MSIFASTINSTALL=7 INSTALLLOCATION=C:\Users\Mike.Cornell\AppData\Local\Power BI Personal Gateway REBOOT=ReallySuppress IGNOREDEPENDENCIES=ALL REMOVE=ALL CURRENTDIRECTORY=C:\Windows\system32 CLIENTUILEVEL=3 MSICLIENTUSESEXTERNALUI=1 CLIENTPROCESSID=79560
    MSI (s) (68:4C) [16:05:48:435]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{903BD328-0DB6-4A53-B25A-E158BA90A984}'.
    MSI (s) (68:4C) [16:05:48:435]: Product Code passed to Engine.Initialize:           '{351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}'
    MSI (s) (68:4C) [16:05:48:435]: Product Code from property table before transforms: '{351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}'
    MSI (s) (68:4C) [16:05:48:435]: Product Code from property table after transforms:  '{351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}'
    MSI (s) (68:4C) [16:05:48:435]: Product registered: entering maintenance mode
    MSI (s) (68:4C) [16:05:48:435]: Determined that existing product (either this product or the product being upgraded with a patch) is installed per-user.
    MSI (s) (68:4C) [16:05:48:435]: Product {351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26} is not managed.
    MSI (s) (68:4C) [16:05:48:435]: Machine policy value 'AlwaysInstallElevated' is 0
    MSI (s) (68:4C) [16:05:48:435]: User policy value 'AlwaysInstallElevated' is 0
    MSI (s) (68:4C) [16:05:48:435]: MSI_LUA: Package is marked as LUA installation capable with no elevation required
    MSI (s) (68:4C) [16:05:48:435]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'.
    MSI (s) (68:4C) [16:05:48:436]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'.
    MSI (s) (68:4C) [16:05:48:436]: Package name retrieved from configuration data: 'ServiceCallsPerUserPackage.msi'
    MSI (s) (68:4C) [16:05:48:436]: Note: 1: 2205 2:  3: Error
    MSI (s) (68:4C) [16:05:48:438]: Note: 1: 2262 2: AdminProperties 3: -2147287038
    MSI (s) (68:4C) [16:05:48:438]: Machine policy value 'AlwaysInstallElevated' is 0
    MSI (s) (68:4C) [16:05:48:438]: User policy value 'AlwaysInstallElevated' is 0
    MSI (s) (68:4C) [16:05:48:438]: Product {351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26} is not managed.
    MSI (s) (68:4C) [16:05:48:438]: Rejecting product '{351D6181-07E8-4AF7-8F0A-5EB7E5BF7B26}': Non-assigned apps are disabled for non-admin users.
    MSI (s) (68:4C) [16:05:48:439]: Note: 1: 1729
    MSI (s) (68:4C) [16:05:48:439]: Product: ServiceCalls -- Configuration failed.

    MSI (s) (68:4C) [16:05:48:439]: Windows Installer reconfigured the product. Product Name: ServiceCalls. Product Version: 1.8.5795.1. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 1625.

    MSI (s) (68:4C) [16:05:48:440]: MainEngineThread is returning 1625
    MSI (s) (68:E0) [16:05:48:440]: No System Restore sequence number for this installation.
    Info 1625.This installation is forbidden by system policy. Contact your system administrator.
    C:\Windows\Installer\6742fe9d.msi
    MSI (s) (68:E0) [16:05:48:441]: User policy value 'DisableRollback' is 0
    MSI (s) (68:E0) [16:05:48:441]: Machine policy value 'DisableRollback' is 0
    MSI (s) (68:E0) [16:05:48:441]: Incrementing counter to disable shutdown. Counter after increment: 0
    MSI (s) (68:E0) [16:05:48:441]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (68:E0) [16:05:48:442]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
    MSI (s) (68:E0) [16:05:48:442]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (C8:10) [16:05:48:444]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (C8:10) [16:05:48:444]: MainEngineThread is returning 1625
    === Verbose logging stopped: 11/26/2015  16:05:48 ===

    • vasim07's avatar
      vasim07
      Icon for Helper I rankHelper I

      Are you sure, you have proper Administrative rights on your PC.

      Try - right click on the downloaded file and do "Run as Administrator".

      • Anonymous's avatar
        Anonymous
        Not applicable

        Please try to help. We all know how to right click and install as an admin. Please credit us with the basic trouble shooting know-how... Makes no difference. Uninstalling and reinstalling results in same non-descript error of "Sequence contains no elements" . This has been flakey from day one in my experience. Someone at Microsoft must be able to replicate this error as it has obviously been put there by a developer at some stage in the development of the app. 

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Still the same "Sequence contains no elements" error. Ticket logged with MS support who have not responded. We are a Microsoft Partner her in Northern Ireland and are Pro users of this product...

     

    Some assistance would be greatly appreciated Microsoft!

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      any fix available to address this Time out when registering gateway issue?

      • sboulanger's avatar
        sboulanger
        Icon for Helper I rankHelper I

        Hi Guys,

         

        I got the same problem and opens 2 tickets with microsoft without any results.

        Finally we tried to install the gateway with a different user that is a domain admin and it works. I have full right on this specific server but it seems it's not enough it really need a domain admin account. 

         

  • S_Thompson's avatar
    S_Thompson
    Regular Visitor

    I get this same issue. I've uninstalled the personal gateway and reinstalled it and I still see this message and the Personal Gateway fails to work. Please provide some assistance on this issue, or at least let us know that you're working on it.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

       

      I have also an open ticket with "Power BI Basic Support". They're still working on it.

       

      Loïs

      • Anonymous's avatar
        Anonymous
        Not applicable

        We solved the issue of being unable to uninstall using a tool called CCleaner, you can find it on CNET and others, be aware it's full of adware and cruft.

         

        But it worked!

         

        Also, make sure you clean out C:\Programdata\Microsoft\Data Transfer after any uninstall, just to ensure it's a fresh install.