UMP default reports are not generating

book

Article ID: 130465

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

In our Unified report Management portal, below default repots are configured.
Top N server by memory usage.
Top N server by disk usage.
Top N server by cpu usage.

Suddenly we are not getting these reports

Cause

the portal.log shows a problem accessing the SQL Server

28 Mar 2019 15:21:57,025 ERROR [PortalInitAction:111] com.firehunter.ump.exceptions.DataFactoryException
28 Mar 2019 15:21:57,025 ERROR [PortalInitAction:111] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
28 Mar 2019 15:21:57,026 ERROR [PortalInitAction:111] at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:304)
28 Mar 2019 15:21:57,026 ERROR [PortalInitAction:111] at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:1863)

Environment

UIM 8.51

Resolution

Tested the ODBC connection successfully using the stesp from https://comm.support.ca.com/kb/ODBC-Connectivity-Testing-Using-the-Microsoft-Data-Link-API-Tool/KB000056068

Reboot of the UMP Server resolved the case.