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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.