Microsoft Forefront codename "Stirling" >
Forefront Codename 'Stirling' Forums
>
Forefront Threat Management Gateway
>
Forefront Cannot generate monthly summaries
Forefront Cannot generate monthly summaries
- 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)
All Replies
- 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 - thank you, I appreciate your response.
- 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.
- 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 - 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.. - 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.
- Hi Andrew!
I live in Norway and we use the dd.MM.yyyy date format.
Hallis - 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 - 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- Proposed As Answer byfido2121 Sunday, October 11, 2009 9:46 AM
- 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. - 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 ?
