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

Applies to: Microsoft Forefront Threat Management Gateway 2010 Service Pack 2Forefront Threat Management Gateway 2010 EnterpriseForefront Threat Management Gateway 2010 Standard More

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.

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.

Resolution


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

Status


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

References


Learn about the terminology Microsoft uses to describe software updates.