hola a todos.
Hace varios mese que falla el job "ProcessSLAJob". Os paso el log de SLA_ETL_Log a ver si alguien sabe como solucinarlo.
The execution of the following DTS Package failed:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Package failed because Step 'DTSStep_DTSExecuteSQLTask_56'
failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700
Package Name: SLA_ETL_DTS
Package Description: ETL Package for SLA Scorecard
Package ID: {A8F09E6C-EEF8-4D57-9333-298807572BF3}
Package Version: {19BE5C80-EFFA-45D4-A4D5-122E4BA193E1}
Package Execution Lineage: {7757D811-DA90-44F8-8F1F-7F9AD490DAF9}
Executed On: INTBRVL15
Executed By: SYSTEM
Execution Started: 14/03/2006 11:25:37
Execution Completed: 14/03/2006 11:25:39
Total Execution Time: 1,859 seconds
and the end of SLAjob_Log.Log file is:
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_56
DTSRun OnError: DTSStep_DTSExecuteSQLTask_56, Error = -2147217873 (80040E2F)
Error string: The statement has been terminated.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Error Detail Records:
Error: -2147217873 (80040E2F); Provider Error: 3621 (E25)
Error string: The statement has been terminated.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Error: -2147217873 (80040E2F); Provider Error: 1750 (6D6)
Error string: Could not create constraint. See previous errors.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Error: -2147217873 (80040E2F); Provider Error: 1505 (5E1)
Error string: CREATE UNIQUE INDEX terminated because a duplicate key was
found for index ID 1. Most significant primary key is '16'.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_56
Error: -2147220440 (80040428); Provider Error: 0 (0)
Error string: Package failed because Step 'DTSStep_DTSExecuteSQLTask_56'
failed.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
