Report generation times out when you generate reports from large SQL stores with ISA Server 2000 (313990)


The information in this article applies to:

  • Microsoft Internet Security and Acceleration Server 2000
This article was previously published under Q313990
Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

SYMPTOMS

When you configure Internet Security and Acceleration Server 2000 (ISA) to log data to a SQL database, ISA Report generation may timeout and fail. You do not receive an error message. However, ISA Reports are blank.

CAUSE

The default query SQL timeout in ISA is 15 seconds. If your database has a large amount of data the query may timeout before it completes.

RESOLUTION

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk. To resolve this problem, use the following steps:
  1. Download and install the latest ISA Server service pack.

    For more information about the service pack, click the following article number to view the article in the Microsoft Knowledge Base:

    313139 How to obtain the latest Internet Security and Acceleration Server 2000 service pack

  2. Start Registry Editor (Regedt32.exe).
  3. Locate and click the following key in the registry:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fpc\Reports

  4. On the Edit menu, click Add Value, and then add the following registry value:

    Value name: DatabaseQueryTimeout
    Data type: REG_DWORD
    Radix: Decimal
    Value data: Type the number of seconds that you want to wait before a timeout occurs. By default, this value is set to 15 seconds.

  5. On the Edit menu, click Add Value, and then add the following registry value:

    Value name: NonSQLDatabase
    Data type: REG_DWORD
    Radix: Decimal
    Value data: 0 (zero)

  6. Quit Registry Editor.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem was corrected in ISA Server 2000 SP1.
Modification Type:MinorLast Reviewed:10/24/2005
Keywords:kbenv kbfix kbprb kbQFE KB313990
©2004 Microsoft Corporation. All rights reserved.