Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: "Query stopped because an error occurred while it was running" when you run a non-live query in Forefront Threat Management Gateway 2010 SP2

FIX: "Query stopped because an error occurred while it was running" when you run a non-live query in Forefront Threat Management Gateway 2010 SP2

View products that this article applies to.

Symptoms

You have Rollup 1 , Rollup 2 , or Rollup 3  installed in Microsoft Forefront Threat Management Gateway 2010 Service Pack 2 (SP2). However, when you run any non-live query (a historical query such as Last Hour, Last Week, and so on) against a logging database, the query doesn't run successfully. Additionally, you receive the following error message:

The query stopped because an error occurred while it was running.

↑ Back to the top

Cause

This problem occurs when the following conditions are true:
  • Logging uses either SQL Server Express or remote SQL Server.
  • Form-based authentication is used in Web Publishing rules.
  • There are too many concurrent incoming web requests hitting these rules.

A code change was introduced in Forefront Threat Management Gateway 2010 SP2 that causes Thread Local Storage (TLS) index exhaustion. This prevents the required loading of the libraries that are used for querying SQL Server logging databases.

↑ Back to the top

Resolution

To resolve this problem, install Rollup 4 for Forefront Threat Management Gateway (TMG) 2010 Service Pack 2.

↑ Back to the top

Status

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

↑ Back to the top

References

Learn about the terminology Microsoft uses to describe software updates.

↑ Back to the top

Keywords: kbnotautohotfix, kbqfe, kbfix, kbexpertiseinter, kbbug, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2863383
Revision : 1
Created on : 1/7/2017
Published on : 11/8/2013
Exists online : False
Views : 372