none
VSTOInstaller.exe taking lot of time to start RRS feed

  • Question

  • Hi All,

    I've an excel add-in developed using office 2007 PIAs and vsto 3.0. The deployment was click once.

    When i click .vsto to install the customization, lot of time being taken to show the customization dialog with 'Install' and 'Dont Install' buttons. Installation goes fine. Even, it will lot of time when i do cancel on the customization dialog.

    It takes almost 4 mins to load the customization (till that time it shows a progress bar on the dialog) and takes same time to when cancelled. When cancelled, the dialog gets closed immediately but the VSTOInstaller.exe process takes 4 mins to complete.

    Its Windows 7 OS, 2GB RAM Virtualmachine,
    - Only Office Excel 2007 (not full office pack) is installed
    - VSTO 3.0 runtime is installed

    I guess this issue is not related to the add-in code or any deployment issues because the same customization completes immediately (max 15 seconds) on other environments (like Win server 2008 VM, 2GB RAM, office excel 2007).

    Any idea why its taking that much time, are there any issues with environment or any other?

    Thanks,
    Venkat.

    Wednesday, February 2, 2011 10:02 AM

Answers

  • Hi Venkat,

    a common problem is that the certificate needs to be checked before an AddIn is loaded.

    When the Option Check for certificate revokation is enabled in IE settings, this can take a lot of time.
    I would suggest to disable this setting and the try again.

    Greets - Helmut


    Helmut Obertanner [http://www.x4u.de] [http://www.outlooksharp.de]
    Thursday, February 3, 2011 7:15 AM
    Answerer
  • Hello venkat,

    ~yes sure there is a risk.

    It depends on

    -how often will be a certificate revoked?

    -Do you install Software that is signed using a revoked certificate?

    -Do you use Software that is signed by a revoked certificate

    -It's possible to access an encrypted Webpage that is displayed as "Valid"

    I think it takes a lot time because form your VM you have no or slow access to DNS Servers and the Internet.

    Give this machine full access and the possibility to reach the certificate servers may speed up everything.

    - non genuine - ? I don't know - don't belive so. I think it's just DNS and access to certificate servers.

    Greets - Helmut


    Helmut Obertanner [http://www.x4u.de] [http://www.outlooksharp.de]
    Thursday, February 3, 2011 12:48 PM
    Answerer

All replies

  • Hi Venkat,

    a common problem is that the certificate needs to be checked before an AddIn is loaded.

    When the Option Check for certificate revokation is enabled in IE settings, this can take a lot of time.
    I would suggest to disable this setting and the try again.

    Greets - Helmut


    Helmut Obertanner [http://www.x4u.de] [http://www.outlooksharp.de]
    Thursday, February 3, 2011 7:15 AM
    Answerer
  • Thanks Helmut, that solved the problem. Now it takes ~30seconds which is fine.

    But, i've read that the 'check for certificate revoke' verifies that the issuing CA has not revoked the publisher's certificate.

    Is there any harm if i turn it off, atleast while installing the customization?

    Also, i found that, the OS installed on the VMs is not genuine. Can this also be a reason for the issue? because the above said option is checked in IE settings of other servers (genuine OS) where the customization works fast.

    Thanks,

    Venkat.

    Thursday, February 3, 2011 12:38 PM
  • Hello venkat,

    ~yes sure there is a risk.

    It depends on

    -how often will be a certificate revoked?

    -Do you install Software that is signed using a revoked certificate?

    -Do you use Software that is signed by a revoked certificate

    -It's possible to access an encrypted Webpage that is displayed as "Valid"

    I think it takes a lot time because form your VM you have no or slow access to DNS Servers and the Internet.

    Give this machine full access and the possibility to reach the certificate servers may speed up everything.

    - non genuine - ? I don't know - don't belive so. I think it's just DNS and access to certificate servers.

    Greets - Helmut


    Helmut Obertanner [http://www.x4u.de] [http://www.outlooksharp.de]
    Thursday, February 3, 2011 12:48 PM
    Answerer