DPM 2012 R2 Crashes after upgrade - Tape Backup RRS feed

  • Question

  • Hello guys,

    I have recently upgraded from DPM 2012 SP1 to DPM 2012 R2 Rollup 3 on Windows 2012 R2 (in-place upgrade)

    The basic procedure was to backup the DB, uninstall DPM, install DPM 2012 R2, restore the DB.  re-sync all the inconsistent replicas and upgrade server agents. When it comes to the offsite tape backup for whatever reason every time the tape backup commences it fails instantly with the below error and reports "Backup to Tape Failed"

    "Event Log shows MSDPM Error ID 945"

    It appears to be failing due to a missing stored procedure 'dbo.prc_SMTE_ComputeDailyTrend'.  The stored procedure does not exist on other DPM servers.  I'm guessing this is something hanging around in the DB from prior to the upgrade but I can't seem to track it down.  Does anyone have any ideas upon how to resolve the issue?

    The description for Event ID 945 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    Unable to connect to the DPM database because of a general database failure.  Make sure that SQL Server is running and that it is configured correctly.

    Problem Details:
    <FatalServiceError><__System><ID>19</ID><Seq>84123</Seq><TimeCreated>25/10/2014 23:01:01</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>SqlException</ExceptionType><ExceptionMessage>Could not find stored procedure 'dbo.prc_SMTE_ComputeDailyTrend'.</ExceptionMessage><ExceptionDetails>System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbo.prc_SMTE_ComputeDailyTrend'.
       at Microsoft.Internal.EnterpriseStorage.Dls.SummaryManager.SummaryManagerMachine.OnStart(ErrorInfo&amp; eInfo)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.SimpleStateMachine.Start(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.Fsm.Engine.ChangeState(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.TaskInstance.Process(Object dummy)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.FsmThreadFunction.Function(Object taskThreadContextObj)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
       at System.Threading.ThreadPoolWorkQueue.Dispatch()

    Sunday, October 26, 2014 11:41 AM

All replies