locked
SCOM 2012 R2 Event ID 2115 RRS feed

Answers

  • Hi Sir,

    Have you checked this for troubleshooting :

    "

    The following Performance Monitor counters on a Management server provide information about Database and Data Warehouse write action insertion batch size and time:

    • OpsMgr DB Write Action Modules(*)\Avg. Batch Size
    • OpsMgr DB Write Action Modules(*)\Avg. Processing Time
    • OpsMgr DW Writer Module(*)\Avg. Batch Processing Time, ms
    • OpsMgr DW Writer Module(*)\Avg. Batch Size
    If the batch size is increasing (for example, the default batch size is 5,000 items), this indicates either that the Management server is slow to insert the data to the database or data warehouse, or that it is receiving a burst of data items from the agents or the gateway servers.

    By examining the Database and Data Warehouse write action account Average Processing Time counter, we can understand how long it takes on average to write a batch of data to the database and data warehouse. Depending on the time that it takes to write a batch of data to the database, this may provide an opportunity for tuning.


    "

    https://support.microsoft.com/en-us/kb/2681388

    Best Regards,

    Elton


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

    Wednesday, October 5, 2016 5:44 AM
  • This has been explained here : https://social.technet.microsoft.com/Forums/windows/en-US/48a39b82-1163-43d8-bfdb-b98470f0098a/scom-exchange-microsoftexchange15mailboxstatssubscriptionrule-failed-to-store-data-in-the-data?forum=operationsmanagergeneral

    Short version : some of your users have too many mail aliases, or some other property that make them take more than 1024 characters and so they can't be inserted in the database.

    Thursday, October 6, 2016 10:11 PM

All replies

  • Hi Sir,

    Have you checked this for troubleshooting :

    "

    The following Performance Monitor counters on a Management server provide information about Database and Data Warehouse write action insertion batch size and time:

    • OpsMgr DB Write Action Modules(*)\Avg. Batch Size
    • OpsMgr DB Write Action Modules(*)\Avg. Processing Time
    • OpsMgr DW Writer Module(*)\Avg. Batch Processing Time, ms
    • OpsMgr DW Writer Module(*)\Avg. Batch Size
    If the batch size is increasing (for example, the default batch size is 5,000 items), this indicates either that the Management server is slow to insert the data to the database or data warehouse, or that it is receiving a burst of data items from the agents or the gateway servers.

    By examining the Database and Data Warehouse write action account Average Processing Time counter, we can understand how long it takes on average to write a batch of data to the database and data warehouse. Depending on the time that it takes to write a batch of data to the database, this may provide an opportunity for tuning.


    "

    https://support.microsoft.com/en-us/kb/2681388

    Best Regards,

    Elton


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

    Wednesday, October 5, 2016 5:44 AM
  • Thanks Elton,

    Looks like some issue with the write module, I am not able to see any data when I select "OpsMgr DW Writer Module" on the server where I am facing issue, but in another server I can see the data. How can I check if write module is working properly or not, Data wareshouse account is distributed to all management server resource pool.

    Thursday, October 6, 2016 9:57 PM
  • This has been explained here : https://social.technet.microsoft.com/Forums/windows/en-US/48a39b82-1163-43d8-bfdb-b98470f0098a/scom-exchange-microsoftexchange15mailboxstatssubscriptionrule-failed-to-store-data-in-the-data?forum=operationsmanagergeneral

    Short version : some of your users have too many mail aliases, or some other property that make them take more than 1024 characters and so they can't be inserted in the database.

    Thursday, October 6, 2016 10:11 PM