Toubleshooting of DTSX Error Msg

• centralgenesyssupport

  Grasshopper

  Points: 17

  More actions

  January 22, 2014 at 4:07 am

  #282494

  Hi,

  I need to troubleshooting of belwo mention error screenshot.

  01/21/2014 02:00:00,MaintenancePlan.Full back up,Error,0,SRCSRV45VOC08,MaintenancePlan.Full back up,(Job outcome),,The job failed. The Job was invoked by Schedule 16 (MaintenancePlan.Full back up). The last step to run was step 1 (Full back up).,00:00:35,0,0,,,,0

  01/21/2014 02:00:00,MaintenancePlan.Full back up,Error,1,SRCSRV45VOC08,MaintenancePlan.Full back up,Full back up,,Executed as user: SRCSRV45VOC08\administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:00 AM Progress: 2014-01-21 02:00:23.78 Source: {BC282841-8E66-4C1E-94AB-35F916017BF8} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2014-01-21 02:00:28.89 Code: 0xC002F210 Source: Maintenance Cleanup Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_delete_file 0<c/>N'\\10.69.8.11..." failed with the following error: "xp_delete_file() returned error 2<c/> 'The system cannot find the file specified.'". Possible failure reasons: Problems with the query<c/> "ResultSet" property not set correctly<c/> parameters not set correctly<c/> or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:00:00 AM Finished: 2:00:33 AM Elapsed: 32.198 seconds. The package execution failed. The step failed.,00:00:35,0,0,,,,0

  Rds

  VK