locked
Forefront 14-Days History RRS feed

  • Question

  • Hello,

    Periodically every 2-3 weeks the 14-Days history disappear... anyway to prevent this?

    Most of the time a re-run of the SystemCenterDTSPackageTask is enough but sometimes not it seems it needs more space in the database... Any idea how to have sometrhing more stable?

    I missed 8/15-16-17

    Strange enough I rebooted the server and now I miss 8/16-17 15 has been populated !!!

    Log Name:   Application
    Source:    MOM.Datawarehousing.DTSPackageGenerator.exe
    Date:     8/18/2010 7:42:11 PM
    Event ID:   1001
    Task Category: None
    Level:     Error
    Keywords:   Classic
    User:     N/A
    Computer:   voforefrontcs1.ad.medctr.ucla.edu
    Description:
    Step StepInvokeInnerPackage failed.
    Step Error Source: Microsoft OLE DB Provider for SQL Server
    Step Error Description: (1:SC_Inner_DTS_Package) SubStep 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Update' failed with the following error: 
    Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Execution was canceled by user.
    Step Error Code: -2147220441
    Step Error Help File:
    Step Error Help Context ID:0
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
     <System>
      <Provider Name="MOM.Datawarehousing.DTSPackageGenerator.exe" />
      <EventID Qualifiers="0">1001</EventID>
      <Level>2</Level>
      <Task>0</Task>
      <Keywords>0x80000000000000</Keywords>
      <TimeCreated SystemTime="2010-08-19T02:42:11.000Z" />
      <EventRecordID>133098</EventRecordID>
      <Channel>Application</Channel>
      <Computer>voforefrontcs1.ad.medctr.ucla.edu</Computer>
      <Security />
     </System>
     <EventData>
      <Data>Step StepInvokeInnerPackage failed.
    Step Error Source: Microsoft OLE DB Provider for SQL Server
    Step Error Description: (1:SC_Inner_DTS_Package) SubStep 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Update' failed with the following error: 
    Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Execution was canceled by user.
    Step Error Code: -2147220441
    Step Error Help File:
    Step Error Help Context ID:0</Data>
     </EventData>
    </Event>
    Log Name:   Application
    Source:    DataTransformationServices
    Date:     8/18/2010 7:42:10 PM
    Event ID:   81
    Task Category: None
    Level:     Error
    Keywords:   Classic
    User:     N/A
    Computer:   voforefrontcs1.ad.medctr.ucla.edu
    Description:
    The description for Event ID 81 from source DataTransformationServices cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
    
    If the event originated on another computer, the display information had to be saved with the event.
    
    The following information was included with the event: 
    
    
    
    Error Source: Microsoft Data Transformation Services (DTS) Package
    Error Description:Execution was canceled by user.
    Error code: 80040427
    \Error Help File:sqldts80.hlp
    Error Help Context ID:10100
    
    
    Package Name: SC_Inner_DTS_Package
    Package Description: This package transfers data from VOFOREFRONTCS1.OnePoint to VOFOREFRONTCS1.SystemCenterReporting
    Package ID: {5F031DA4-2731-4E51-82B8-671528BCC40D}
    Package Version: {B0B86835-A366-40AB-8800-3E972AD36698}
    Package Execution Lineage: {F0E5D4DF-6A56-4DB6-B3F2-3FB12E0FE6C9}
    Executed On: VOFOREFRONTCS1
    Executed By: svcFFCS
    Execution Started: 8/18/2010 7:41:11 PM
    Execution Completed: 8/18/2010 7:42:10 PM
    Total Execution Time: 59.547 seconds
    
    Package Steps execution information:
    
    
    Step 'SyncStepBetweDimensionAndFact' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_1_Update' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertHistoryFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertLevelDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.25 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertLevelDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertResolutionStateDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.234 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertResolutionStateDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.063 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertToEventFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassAttributeDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.094 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassAttributeDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.046 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassAttributeInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.25 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerDimension_Insert_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.609 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerDimension_Insert_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.063 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.109 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleToProcessRuleGroupFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerToComputerRuleFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerToConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:13 PM
    Total Step Execution Time: 2.297 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ConfigurationGroupDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.062 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.079 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_CounterDetailDimension_Insert_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.125 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_CounterDetailDimension_Insert_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Update' failed
    
    Step Error Source: Microsoft OLE DB Provider for SQL Server
    Step Error Description:Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Step Error code: 80004005
    Step Error Help File:
    Step Error Help Context ID:0
    
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:53 PM
    Total Step Execution Time: 42.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventFact_View_2_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventFact_View_3_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventParameterFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventTypeDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.313 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventTypeDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:42:10 PM
    Total Step Execution Time: 58.718 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.297 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.172 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleMembershipFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleToConfigurationGroupDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:13 PM
    Total Step Execution Time: 0.656 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleToConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:13 PM
    Step Execution Completed: 8/18/2010 7:41:14 PM
    Total Step Execution Time: 0.766 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleToScriptFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProviderDetailDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProviderDetailDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.063 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.016 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.031 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_SampledNumericDataFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.031 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptToConfigurationGroupDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:14 PM
    Step Execution Completed: 8/18/2010 7:41:14 PM
    Total Step Execution Time: 0.125 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptToConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:14 PM
    Step Execution Completed: 8/18/2010 7:41:14 PM
    Total Step Execution Time: 0.11 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_UserDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.11 seconds
    Progress count in Step: 0
    
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
     <System>
      <Provider Name="DataTransformationServices" />
      <EventID Qualifiers="49152">81</EventID>
      <Level>2</Level>
      <Task>0</Task>
      <Keywords>0x80000000000000</Keywords>
      <TimeCreated SystemTime="2010-08-19T02:42:10.000Z" />
      <EventRecordID>133097</EventRecordID>
      <Channel>Application</Channel>
      <Computer>voforefrontcs1.ad.medctr.ucla.edu</Computer>
      <Security />
     </System>
     <EventData>
      <Data>
    
    Error Source: Microsoft Data Transformation Services (DTS) Package
    Error Description:Execution was canceled by user.
    Error code: 80040427
    \Error Help File:sqldts80.hlp
    Error Help Context ID:10100
    
    
    Package Name: SC_Inner_DTS_Package
    Package Description: This package transfers data from VOFOREFRONTCS1.OnePoint to VOFOREFRONTCS1.SystemCenterReporting
    Package ID: {5F031DA4-2731-4E51-82B8-671528BCC40D}
    Package Version: {B0B86835-A366-40AB-8800-3E972AD36698}
    Package Execution Lineage: {F0E5D4DF-6A56-4DB6-B3F2-3FB12E0FE6C9}
    Executed On: VOFOREFRONTCS1
    Executed By: svcFFCS
    Execution Started: 8/18/2010 7:41:11 PM
    Execution Completed: 8/18/2010 7:42:10 PM
    Total Execution Time: 59.547 seconds
    
    Package Steps execution information:
    
    
    Step 'SyncStepBetweDimensionAndFact' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_1_Update' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertHistoryFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertLevelDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.25 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertLevelDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertResolutionStateDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.234 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertResolutionStateDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.063 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_AlertToEventFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassAttributeDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.094 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassAttributeDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.046 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassAttributeInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.25 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ClassInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerDimension_Insert_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.609 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerDimension_Insert_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.063 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.109 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleToProcessRuleGroupFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerToComputerRuleFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ComputerToConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:13 PM
    Total Step Execution Time: 2.297 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ConfigurationGroupDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.062 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.079 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_CounterDetailDimension_Insert_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.125 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_CounterDetailDimension_Insert_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Update' failed
    
    Step Error Source: Microsoft OLE DB Provider for SQL Server
    Step Error Description:Transaction (Process ID 73) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Step Error code: 80004005
    Step Error Help File:
    Step Error Help Context ID:0
    
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:53 PM
    Total Step Execution Time: 42.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventFact_View_2_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventFact_View_3_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventParameterFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventTypeDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.313 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_EventTypeDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:42:10 PM
    Total Step Execution Time: 58.718 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.297 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.172 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleMembershipFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleToConfigurationGroupDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:13 PM
    Total Step Execution Time: 0.656 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleToConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:13 PM
    Step Execution Completed: 8/18/2010 7:41:14 PM
    Total Step Execution Time: 0.766 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleToScriptFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProviderDetailDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ProviderDetailDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:11 PM
    Step Execution Completed: 8/18/2010 7:41:11 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.063 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.016 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipDefinitionDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.078 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipDefinitionDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.031 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_RelationshipInstanceFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_SampledNumericDataFact_View_1_Insert' was not executed
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.047 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.031 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptToConfigurationGroupDimension_View_1_Update' succeeded
    Step Execution Started: 8/18/2010 7:41:14 PM
    Step Execution Completed: 8/18/2010 7:41:14 PM
    Total Step Execution Time: 0.125 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_ScriptToConfigurationGroupDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:14 PM
    Step Execution Completed: 8/18/2010 7:41:14 PM
    Total Step Execution Time: 0.11 seconds
    Progress count in Step: 0
    
    Step 'DTSStep_ExecuteSQLTask_SC_UserDimension_View_1_Insert' succeeded
    Step Execution Started: 8/18/2010 7:41:12 PM
    Step Execution Completed: 8/18/2010 7:41:12 PM
    Total Step Execution Time: 0.11 seconds
    Progress count in Step: 0</Data>
     </EventData>
    </Event>

    these are the events seens in the Application log...

    Thanks,

    Dom

     


     

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

    Thursday, August 19, 2010 1:19 AM

All replies

  • Any chance this is on 2008?  (looks like it is seeing your event id stuff is all in xml)  See http://blogs.technet.com/b/clientsecurity/archive/2010/04/28/event-id-81-and-fcs.aspx 

    Specifically the /maxconn:5 issues as this will randomly have deadlocks on 2008 server if you don't have that switch in there.  On the other hand if it's complaining about space then you probably need to give it space and grow your db files. 


    CSS Security Support Engineer (FCS/MBSA/WUA/Incident Response/FOPE) Check out my blog http://blogs.technet.com/kfalde or better yet check out http://technet.com/wiki and start contributing :)
    Friday, August 20, 2010 10:09 PM
    Moderator
  • I will review this

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
    Saturday, August 21, 2010 8:23 PM
  • Hi,

    Do you have any update about this issue?

    Regards,


    Nick Gu - MSFT
    Thursday, September 2, 2010 2:35 AM
    Moderator
  • Hi Nick,

    Not much as issues are still coming peridically but I could not find a pattern...

    My resolution so far turn around SystemCenterDTSPackageTask runs and also increase the databases size...

    Thanks,

    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support
    Thursday, September 2, 2010 3:28 AM