ReSearch This KB – The daily summary was not created

Alert: The daily summary was not created

Management Pack Name: Forefront TMG Management Pack

Management Pack Version: 7.0.7695.100

Rule or Monitor: Rule

Rule or Monitor Name: The daily summary was not created

Rule or Monitor Notes: None

Issue:

Alert description:
“The daily summary for day “07/23/2013″ was not created. This may cause the report for this period to be inaccurate. Verify that no prior reporting configuration alerts exist, and that the reporting services on the designated Forefront TMG report server are running and accessible from all the array members. Use the source location 1001.105.7.0.9193.575 to report the failure.”

Microsoft TMG Server 2010 Service Pack 2 with Update Rollup 3.

Resolution:

If you check an
Application log you may find this event (event that triggered the alert):
Log Name: Application
Source: Microsoft Forefront TMG Report Generator
Date: 24.07.2013 0:30:43
Event ID: 30973
Task Category: None
Level: Error
Keywords: Classic

User: N/A
Computer: myserver

Description:

The daily summary for day “07/23/2013” was not created. This may cause the report for this period to be inaccurate. Verify that no prior reporting configuration alerts exist, and that the reporting services on the
designated Forefront TMG report server are running and accessible from all the array members. Use the source location 1001.105.7.0.9193.575 to report the failure.
Right before this event there is another one event that makes clear the root cause of this issue:

Log Name: Application
Source: MSSQL$ISARS
Date: 24.07.2013 0:30:42
Event ID: 701
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: myserver

Description:

There is insufficient system memory in resource pool ‘internal’ to run this query.

This TMG server has a SQL Server on the same box. All you need is to tune the SQL memory consumption. You can find details in this MSFT KB article: http://support.microsoft.com/kb/909636
(it’s for ISA Server but applicable to TMG as well).

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.