Forefront Cannot generate monthly summaries

Wed, 17 Jun 2009 23:25:23 Z

Hi guys,

I have a forefront TMG Beta 2 server that I've had running for just over 2 months now. It's running on an ESX hosted virtual guest, with a 2008 x64 OS, no service pack as yet. It's runnig as both a forward and reverse proxy. I'm having a problem with report generation however. The error message from the forefront console is as follows:
Description: The daily summaries could not be summarized into a monthly summary for month "05/2009". Use the source location 1001.233.7.0.7264.100 to report the failure.

I also get the same error for 04/2009.. but that's ok cause it wasn't even installed then. I found one link that suggested it could be a low memory condition, so I bumped up the memory and rebooted, and waited for the summarisation to happen again but it hasn't worked still.
I'm trying to work out why, and I'm wondering it it's having problems because it doesn't have a full 30 days of daily summaries for May because it was only built on the 12th, or if thre is some other reason.
I can't work out what the source location is about though, so any pointers would be fantastic.

(The daily reports are working just fine by the way)

Forefront Cannot generate monthly summaries

Sat, 20 Jun 2009 18:15:28 Z

I will check this in my lab and report back.

Bala Natarajan [MSFT]| Sr. Support Escalation Engineer | CSS Security -TMG Beta support team | Email: bala.natarajan@microsoft.com | Office 425.704.4626 Bing it on bing.com

Forefront Cannot generate monthly summaries

Sun, 21 Jun 2009 01:21:12 Z

thank you, I appreciate your response.

Forefront Cannot generate monthly summaries

Wed, 01 Jul 2009 00:34:19 Z

Hi Bala,

I appreciate your time and support in looking at this, and just thought i'd let you know that another month has rolled round (and there should now be a solid 30+ days of events in the firewall logs) but the same issue occured.

If there is something I can do, or logs I can provide to assist with the issue, please let me know.

Forefront Cannot generate monthly summaries

Thu, 02 Jul 2009 05:22:28 Z

Hi!
I have the same issue too. It was there in Beta 2 and it is still there in Beta 3.
This is the error from the event log:

Log Name:      Application
Source:        Microsoft Forefront TMG Report Generator
Date:          02.07.2009 00:31:14
Event ID:      21016
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      TMG3
Description:
The daily summaries could not be summarized into a monthly summary for month "06/2009". Use the source location 1001.232.7.0.7509.100 to report the failure.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft Forefront TMG Report Generator" />
    <EventID Qualifiers="49152">21016</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-07-01T22:31:14.000000000Z" />
    <EventRecordID>4324</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TMG3</Computer>
    <Security />
  </System>
  <EventData>
    <Data>06/2009</Data>
    <Data>1001.232.7.0.7509.100</Data>
  </EventData>
</Event>

Hallis

Forefront Cannot generate monthly summaries

Fri, 03 Jul 2009 05:47:51 Z

Hey hallis, cheers for posting that. It made me think perhaps I'm on the right track with my current train of thought.

Are you in Australia, or the UK, or somewhere else that DOESN'T put the month first in the date ? I'm wondering if that's why the stored procedure in the database fails ? Perhaps it cna't understand the regional date.. ?

surely that's not right though.

I've also got "configuration option show advanced options changed from 0 to 1, run reconfigure statement to install" and
"Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install." and
Configuration option 'Ole Automation Procedures' changed from 1 to 0. Run the RECONFIGURE statement to install.
Configuration option 'Ole Automation Procedures' changed from 1 to 1. Run the RECONFIGURE statement to install.

do i need to actually do something about that ? They occur regularly..

Forefront Cannot generate monthly summaries

Fri, 03 Jul 2009 06:15:59 Z

i've had a bit of a win. It's taken me at least a good hour today but I've established that if I connect to SQL directly, and execute a stored procedure manually, it works: exec isa_spusersummarymonthly '2009-06-01','2009-06-01','2009-05-01','2009-05-01' now all of a sudden, I can generate a monthly report for june.. but only the users part.

Forefront Cannot generate monthly summaries

Fri, 03 Jul 2009 07:56:47 Z

Hi Andrew!
I live in Norway and we use the dd.MM.yyyy date format.

Hallis

Forefront Cannot generate monthly summaries

Thu, 09 Jul 2009 19:18:54 Z

Sorry for the late response.

I am actually working with the developer on this. I will let you know once i have some actionable tasks for you..

Thanks

Bala Natarajan [MSFT]| Sr. Support Escalation Engineer | CSS Security -TMG Beta support team | Email: bala.natarajan@microsoft.com | Office 425.704.4626 Bing it on bing.com

Forefront Cannot generate monthly summaries

Sat, 12 Sep 2009 03:09:10 Z

Hi Bala,

I'd just like to report that I'm seeing the same thing in TMG Beta 3. Note: this is running on an all patched up Win2008 (not R2), on tin (just a Core 2 Dual, 2.3GHz, 2Gig RAM, 120Gig SATA HD) with the local SQL Express DB.

It's reporting that it's not able to create the monthly rollup report, though it's reporting that every night. And they dayly reports now contain no data.

From when I turned reporting on, I got three days of valid reports and empty reports ever since.
I'm in New Zealand so we use a dd/mm/yyyy date format. Though I notice the folders created by the reports are still m.d.yyyy.

Any ideas?

I'm going to install the SQL management tools and see if I can execute the reports manually...

Later'ish
Craig

Forefront Cannot generate monthly summaries

Sun, 11 Oct 2009 09:48:04 Z

same problem

Description: The daily summaries could not be summarized into a monthly summary for month "07/2009". Use the source location 1001.232.7.0.7509.100 to report the failure. The daily summaries could not be summarized into a monthly summary for month "08/2009". Use the source location 1001.232.7.0.7509.100 to report the failure.

Forefront Cannot generate monthly summaries

Tue, 13 Oct 2009 21:06:55 Z

hello Bala,

I appreciate the time and effort you've been spending on this. Just thought I'd follow up and see how you've been going. In particular, if the issue might be resolved by a move to the RC of forefront 2010 ?