Need to know about the alert message

book

Article ID: 109716

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction



What does this alarm text mean:
Profile: SQL1/long_jobs/Run Query - DB Provider: Code=0x0x80004005 Source=Microsoft Cursor Engine Description=Data provider or other service returned an E_FAIL status.

Environment

Release: MSPNSP99000-9.0-Unified Infrastructure Mgmt-Server Pack-on Prem MSP
Component:

Resolution

It appears this is coming from the "sqlserver" probe. There is an out of the box "checkpoint" (or "template") called "long_jobs".
You might get there by going to the IM console, find the robot with the 'sqlserver' probe. Open the configuration for the sqlserver probe. Go to the "Templates" tab. Open the template "long_jobs"

<Please see attached file for image>


This template monitors all queries running longer than defined threshold in seconds. the default is "10" seconds.

You can change this if desired. More info: https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-metrics As for what this message means: "Profile: SQL1/long_jobs/Run Query - DB Provider: Code=0x0x80004005 Source=Microsoft Cursor Engine Description=Data provider or other service returned an E_FAIL status" This is coming from MS SQL server.
CA does not have a definition for the message.
There are some articles about "Data provider or other service returned an E_FAIL status" on the Microsoft sites. They may be able to assist.

Attachments

1558698159160000109716_sktwi1f5rjvs16j7z.jpeg get_app