Ver Mensaje Individual
  #1 (permalink)  
Antiguo 24/08/2007, 05:58
holaadeu
 
Fecha de Ingreso: julio-2006
Mensajes: 5
Antigüedad: 17 años, 10 meses
Puntos: 0
error job ProcessSLAJob

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