We have scheduled custom Dashboards from Performance Center to send reports via email.
The PDF report received has Views that show failure and reference a Query ID for log files. For example some Views show this instead of the expected graph.
When reviewing the Data Aggregator karaf.log file (default path /opt/IMDataAggregator/apache-karaf-<version>/data/log) we see errors that reference the following Vertica error.
[Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool scheduled_short_rib_processing [Request Too Large:Memory(KB) Exceeded
Insufficient resources on the Data Repository cluster nodes.
All supported DX NetOps Performance Management releases
These errors and report failures are rooted in the Data Repository (DR) DB system. The DR DB in the environment this was reported in was found to be severely under resourced.
Unfortunately there isn't any tuning that we could recommend to help resolve these report failures. Any tuning performed would just take the limited resources available away from other things resulting in issues in other areas.
Only two things would resolve these report failures in the presence of a severely under resourced system like this. The first is a maybe and isn't a guaranteed solution long term. The report resulting from the first option, by the time it's narrowed down to a request size that doesn't hit resource failures, may not be of much value. The second is a guaranteed solution. It would resolve this problem though it may not be the easiest solution to implement.