Microsoft KB Archive/313990

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

Article ID: 313990

Article Last Modified on 10/31/2006

-

APPLIES TO


 * Microsoft Internet Security and Acceleration Server 2000 Standard Edition

-



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:  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

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

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fpc\Reports

 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.

 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)

 Quit Registry Editor.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

This problem was corrected in ISA Server 2000 SP1.

Keywords: kbenv kbfix kbprb kbqfe KB313990

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.