Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: You receive an "Error: Subreport could not be shown" error message in the User Activity or Site Activity report in a Forefront Threat Management Gateway 2010 environment
Article ID: 2653703 - View products that this article applies to.
Consider the following scenario. You run the User Activity report or the Site Activity report in a Microsoft Forefront Threat Management Gateway 2010 environment. The report may run for some time and then finish suddenly and open in Windows Internet Explorer. In this scenario, the report has no details, and only the report headers and frames are displayed. You may receive the following error message in the frame where the report data should be:
Error: Subreport could not be shown
The User Activity and Site Activity reports use COM objects in the stored procedures that generate the report and therefore enable the Ole Automation Procedures option. The setting to enable Ole Automation Procedures option is a global setting on the SQL Reporting Server, and the report run may fail if this functionality is turned off while the report is still running. This problem may occur when any changes are made to the Forefront Threat Management Gateway configuration while the report is running or when multiple administrators try to run activity reports at the same time.
To resolve this issue, install the hotfix package that is described in the following Microsoft Knowledge Base article:
2649961To enable this fix, run the FixActivityReports.js script on one of the Forefront Threat Management Gateway servers. You can run this script on any Forefront Threat Management Gateway server, on an array node, or on an Enterprise Management Server.
(http://support.microsoft.com/kb/2649961/ )Rollup 1 for Forefront Threat Management Gateway (TMG) 2010 Service Pack 2
Note The script enumerates all available arrays and corrects the stored procedure so that the Ole Automation Procedures option is not turned off for the activity reports. You may have to rerun the script if new arrays are added to the storage.
To work around this issue, make sure that the configuration is fully synchronized before you click Generate and View Report. To determine whether the Forefront Threat Management Gateway configuration is synchronized, click Configuration on the Monitor menu, and then check the Status column.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
Article ID: 2653703 - Last Review: January 11, 2012 - Revision: 1.0