Forefront 14-Days History

• Sunday, May 09, 2010 4:04 AM

   

   
  

  0

  Hello,

  I already checked:

  http://social.technet.microsoft.com/Forums/en-US/Forefrontclientreporting/thread/4fa75aa8-669e-429c-9161-3915a7e21da4

  http://social.technet.microsoft.com/forums/en-US/Forefrontclientreporting/thread/5b011497-62d8-4bb3-90b6-00352e1ffb8b

  http://social.technet.microsoft.com/Forums/en-US/Forefrontclientreporting/thread/3d43a749-b73b-4cae-85f6-1462377816b3

  but still the 14-Days History is showing No Data... it worked fine until 5/1/2010 but since it is No Data

  strange...

  I think the issue is abour SQL:

  Log Name: Application
  
  
  
  Source: MSSQLSERVER
  
  
  
  Date:  5/8/2010 6:00:17 AM
  
  
  
  Event ID: 1105
  
  
  
  Task Category: (2)
  
  
  
  Level:  Error
  
  
  
  Keywords: Classic
  
  
  
  User:  AD\svcFFCS
  
  
  
  Computer: voforefrontcs1.ad
  
  
  
  Description:
  
  
  
  Could not allocate space for object 'dbo.SC_EventFact_Table'.'EventFact_LocalDateTimeGenerated_ClusteredIndex' in database 'SystemCenterReporting' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
  
  
  
  Event Xml:
  
  
  
  <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  
  
  
   <System>
  
  
  
   <Provider Name="MSSQLSERVER" />
  
  
  
   <EventID Qualifiers="49152">1105</EventID>
  
  
  
   <Level>2</Level>
  
  
  
   <Task>2</Task>
  
  
  
   <Keywords>0x80000000000000</Keywords>
  
  
  
   <TimeCreated SystemTime="2010-05-08T13:00:17.000Z" />
  
  
  
   <EventRecordID>106723</EventRecordID>
  
  
  
   <Channel>Application</Channel>
  
  
  
   <Computer>voforefrontcs1.ad</Computer>
  
  
  
   <Security UserID="S-1-5-21-73586283-1284227242-1801674531-194008" />
  
  
  
   </System>
  
  
  
   <EventData>
  
  
  
   <Data>dbo.SC_EventFact_Table</Data>
  
  
  
   <Data>.'EventFact_LocalDateTimeGenerated_ClusteredIndex'</Data>
  
  
  
   <Data>SystemCenterReporting</Data>
  
  
  
   <Data>PRIMARY</Data>
  
  
  
   <Binary>51040000110000000F00000056004F0046004F0052004500460052004F004E005400430053003100000016000000530079007300740065006D00430065006E007400650072005200650070006F007200740069006E0067000000</Binary>
  
  
  
   </EventData>
  
  
  
  </Event>

  looking for ideas to solve this...

  The DB itself is fine 18% free space on the SystemCenterReporting DB...

  The Filegroup is set to 1 Default checked...

  I ran SystemCenterDTSPackageTask it ends with a code completed sucessfully...

  And now the data shows up

  Thanks,

  Dom

  ---

  System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support