UMP PRD error Invalid column name 'samplesok'

book

Article ID: 4601

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

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)

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.

Environment

UIM 8.47 /cdm/cluster

Resolution

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

ump_qoschart_8.4.7_HF2.zip