DX Infrastructure Management

Expand all | Collapse all

alerts on nimsoft DB

  • 1.  alerts on nimsoft DB

    Posted 05-04-2014 02:06 PM

    hi,

     

    i am geting in almost each day not on specific time this alerts:

     

    Subsystem: ServiceLevelManagement

    Probe: data_engine

    Message: Failed to insert QoS data into the database, check that the database is running.

     

    Subsystem: Database

    Probe: data_engine

    Message: [Microsoft OLE DB Provider for SQL Server] Insert bulk failed due to a schema change of the target table.

     

    Subsystem: ServiceLevelManagement

    Probe: data_engine

    Message: Failed to insert QoS data into the database, check that the database is running

     

    in this order of messaging one after the other.

     

    does anyone knows this meesages and might know how to prevent it?

     

    best regards!



  • 2.  Re: alerts on nimsoft DB

    Posted 05-05-2014 11:28 AM

    I think I've only gotten these when doing upgrades, or when I've done
    failovers on the database cluster.

     

    Do you have any information when it comes to your database? Is it
    clustered? Located network wise compared to data_engine?

     

    What version of data_engine are you using?



  • 3.  Re: alerts on nimsoft DB

    Posted 05-05-2014 07:58 PM

    We get these every night when the sql db is being backed up, I just put an exclusion info the backup time.



  • 4.  Re: alerts on nimsoft DB

    Posted 05-06-2014 10:39 AM

    Could it be that the backup process is putting too much strain on the
    database? Maxing IO, bandwidth, or something? And it causes data_engine
    to freak out a bit?



  • 5.  Re: alerts on nimsoft DB

    Posted 05-07-2014 10:55 PM

    That is my guess as it's only a few minutes that nimsoft has the issue.  Maybe that there is some type of lock on the table/s as well.



  • 6.  Re: alerts on nimsoft DB

    Posted 05-18-2014 11:19 AM

    hi,

     

    its started few mountus ago to happaned around the backup hour each day, but at the past few weeks it happaned in mid of day..

    its happend for few seconds and then i get repaired message..

     



  • 7.  Re: alerts on nimsoft DB

    Posted 05-18-2014 04:45 PM

    Did someone perhaps make a script or something at that time to collect data from the database? Or to generate some report or something.



  • 8.  Re: alerts on nimsoft DB

    Posted 05-25-2014 01:17 PM

    no.. nothing at this hours.. i dont touch db..



  • 9.  Re: alerts on nimsoft DB

    Posted 10-31-2018 12:44 AM

    So how do we disable these alerts or Reduce the Severity of this kind of Alarms. Can't see any option in data_engine probes to modify. 

     

    anyone done anything like this ?

     

    Thanks

    T



  • 10.  Re: alerts on nimsoft DB

    Posted 10-31-2018 09:37 AM

    These alarms cannot be disabled, but you can reduce the severity of the second alarm as explained in the Knowledge Document:  KB000034364 : What is the Meaning of the alarm: Insert bulk failed due to a schema change of the target table.  It may be necessary to reduce the severity of the first alarm through a nas Auto-Operator Pre-Processing Rule as explained in the Knowledge Document: KB000034685 : Lower severity of an alarm using preprocessing rule