Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DTS Job failed - Step Error Code: -2147220441

25 views
Skip to first unread message

AlexanderWolff

unread,
Jul 1, 2009, 4:27:01 AM7/1/09
to

Hi, i have some trouble with the MOM 2005 SP1 Reporting DTS Job. This job
failed after a short runtime.

Have you any idea why this job failed?

Error-Details:
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_ClassAttributeInstanceFact_View_1_Insert' failed
with the following error:
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Execution was canceled by user.
Step Error Code: -2147220441
Step Error Help File:
Step Error Help Context ID:0

The execution of the following DTS Package failed:

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
DEDUS-WICL03D01.OnePoint to DEVIS-WIDB07.SystemCenterReporting
Package ID: {03E02217-2990-4D84-A0F9-6A650B2AC527}
Package Version: {CE09B4FC-DB0C-4FFB-A728-9923EEB0B76E}
Package Execution Lineage: {635B9CCA-EB22-4A9A-BC1D-10DF42A13C44}
Executed On: DEVIS-WIDB07
Executed By: desrv-mom
Execution Started: 01.07.2009 09:34:09
Execution Completed: 01.07.2009 09:36:35
Total Execution Time: 146,172 seconds

Package Steps execution information:


Step 'SyncStepBetweDimensionAndFact' succeeded
Step Execution Started: 01.07.2009 09:36:14
Step Execution Completed: 01.07.2009 09:36:14
Total Step Execution Time: 0 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_1_Update' succeeded
Step Execution Started: 01.07.2009 09:36:14
Step Execution Completed: 01.07.2009 09:36:17
Total Step Execution Time: 2,906 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_2_Update' succeeded
Step Execution Started: 01.07.2009 09:36:17
Step Execution Completed: 01.07.2009 09:36:20
Total Step Execution Time: 2,625 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_3_Update' succeeded
Step Execution Started: 01.07.2009 09:36:20
Step Execution Completed: 01.07.2009 09:36:21
Total Step Execution Time: 0,687 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_4_Update' succeeded
Step Execution Started: 01.07.2009 09:36:21
Step Execution Completed: 01.07.2009 09:36:23
Total Step Execution Time: 2,75 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_5_Update' succeeded
Step Execution Started: 01.07.2009 09:36:23
Step Execution Completed: 01.07.2009 09:36:24
Total Step Execution Time: 0,906 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_6_Update' succeeded
Step Execution Started: 01.07.2009 09:36:24
Step Execution Completed: 01.07.2009 09:36:25
Total Step Execution Time: 0,719 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_7_Update' succeeded
Step Execution Started: 01.07.2009 09:36:25
Step Execution Completed: 01.07.2009 09:36:26
Total Step Execution Time: 0,672 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_8_Update' succeeded
Step Execution Started: 01.07.2009 09:36:26
Step Execution Completed: 01.07.2009 09:36:27
Total Step Execution Time: 0,844 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_9_Update' succeeded
Step Execution Started: 01.07.2009 09:36:27
Step Execution Completed: 01.07.2009 09:36:27
Total Step Execution Time: 0,875 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_10_Update' succeeded
Step Execution Started: 01.07.2009 09:36:27
Step Execution Completed: 01.07.2009 09:36:28
Total Step Execution Time: 0,906 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:28
Step Execution Completed: 01.07.2009 09:36:29
Total Step Execution Time: 1,078 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_2_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:29
Step Execution Completed: 01.07.2009 09:36:30
Total Step Execution Time: 0,516 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_3_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:30
Step Execution Completed: 01.07.2009 09:36:30
Total Step Execution Time: 0,469 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_4_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:30
Step Execution Completed: 01.07.2009 09:36:31
Total Step Execution Time: 0,484 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_5_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:31
Step Execution Completed: 01.07.2009 09:36:31
Total Step Execution Time: 0,375 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_6_Insert' was not executed

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_7_Insert' was not executed

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_8_Insert' was not executed

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_9_Insert' was not executed

Step 'DTSStep_ExecuteSQLTask_SC_AlertFact_View_10_Insert' was not executed

Step 'DTSStep_ExecuteSQLTask_SC_AlertHistoryFact_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:14
Step Execution Completed: 01.07.2009 09:36:17
Total Step Execution Time: 2,984 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertHistoryFact_View_2_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:17
Step Execution Completed: 01.07.2009 09:36:20
Total Step Execution Time: 2,609 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertLevelDimension_View_1_Update' succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,141 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertLevelDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,062 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertResolutionStateDimension_View_1_Update'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,141 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertResolutionStateDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,062 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_AlertToEventFact_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:14
Step Execution Completed: 01.07.2009 09:36:26
Total Step Execution Time: 12,047 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_ClassAttributeDefinitionDimension_View_1_Update'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,36 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_ClassAttributeDefinitionDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,14 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask__View_1_Insert' failed

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Error converting data type DBTYPE_DBTIMESTAMP to
datetime.
Step Error code: 80040E07
Step Error Help File:
Step Error Help Context ID:0

Step Execution Started: 01.07.2009 09:36:14
Step Execution Completed: 01.07.2009 09:36:31
Total Step Execution Time: 16,75 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ClassDefinitionDimension_View_1_Update'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,125 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ClassDefinitionDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,062 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ClassInstanceFact_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:36:20
Step Execution Completed: 01.07.2009 09:36:35
Total Step Execution Time: 15,063 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ComputerDimension_View_1_Update' succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,406 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ComputerDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,187 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleDimension_View_1_Update' succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,422 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ComputerRuleDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,109 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_ComputerRuleToProcessRuleGroupFact_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:36:26
Step Execution Completed: 01.07.2009 09:36:27
Total Step Execution Time: 0,531 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ComputerToComputerRuleFact_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:36:27
Step Execution Completed: 01.07.2009 09:36:32
Total Step Execution Time: 4,563 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_ComputerToConfigurationGroupDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:24
Total Step Execution Time: 14,86 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ConfigurationGroupDimension_View_1_Update'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,063 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ConfigurationGroupDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:09
Total Step Execution Time: 0,062 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_CounterDetailDimension_View_1_Update'
succeeded
Step Execution Started: 01.07.2009 09:34:09
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,891 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_CounterDetailDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,406 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Update' succeeded
Step Execution Started: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,891 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_EventDetailDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,141 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_EventFact_View_1_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: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,078 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_EventTypeDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,063 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleDimension_View_1_Update' succeeded
Step Execution Started: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:12
Total Step Execution Time: 2,281 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ProcessRuleDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:12
Step Execution Completed: 01.07.2009 09:34:13
Total Step Execution Time: 0,75 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: 01.07.2009 09:34:15
Step Execution Completed: 01.07.2009 09:35:23
Total Step Execution Time: 67,906 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_ProcessRuleToConfigurationGroupDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:35:23
Step Execution Completed: 01.07.2009 09:36:14
Total Step Execution Time: 51,032 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: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,312 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ProviderDetailDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:10
Step Execution Completed: 01.07.2009 09:34:10
Total Step Execution Time: 0,094 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeDefinitionDimension_View_1_Update' succeeded
Step Execution Started: 01.07.2009 09:34:11
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,062 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_RelationshipAttributeDefinitionDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:11
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,079 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: 01.07.2009 09:34:11
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,141 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_RelationshipDefinitionDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:11
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,078 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: 01.07.2009 09:34:11
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,093 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_ScriptDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:11
Step Execution Completed: 01.07.2009 09:34:11
Total Step Execution Time: 0,079 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_ScriptToConfigurationGroupDimension_View_1_Update'
succeeded
Step Execution Started: 01.07.2009 09:34:15
Step Execution Completed: 01.07.2009 09:34:16
Total Step Execution Time: 0,328 seconds
Progress count in Step: 0

Step
'DTSStep_ExecuteSQLTask_SC_ScriptToConfigurationGroupDimension_View_1_Insert'
succeeded
Step Execution Started: 01.07.2009 09:34:16
Step Execution Completed: 01.07.2009 09:34:17
Total Step Execution Time: 0,812 seconds
Progress count in Step: 0

Step 'DTSStep_ExecuteSQLTask_SC_UserDimension_View_1_Insert' succeeded
Step Execution Started: 01.07.2009 09:34:11
Step Execution Completed: 01.07.2009 09:34:15
Total Step Execution Time: 4,687 seconds
Progress count in Step: 0

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

.Anders Bengtsson

unread,
Aug 7, 2009, 4:18:33 PM8/7/09
to
Hello AlexanderWolff,

Please take a look at this KB http://support.microsoft.com/kb/899158, How
to troubleshoot DTS and database sizing issues in MOM 2005 Reporting

Please post this in the new web based forum for ops mgr, Microsoft has recently
launched a new space at Microsoft Technet Forums for Operations Manager.
You will find it at http://social.technet.microsoft.com/Forums/en-us/category/systemcenteroperationsmanager
. The product team, the MVPs and a lot of people are already there! See you
there

Anders Bengtsson
Microsoft MVP - System Center Operations Manager
www.contoso.se

0 new messages