none
Getting SCOM DW alerts in all Management servers RRS feed

  • Question

  • HI Guys,

    I am getting the below DW related alerts on all my Management Server. These alerts are getting fluctuated. on and off creating and closing. and my all 3 MS has become critical because of this. Please suggest what action to do!! Its very orgent, please help!!

    1. Performance data collection process unable to write data to the Data Warehouse. Failed to store data in the Data Warehouse. The operation will be retried.
    Exception 'SqlTimeoutException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    Timeout occurred while trying to bulk copy data to Perf.PerformanceStage table.
    Current Timeout Value: 30 second(s)
    This timeout can be increased by adding a registry key (type: dword 32 bit, value: revised timeout in seconds) named : Bulk Insert Command Timeout Seconds at HKLM\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse. 

    2. Performance data collection process unable to store data in the Data Warehouse in a timely manner

    3. Event data collection process unable to write data to the Data Warehouse. Failed to store data in the Data Warehouse. The operation will be retried.
    Exception 'SqlTimeoutException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    Timeout occurred while trying to bulk copy data to Event.EventStage table.
    Current Timeout Value: 30 second(s)
    This timeout can be increased by adding a registry key (type: dword 32 bit, value: revised timeout in seconds) named : Bulk Insert Command Timeout Seconds at HKLM\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse. 

    AD

    Monday, November 18, 2019 6:23 AM

All replies

  • Hi AD,
     
    From the error message, it shows SQL time-out exception. Please refer to the following link to add “Bulk Insert Command Timeout Seconds”, Set this value to 40 seconds or higher according your environment.

    https://support.microsoft.com/en-in/help/3029227/data-warehouse-logging-improvements-in-opsmgr-2012-r2-ur5-that-help-tr

     
    Hope it can help.
     
    Best regards.
    Crystal

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, November 18, 2019 8:04 AM
  • This sounds like you may have a config churn where your data retention tables are trying to process too much data, or the table is so big that regular data trying to be written to it is failing and then causing timeout errors.

    In your case its the Perf.PerformanceStage table so PerformanceData is having this possible issue. I would try looking at this table in your OperationsManagerDW and checking the size of it, or better yet use the tool DWDataRP which you can download which can show all the DW tables and its retention periods which you can minimize the amount of data it keeps.

    Also run the "Data Volume by Management Pack"  report which i think is in the System Centre Core Monitoring Folder so you can see which are the noisiest management packs, this also shows the performance data its trying to write so you can get an idea where its coming from.

    If you find your table is too big then you may have to purge data from this table using a SQL query, either by removing a certain amount of records or purging the whole table (depending if you need to keep the data for historical reasons) then perform a shrink on the database to get the space back and some point.


    Website: www.walshamsolutions.com Technical Blog: https://www.walshamsolutions.com/technical-blog Personal Blog: https://www.walshamsolutions.com/personal-blog Twitter: Dwalshampro

    Monday, November 18, 2019 9:12 AM
  • Hi AD,

    How's everything going? If there's any update, please let us know.

    Best regards.
    Crystal


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, November 21, 2019 9:06 AM
  • Hi AD,

    Long time not heard from you. If there's any update, and we can discuss together, feel free to post back.

    Thanks and have a nice day!

    Best regards.
    Crystal


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, November 26, 2019 8:52 AM