October 22, 2007 at 2:11 pm
DTS package 3 steps consists of 2 tasks and 1 connection:
a- task1: truncate table
b- task2: update history table
c- connection from as400 to SS2K
connection has 5 transform data task (data pump).
a to b on success
b to c on success
a->b->c
Now the problem is: Task2 sometimes fails. The error log says violation of unique key. That is impossible because I do a truncate to the table has primary keys on SS and AS400 side. Any ideas what is going on? and how to fix it?
error msg:
Package Steps execution information:
Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 10/22/2007 3:05:22 PM
Step Execution Completed: 10/22/2007 3:05:23 PM
Total Step Execution Time: 0.531 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step Execution Started: 10/22/2007 3:05:23 PM
Step Execution Completed: 10/22/2007 3:05:23 PM
Total Step Execution Time: 0.328 seconds
Progress count in Step: 728
Step 'DTSStep_DTSDataPumpTask_2' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): The statement has been terminated.) (Microsoft OLE DB Provider for SQL Server (80004005): Violation of UNIQUE KEY constraint 'IX_PK_WHREGN'. Cannot insert duplicate key in object 'WHREGN'.)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100
Step Execution Started: 10/22/2007 3:05:22 PM
Step Execution Completed: 10/22/2007 3:05:23 PM
Total Step Execution Time: 0.515 seconds
Progress count in Step: 427
Step 'DTSStep_DTSDataPumpTask_3' succeeded
Step Execution Started: 10/22/2007 3:05:22 PM
Step Execution Completed: 10/22/2007 3:05:25 PM
Total Step Execution Time: 2.531 seconds
Progress count in Step: 122
Step 'DTSStep_DTSDataPumpTask_4' succeeded
Step Execution Started: 10/22/2007 3:05:22 PM
Step Execution Completed: 10/22/2007 3:05:24 PM
Total Step Execution Time: 1.453 seconds
Progress count in Step: 30
Step 'DTSStep_DTSDataPumpTask_5' succeeded
Step Execution Started: 10/22/2007 3:05:23 PM
Step Execution Completed: 10/22/2007 3:05:24 PM
Total Step Execution Time: 1.625 seconds
Progress count in Step: 0
October 22, 2007 at 2:24 pm
Recreated the on success lines and it worked charmingly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply