Alert: Data Warehouse event data dedicated maintenance process failed to perform

Forum: Operations Manager4
Viewing 1 post (of 1 total)
  • #230262
    Profile photo of Pollastre
    Pollastre
    Participant

    Hello,

    We have this alert:

    Alert: Data Warehouse event data dedicated maintenance process failed to perform maintenance operation Resolution state: New

    Source: Data Warehouse Synchronization Service

    Alert description: Data Warehouse event data dedicated maintenance process failed to perform maintenance operation.

    Excepción ‘SqlException’: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    and If I open Microsoft SQL Server Management Studio and open database / Sql Server Agent/ Jobs / mdw_purge_data_[DatawareHouse] has errors, I try to launch with ‘Start Job at Step’ and  appears this error:

    Message
    Executed as user: CONTOSO\sqlsercluspro. Could not find stored procedure ‘core.sp_purge_data’. [SQLSTATE 42000] (Error 2812).  The step failed.

    ¿Any idea of why can’t purge data correctly in SCOM DW ?

    Best Regards

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.