locked
Forefront 14-Days History

    Question

  • 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
    Sunday, May 09, 2010 4:04 AM

Answers

All replies

  •  maintain the Autogrowth by 10 percents but double the restricted file growth size of the DB from 1024 Mb to 2048 Mb for RepData.mdf...

    Any metrics for the sizing of the Db SystemCenterReporting?(I have 82 Clients on this server)

    Any cycle to be set for the RepData.mdf not to growth without limits...?

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
    Sunday, May 09, 2010 4:13 AM
  • Hi,

     

    Thank you for the post.

     

    Please refer to this article: http://blogs.technet.com/fcsnerds/archive/2008/09/25/fcs-with-mom-2005-database-guidance.aspx

     

    Regards,


    Nick Gu - MSFT
    • Marked as answer by Felyjos Tuesday, May 11, 2010 1:25 PM
    Tuesday, May 11, 2010 8:10 AM
    Moderator
  • thanks,

    DOm


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
    Tuesday, May 11, 2010 6:54 PM