Missing data in OC Metrics view for the sqlserver probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Scenarios:

• Operator Console (OC) Metrics Views do not display any data for the sqlserver probe even though the probe is not reporting any alarms
• QOS for sqlserver probe is not showing in OC Metric Viewer
• Metrics for sqlserver set up with windows Authentication are missing 
• ci_metric_id for sqlserver are not registered correctly and not correlating.

 

Errors in sqlserver_monitor.log:

sqlserver: Value of error Permission denied and error no. 13
sqlserver: SetNamedSecurityInfo failed: 5
sqlserver: ciSave - saving CI   [CA6D102xxxxxxxC8873CE152]


Environment

• DX UIM 23.4.*
• sqlserver probe any version

Cause

This issue may happen if the Windows authenticated user configured in sqlserver probe does not have the required access to the ..\nimsoft\niscache folder on the system where the sqlserver probe is installed.

If the probe cannot access the niscache folder, the ci_metric_id issued by the probe won't match the device, hence the QOS is stored to the DB, however, the correlation won't occur and the data will not show in OC. 

 

See sqlserver Access Prerequisites

Resolution

Steps to resolve the issue: 

1. Check if the Windows authenticated user configured in sqlserver probe has access to the \nimsoft\niscache folder. 
2. After providing access to the user to the niscache folder, restart the probe and the issue should be resolved after new QOS is sent.