SQL maintenance The package execution returned DTSER_FAILURE (1)

• Siten0308

  SSCarpal Tunnel

  Points: 4404

  More actions

  May 27, 2021 at 2:36 pm

  Go to Answer

  #3888763

  Hello,

  So we just came across this error message, and the error message is:

  Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:00:00 AM Finished: 3:01:49 AM

  I looked online, and found this on sql central:

  https://www.sqlservercentral.com/forums/topic/dtexec-the-package-execution-returned-dtser_failure-1-2

  the weird thing, is this a permanent fix, to always run:

  EXEC sp_configure 'allow updates', 0
  GO
  RECONFIGURE
  GO

  before running the maintenance? is there a permanent fix? and why did this happen? I cant recall us changing any passwords or anything on the backend.

  I am currently running:

  Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64)

  Sep 7 2018 01:37:51

  Copyright (c) Microsoft Corporation

  Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

• Jeffrey Williams

  SSC Guru

  Points: 90252

  More actions

  May 27, 2021 at 3:17 pm

  Answer

  #3888773

  Instead of looking at the agent job history - look at the maintenance plan history.  In that history you will find the error that caused the task to fail and you can then address the specific issue.

   

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs