none
Unable to connect to the DPM database because of a general database failure RRS feed

  • Question

  • every day at midnight dpm crashes with error code

    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>12475</Seq><TimeCreated>12/2/2014 6:09:25 AM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>SqlException</ExceptionType><ExceptionMessage>The DELETE statement conflicted with the REFERENCE constraint "FK_tbl_SPM_Volume_tbl_SPM_VolumeSet". The conflict occurred in database "DPMDB_CUR_511DPM", table "dbo.tbl_SPM_Volume", column 'VolumeSetID'.

    The statement has been terminated.</ExceptionMessage><ExceptionDetails>System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_tbl_SPM_Volume_tbl_SPM_VolumeSet". The conflict occurred in database "DPMDB_CUR_511DPM", table "dbo.tbl_SPM_Volume", column 'VolumeSetID'.

    The statement has been terminated.

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

    ClientConnectionId:0546bdfc-cead-4364-844c-3f0f038c6cf1</ExceptionDetails></FatalServiceError>

     

    the message resource is present but the message is not found in the string/message table

    Tuesday, December 2, 2014 9:04 PM

All replies

  • Hi,

    Seems to be DPMDB database corruption / inconsistency issue - please open a support case to help resolve it.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, December 2, 2014 11:07 PM
    Moderator