1270414 - Reports on computers with no internet connection take up to 3 minutes to load

SAP Knowledge Base Article - Public

1270414 - Reports on computers with no internet connection take up to 3 minutes to load

Symptom

  • When a report is loaded is takes between 150 - 180 seconds to display
  • This is only reproducible on computers with no internet connection
  • There are no error messages and the report comes up eventually

Reproducing the Issue

  • Create a Windows application with the following function calls:

          new Report()

         report.SetDataSource(dataSet)

The function SetDataSource takes 2 plus minutes to execute

Cause

  • On SetDataSource() an attempt is made to connect to crl.verisign.com
  • SetDataSource() uses the framework and as per the Microsoft Knowledge Base specified under "Resolution", it is actually the framework that is attempting the connection

Resolution

  • Solution is described in this Microsoft Knowlege Base:

http://support.microsoft.com/kb/936707

  • The following Microsoft article also discusses the issue:

http://msdn.microsoft.com/en-us/library/bb629393.aspx 

  • An alternative workaround to the above is as follows:
  • Open IE and go to the Tools menu and select Internet Options...
  • Go to the Advanced tab
  • Find the Security heading
  • Under the Security heading find "Check for publisher's certificate revocation"
  • Uncheck this option

Keywords

long time load crl.verisign.com certificate revoked internet , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem

Product

Crystal Reports 2008 V1