SQL maintenance The package execution returned DTSER_FAILURE (1)

  • 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)

  • 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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply