Fields missing in vertica from errors in karaft.log

book

Article ID: 195660

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

1.)
SQLSyntaxErrorException: [Vertica][VJDBC](4566) ERROR: Relation "SDN_SLA_PATH_rate" does not exist
2.)
[Vertica][VJDBC](4566) ERROR: Relation "HEALTH_SCORE_rate" does not exist

Vertica database tables do not exist error on data aggregator 

Environment

Release : 20.2

Component : IM Reporting / Admin / Configuration

Resolution

This means no data has ever been loaded for that Metric Family, so we've never created the table and someone is trying to run a report against that Metric Family.

In this instance it was a test system with a production CAPC database so there were reports configured that did not have elements using these Metric Families.