I have encountered an issue with Excel being run via terminal services.
Launching Excel is very slow, 2 minutes if the Jet add-in is included, taken out, Excel launches immediately. I have confirmed the user has full access to the Jet license file, is there anywhere or anything else I should check.
The forums and knowledgebase focus on report speed
Thanks in advance
mpd57
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello!
Thanks for this information. Could you create a ticket on the Support Site (http://support.jetreports.com) for this?
It is VERY important for us to get support issues handled quickly and posting on the support site is the best way to ensure this.
Since you have been able to look through the KnowledgeBase, it would appear that you have already registered for the site.
Best Regards,
HP -
Jet Reports Historic Posts Hmmm, this sounds like an issue that I've encountered previously with a Citrix environment. Here is an article from our internal knowledge base that might address this issue:
Under certain network and user configurations, it can take a long time for Windows to verify the digital signatures of .NET assemblies, especially when running on Citrix. In these situations, it may take 1 – 2 minutes for Excel to open when the Jet Reports add-in is activated. It may also take a long time when closing the Data Sources dialog or when running a report before the Progress Window appears.
It appears that the issue has to do with Windows checking http://crl.microsoft.com to see if the digital signature is revoked. If either the machine has no network connection or the user’s permissions are locked down, this check times out (30 seconds timeout for each assembly it tries to load).
Microsoft has written a support article on this problem here:
http://support.microsoft.com/kb/936707
Resolutions:
There are two possible fixes for this issue. The solution we recommend is as follows:
Place an Excel config file in the Excel program folder (i.e. “C:\Program Files\Microsoft Office\Office12” for Excel 2007) which tells Windows not to check the digital signatures of .NET assemblies when running Excel.
An Excel config file with the necessary XML markup can be downloaded from our support site here: http://support.jetreports.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=81. If you already have an Excel config file, you’ll need to add the attached XML markup to it.
Additionally, the .NET Framework 2.0 Service Pack 1 or later needs to be installed in order for this to work. The installed versions of the .NET Framework can be checked in "Add or Remove Programs".
Please note that bypassing the checking of digital signatures could cause security issues. Hence this solution should only be attempted when long load times are preventing users from reasonably working with Excel.
Here is another possible solution for this problem. Though we recommend this solution less enthusiastically because it will prevent ALL programs from checking .NET siguatures:
1. Click the Menu Start->Run, type Control Panel, and click OK
2. Double click Internet Options
3. Navigate to the Tab Advanced
4. Uncheck the Check for publisher’s certificate revocation under Security section
Please sign in to leave a comment.