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.
