locked
app-v client 5.0 sp2 for RDS, Excel 2007, ESSBase add-in, win 2012 server R2 Excel crashes RRS feed

  • Question

  • Hi,
    I'm trying to make following work (with no success for now). 

    Issue
    > Excel crashed when It loads the ESSBase’s (xla or xll) add-in.

    For the purpose of my tests, I’m handling the app-v packages using the powershell commandlets
    (no SCCM / no App-V Infrastructure)

    Environment
    On top of a Win 2012 r2 remote desktop session host server, I :
    - installed App-V 5.0 SP2 client for RDS
    - (added/published globally) Excel as a packaged app-v app
    - (added/published globally) ESSBase as a packaged app-v app 
    - (added/Enabled it Globally) a Connection Group (witch includes both the above appv packages)

    Connection group’s XML looks like below :

     


    Commandlets I'm using :
     

    import-module appvclient


    #Add packages

     Add-AppvClientPackage -Path C:\ExcelEss\EXcel\EXcel.appv    
     -DynamicDeploymentConfiguration C:\ExcelEss\EXcel\Excel_DeploymentConfig.xml


     Add-AppvClientPackage -Path C:\ExcelEss\ESSBASE\ESSBASE.appv
     -DynamicDeploymentConfiguration C:\ExcelEss\ESSBASE\ESSBASE_DeploymentConfig.xml  

    #Publish packages Globally

     Publish-AppvClientPackage -Global -Name Excel

     Publish-AppvClientPackage -Global -Name ESSBASE

    #Publish Group

     Get-AppvClientPackage | Stop-AppvClientPackage

     Add-AppvClientConnectionGroup C:\ExcelEss\MyTestGroup1.xml | `
     Enable-AppvClientConnectionGroup -Global



    Any help please ?


    MCTS Windows Server Virtualization, Configuration

    Wednesday, December 24, 2014 12:38 PM

Answers

  • Issue fixed, details below

    Upgrade to App-V SP3
    *
    - upgrade of the App-V Client for RDS from version 5.0 SP2 to 5.0 SP3 (RDS VM)
    - uninstall of the App-V 5.0 SP2 sequencer and install of the App-V 5.0 sequencer SP3 
      (App-V Sequencer VM)

    Sequencing
    - Install/Sequencing of Excel 2007 as a 1st distinct App-V Package
    - Install/Sequencing of Oracle ESSBase  Excel Add-In as a 2nd distinct App-V Package
       > I chose type: Add-On or Plugin (second option)
          *this time I forced Oracle Add-In to install under C:\Prog~files (x86)\Oracle
              and no more under C:\Oracle  
    - *at the end of the add-In package’s sequencing phase I ensured to have mscomctl.ocx
       somewhere on the sequencer VM and then run a cmd then ‘regsvr32 mscomctl.ocx’

    when editing the Connection Group’s XML file, I updated the schema
    from
    xmlns=
    http://schemas.microsoft.com/appv/2010/virtualapplicationconnectiongroup

    to
    xmlns=
    http://schemas.microsoft.com/appv/2014/virtualapplicationconnectiongroup

    Explanation:
    http://technet.microsoft.com/en-us/library/dn858700.aspx#BKMK_update_schema_cg

    Deployment
    Add-AppvClientPackage -Path .\Excel\Excel.appv
    Add-AppvClientPackage -Path .\ESSBase\ESSBase.appv
    Publish-AppvClientPackage -Global ESSBase
    Publish-AppvClientPackage -Global Excel
    Add-AppvClientConnectionGroup -Path .\MyTestGroup1.xml
    Enable-AppvClientConnectionGroup –Global


    Although I modified couple of things at once (see red stars above) in this last attempt
    to make this work - I can't really distinguish what step fixed it but - I guess the upgrade to SP3 was a must do step anyway -

    Working !

    Thanks. 


    MCTS Windows Server Virtualization, Configuration

    Wednesday, December 31, 2014 1:53 PM
  • Is there a chance you set C:\Oracle  as PVAD the first time you sequenced the Addin (under SP2)? With SP3 PVAD is disabled by default, so the software is always installed to the VFS.
    Choosing the option "Add-On or Plugin" does not change anything, it just does not popup all gui's.

    Wednesday, December 31, 2014 4:41 PM

All replies

  • Hello,

    Does it not crash when installed natively on the same platform?

    Does it not crash when provided in a single package?


    Nicke Källén | The Knack| Twitter: @Znackattack

    Wednesday, December 24, 2014 12:57 PM
  • Hello,

    Does it not crash when installed natively on the same platform?

    Does it not crash when provided in a single package?


    Nicke Källén | The Knack| Twitter: @Znackattack

    Hi,

    so far I've tested the following scenarios :
    - Install Excel 2007 & The Oracle ESSBase Excel Add-In both locally - work fine

    - Sequence both Packages separately - deploy both packages in a connection Group 
    => Excel crashes when trying to register the Add-On

    - Install Full Excel on the sequencer - started the sequencer & sequenced the Add-In chosing that the primary app was already installed (excel) then deployed that Package on target test machine having already Full Excel
    => Excel crashes when trying to register the Add-On

    I did followed Microsoft's How to Sequence a New Application with App-V 5.0  for the Add-On
    I'm sure this has to do with the sequencing steps or the XML but what ?

    The crash code thrown after importing the .xla or .xll add-in file into Excel :


    Signature du problème :


      Nom d’événement de problème: APPCRASH

      Nom de l’application: EXCEL.EXE

      Version de l’application: 12.0.6611.1000

      Horodatage de l’application: 4e5d44a0

      Nom du module par défaut: StackHash_c6d5

      Version du module par défaut: 6.3.9600.17031

      Horodateur du module par défaut: 5308893d

      Code de l’exception: c0000374

      Décalage de l’exception: PCH_73_FROM_ntdll+0x0003D72C

      Version du système: 6.3.9600.2.0.0.16.7

      Identificateur de paramètres régionaux: 1036

      Information supplémentaire n° 1: c6d5

      Information supplémentaire n° 2: c6d5b06a0eb227fee7e36a882377a6a2

      Information supplémentaire n° 3: 4d57

      Information supplémentaire n° 4: 4d577360a6f9fc51dad0df9578afb253


    MCTS Windows Server Virtualization, Configuration

    Friday, December 26, 2014 8:44 AM
  • Issue fixed, details below

    Upgrade to App-V SP3
    *
    - upgrade of the App-V Client for RDS from version 5.0 SP2 to 5.0 SP3 (RDS VM)
    - uninstall of the App-V 5.0 SP2 sequencer and install of the App-V 5.0 sequencer SP3 
      (App-V Sequencer VM)

    Sequencing
    - Install/Sequencing of Excel 2007 as a 1st distinct App-V Package
    - Install/Sequencing of Oracle ESSBase  Excel Add-In as a 2nd distinct App-V Package
       > I chose type: Add-On or Plugin (second option)
          *this time I forced Oracle Add-In to install under C:\Prog~files (x86)\Oracle
              and no more under C:\Oracle  
    - *at the end of the add-In package’s sequencing phase I ensured to have mscomctl.ocx
       somewhere on the sequencer VM and then run a cmd then ‘regsvr32 mscomctl.ocx’

    when editing the Connection Group’s XML file, I updated the schema
    from
    xmlns=
    http://schemas.microsoft.com/appv/2010/virtualapplicationconnectiongroup

    to
    xmlns=
    http://schemas.microsoft.com/appv/2014/virtualapplicationconnectiongroup

    Explanation:
    http://technet.microsoft.com/en-us/library/dn858700.aspx#BKMK_update_schema_cg

    Deployment
    Add-AppvClientPackage -Path .\Excel\Excel.appv
    Add-AppvClientPackage -Path .\ESSBase\ESSBase.appv
    Publish-AppvClientPackage -Global ESSBase
    Publish-AppvClientPackage -Global Excel
    Add-AppvClientConnectionGroup -Path .\MyTestGroup1.xml
    Enable-AppvClientConnectionGroup –Global


    Although I modified couple of things at once (see red stars above) in this last attempt
    to make this work - I can't really distinguish what step fixed it but - I guess the upgrade to SP3 was a must do step anyway -

    Working !

    Thanks. 


    MCTS Windows Server Virtualization, Configuration

    Wednesday, December 31, 2014 1:53 PM
  • Is there a chance you set C:\Oracle  as PVAD the first time you sequenced the Addin (under SP2)? With SP3 PVAD is disabled by default, so the software is always installed to the VFS.
    Choosing the option "Add-On or Plugin" does not change anything, it just does not popup all gui's.

    Wednesday, December 31, 2014 4:41 PM
  • Is there a chance you set C:\Oracle  as PVAD the first time you sequenced the Addin (under SP2)? With SP3 PVAD is disabled by default, so the software is always installed to the VFS.
    Choosing the option "Add-On or Plugin" does not change anything, it just does not popup all gui's.

    Hi
    yes Infact, the first time I sequenced the plugin, I set it's PVAD as c:\oracle as that path
    was the default already set in the installer wizard.

    Thanks.


    MCTS Windows Server Virtualization, Configuration

    Friday, January 2, 2015 9:05 AM