Code

Re: Code + Form = Form Loads very slow

sirwally — Fri, 02 Mar 2012 19:16:27 GMT

A little more detail behind a possible cause for this problem is here: http://blogs.msdn.com/b/alimaz/archive/2008/10/16/check-for-publisher-s-certificate-revocation-slowing-down-sharepoint.aspx. It turns out that the .NET runtime must verify that the certificate has not been revoked by communicating with CRL.MICROSOFT.COM. If your server cannot communicate with it (perhaps internet access has been disabled) then you will take a huge hit waiting for the inevitable timeout.

Hope that helps other that run into this problem.

Re: Code + Form = Form Loads very slow

sirwally — Fri, 02 Mar 2012 01:21:44 GMT

Even a self-signed certificate (like the one created in InfoPath) can be installed and used on client machines. The user simply needs to install it when opening the form, and I have done this a few times in the past when signed certificates just wasn't an option. However, user's may be scared by what they have to agree to when they install a self-signed certificate, so you will have to tell them it is OK while not being complacent about such security concerns. In an enterprise you probably don't want to do this and opt for a signed certificate from a valid authority. This could either be a certificate from an organization such as Thawt or Verisign, or it could be generated by the enterprise itself via a product such as Microsoft Certificate Server.

I had the same problem you had regarding a C# project and slow form load times. I have developed numerous forms before, mostly C# and I have never run into this. However, we have a complex, global network with numerous domains, and a somewhat convoluted path for access and authentication. The form is installed in a SharePoint server in one domain, the certificate technically comes from a different domain (albeit a parent domain) and access is currently provided via Citrix in yet another domain. We figured after a few hours of troublshooting that the problem was some sort of authentication issue and I suspected it had something to do with the certificate verification, but wasn't sure exactly where to look. Thanks to this post I now know, but I fear that it may not be acceptable for have users disable the option mentioned. Having said that, I am pretty sure it would be more difficult to address the network issues...Ah, the joys of enterprise computing!

UPDATE: I just noticed the date on the previous post...I don't expect to get a response :-)

Re: Code + Form = Form Loads very slow

BoZo86 — Wed, 26 Jan 2011 16:16:14 GMT

Thank you for the information, but how can I install/create a certifcate that every client can use it?

I think the certificate which can be created in InfoPath, is only a test certificate.. It is the first time that I'm working with certifcates.. Sorry..

Note: This will be a Document Information Panel (DIP)

Re: Code + Form = Form Loads very slow

Potemkine — Wed, 26 Jan 2011 03:46:54 GMT

Hi, the client will be able to use the certificate you've create with Infopath out of box code signing and if they install it the message will not be prompt anymore. Infopath out of box code signing certificate doesn’t allow the certificate’s private key to be exported it means that only the user who create the certificate can use it. In your case it's not a problem.

I already develop form on this kind of setup and I didn't have any certificate issue.

Re: Code + Form = Form Loads very slow

BoZo86 — Tue, 25 Jan 2011 17:38:40 GMT

hmm.. my problem is, i am developing on a developer client. The certificate uses my information. But the certifcate must be taken to the server, where the applications should be stored and run from there in other clients. Should i install the certificate only on the server or should i roll-out it via AD on every Client?

Re: Code + Form = Form Loads very slow

Potemkine — Tue, 25 Jan 2011 13:26:05 GMT

Hi, normally you can use this kind of certificate. Can you verify that your certificate is on trusted root certification authorities group?

http://kbalertz.com/867441/error-occur-signed-solutions-using-method-Office-InfoPath-Service.aspx

Re: Code + Form = Form Loads very slow

BoZo86 — Tue, 25 Jan 2011 12:20:03 GMT

hi Potemkine, i know only to create the own certificate. How can i take or create a global certificate that it can be used for every workstation?

Re: Code + Form = Form Loads very slow

Potemkine — Fri, 21 Jan 2011 15:07:51 GMT

Hi, have you sign your form yourself and what kind of certificate do you use?

if you use a valid code signing certificate deliver for instance by a domain certificate server the .NET CLR loads a code-signed assembly and will be able to reach the

CRL distribution point and your form will load quickly on the domain.

Re: Code + Form = Form Loads very slow

BoZo86 — Fri, 21 Jan 2011 13:47:52 GMT

I found the problem. The Client tries to check the CRL (Certificate Revocation List) so it will take a long time.

To disable this:
Internet Setting --> Advanced --> Check for publisher's certificate revocation (DISABLE)

After that, it will not check for any certificates. But here i've got a question, my Code wants to take information from the Computer (Domain\Username), so i think it will need a certificate to execude it on other workstations? Do I need a workaround for this?

Re: Code + Form = Form Loads very slow

Potemkine — Fri, 21 Jan 2011 02:31:41 GMT

And if you try to design a brand new form with code ?

Re: Code + Form = Form Loads very slow

BoZo86 — Thu, 20 Jan 2011 22:48:35 GMT

I tried it with new installed Office 2007 Professional Plus, it is the same. :((
I took every code out and pasted in again but it is the same result...

Re: Code + Form = Form Loads very slow

BoZo86 — Thu, 20 Jan 2011 21:59:06 GMT

The same... It doesn't matter if you delete the code. It is enough to have a C# Project. It takes again so much time

Now I'm uninstalling Office 2007 Professional Plus and will re-install it.

Re: Code + Form = Form Loads very slow

Potemkine — Thu, 20 Jan 2011 21:40:42 GMT

It sounds a little weird ! Can you try this :

try to create a code project, load VSTA (don't put any code) and tell us how fast it is?

try to do the same but on another computer if it's possible.

Re: Code + Form = Form Loads very slow

BoZo86 — Thu, 20 Jan 2011 21:32:49 GMT

Right potemkine, I've removed the Code and it works fast.

But how can I use the Code and run it fast?

Re: Code + Form = Form Loads very slow

Potemkine — Thu, 20 Jan 2011 21:29:38 GMT

Hi, your C# project is not so big and when a client load your form he just load a Dll include on your form template. Can you make a copy of the code and remove the code from "form options", "programming".

And tell us if your form load quickly ?