UMP PRD error Invalid column name 'samplesok'

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

In UMP 8.47 when trying to view below mentioned asynchronous qos data from probes like cluster /cdm 

QOS_CLUSTER_NODE_STATE

QOS_CLUSTER_GROUP_STATE

QOS_COMPUTER_UPTIME

 

The error information is as follows: 

com.firehunter.ump.exceptions.DataFactoryException : null 

Info: 

 

SELECT sampletime, 

sampleavg, 

min_samplevalue, 

max_samplevalue, 

samplesok 

FROM DN_QOS_DATA_0027 

WHERE sampletime BETWEEN '2016-10-26 00:00:00.0' 

AND '2016-10-26 15:55:36.032' 

AND table_id = '817' 

ORDER BY sampletime ASC 

Stack Trace: 

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'samplesok'. 

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) 

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) 

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)

Environment

UIM 8.47 /cdm/cluster

Cause

In UIM 8.47 the query was changed to include data from the HN and DN tables.  These queries break with asynchronous data, since the samplesok column does not exist in the DB tables for this data.

Resolution

There is a hotfix available at below link to resolve this issue 

ump_qoschart_8.4.7_HF2.zip