#50 MonEngine HkgcRetries not found. ASEMon Logger

[Anonymous]

ASEmon Logger Version 3.3.1
ASE Version
Erros in collector againt monEngines

ge=Invalid column name 'HkgcRetries'.
state=ZZZZZ
com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'HkgcRetries'.

    at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4112)
    at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3229)
    at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
    at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2842

)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2829)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:1459)
at asemon_logger.SamplingMetric.getCnt(SamplingMetric.java:131)
at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:235)
at asemon_logger.Collector.run(Collector.java:387)
2019/06/26 11:28:58.366 ferrytest_Engines - ERROR catch SQLException 207 Inval
id column name 'HkgcRetries'.

com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'HkgcRetries'.

    at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4112)
    at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3229)
    at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
    at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2842

)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2829)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:1459)
at asemon_logger.SamplingMetric.getCnt(SamplingMetric.java:131)
at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:235)
at asemon_logger.Collector.run(Collector.java:387)
2019/06/26 11:28:58.366 ferrytest_Engines - Error in loop. Error=207 SQL messa
ge=Invalid column name 'HkgcRetries'.
state=ZZZZZ
com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'HkgcRetries'.

    at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4112)
    at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3229)
    at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
    at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2842

)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2829)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:1459)
at asemon_logger.SamplingMetric.getCnt(SamplingMetric.java:131)
at asemon_logger.CollectorGeneric.getMetrics(CollectorGeneric.java:235)
at asemon_logger.Collector.run(Collector.java:387)

Looks like this is caused by some columns (i.e. HkgcRetries) which appeared in 15.7 SP136 branch and 16 SP02 PL02. So not in 16.0 SP02 PL01 - hence the errors.

Could we change conf/Engines_switch.xml to fix this?

<metricdescriptor>
<metricname> Engines </metricname>
<metrictype> GENERIC </metrictype>
<versionswitch>
<version lowerthan="15"> Engines.xml </version>
<version lowerthan="15.7"> Engines_V15.xml </version>
<version lowerthan="15.7.0.136"> Engines_V157.xml </version>
<version lowerthan="MAX"> Engines_V157SP136.xml </version>
</versionswitch>
</metricdescriptor>

[Jean-Paul Martin]

Hi,
sorry but the switching mecanism supposes all new functionalities are supported in higher versions, or change

lowerthan="15.7.0.136" 

with

lowerthan="16.0.02.02" 

if you have no monitored ASE between SP136 and SP141

Else force the colector : Engines_V157.xml rather than Engines_switch.xml

Best regards
Jpm