UMP PRD error Invalid column name 'samplesok'

Document ID : KB000004601
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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