No interface events seen in NetOps Portal

Products

CA Performance Management Network Observability

Issue/Introduction

The interface threshold profile is not creating events. The following error is seen in the DA karaf.log

ERROR | -Minute-thread-2 | 2021-07-13 17:47:32,441 | ExceptionLog | .ca.im.core.util.ExceptionLogger 104 | m.ca.im.common.core.util | | An existing application exception RECURRED (Key=e0b9e265d54b924f092e536aebdc5fedad794976), Recurrence count=87 : ThresholdScheduleTask caught exception : StatementCallback; bad SQL grammar [SELECT /*+ label(THRESHOLD_EVAL_NO_AGGREGATION) */ rc.profile_id, rc.eoc_time, rc.item_id, rc.esum1 AS r1, CASE WHEN (rc.esum1=0 and rc.csum1=1) THEN 1 ELSE 0 END as c1, rc.esum2 AS r2, CASE WHEN (rc.esum2=0 and rc.csum2=1) THEN 1 ELSE 0 END as c2, rc.esum3 AS r3, CASE WHEN (rc.esum3=0 and rc.csum3=1) THEN 1 ELSE 0 END as c3, rc.esum4 AS r4, CASE WHEN (rc.esum4=0 and rc.csum4=1) THEN 1 ELSE 0 END as c4 FROM ( SELECT pa.profile_id, pa.eoc_time, pa.item_id, (CASE WHEN GREATEST(pa.esum1,pa.esum2,pa.esum3,pa.esum4,0 ) = 1 THEN 1 ELSE 0 END) as raise_exists, (CASE WHEN GREATEST(pa.csum1,pa.csum2,pa.csum3,pa.csum4,0 ) = 1 THEN 1 ELSE 0 END) as clear_exists, pa.esum1, pa.csum1, pa.esum2, pa.csum2, pa.esum3, pa.csum3, pa.esum4, pa.csum4 FROM (SELECT 1128289 AS profile_id, 1626190800 AS eoc_time, r.item_id, CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 600 AND im_PctErrorsIn >= 0,1 ) THEN r.rinterval ELSE 0 END ) >= 60) THEN 1 ELSE 0 END esum1, CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 600 AND im_PctErrorsIn < 0,1 ) THEN r.rinterval ELSE 0 END ) >= 60) THEN 1 ELSE 0 END csum1,CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 600 AND im_PctErrorsOut >= 0,1 ) THEN r.rinterval ELSE 0 END ) >= 60) THEN 1 ELSE 0 END esum2, CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 600 AND im_PctErrorsOut < 0,1 ) THEN r.rinterval ELSE 0 END ) >= 60) THEN 1 ELSE 0 END csum2,CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 300 AND im_PctErrorsIn >= 1 ) THEN r.rinterval ELSE 0 END ) >= 300) THEN 1 ELSE 0 END esum3, CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 300 AND im_PctErrorsIn < 1 ) THEN r.rinterval ELSE 0 END ) >= 300) THEN 1 ELSE 0 END csum3,CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 300 AND im_PctErrorsOut >= 1 ) THEN r.rinterval ELSE 0 END ) >= 300) THEN 1 ELSE 0 END esum4, CASE WHEN (SUM( CASE WHEN (1626190800 - r.tstamp < 300 AND im_PctErrorsOut < 1 ) THEN r.rinterval ELSE 0 END ) >= 300) THEN 1 ELSE 0 END csum4,0 FROM ifstats_rate as r JOIN ifstats_300000_temp_profile_items_p i ON (i.profile_id=1128289 AND i.item_id=r.item_id) JOIN ( SELECT DISTINCT r2.item_id FROM ifstats_rate AS r2 WHERE r2.dto_sequence_id=14698274 AND r2.tstamp=1626190800 ) as i2 ON (i.item_id=i2.item_id) WHERE r.tstamp > 1626190200 AND r.tstamp <= 1626190800 GROUP BY r.item_id ) as pa ) as rc WHERE rc.raise_exists=1 OR rc.clear_exists=1]; nested exception is java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](2224) ERROR: Argument of CASE/WHEN must be type boolean, not type record