ERROR: Relation "XXXX" does not exist

Products

• CA Spectrum
• CA Performance Management - Usage and Administration

Issue/Introduction

We see these in Performance Management Data Aggregator  Exception.log:

2024-08-05 10:48:57,2852024-08-05T10:48:57,285 | ERROR | ExceptionLog | An existing application exception RECURRED (Key=aba1758e09477afba5bfa35b
...bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4566) ERROR: Relation "SDN_WIRELESS_ACCESS_POINT_rate" does not exist | (ExceptionLogger.java:104)

Environment

At least 23.3.7 and older

Cause

That means we don't have any poll data for referenced tableDE612149 .

Resolution

We will move this log to DEBUG level.

Additional Information

Defect DE612149