NetOps dr-healthcheck.sh script returns errors

Products

• Network Observability
• CA Performance Management

Issue/Introduction

NetOps dr-healthcheck.sh script returns errors and creates a malformed CSV file.

 

When it is run the command shows these errors.

 

Gathering Input for Performance Management Sizing Tool... output will be written to /tmp/CAPM_sizer_input.csv
ERROR 2624:  Column "ros_used_bytes" does not exist
(standard_in) 2: syntax error
ERROR 4566:  Relation "ifstats_eqd" does not exist
ERROR 4566:  Relation "ifstats_eqd" does not exist
ERROR 4566:  Relation "ifstats_eqd" does not exist
ERROR 4566:  Relation "ifstats_eqd" does not exist
select (
ERROR 4856:  Syntax error at or near ")" at character 8
LINE 1: select ) as sum_of_not_null from ifstats_eqd where item_id= ...
               ^
ERROR 4566:  Relation "ifstats_rate" does not exist
(standard_in) 1: syntax error
./generateSizerInput.sh: line 304: [: -eq: unary operator expected

 

When importing the CSV file into the DX NetOps Sizing Tool we see a "This field is required" message in red text for the "Avg. Interfaces per Devices" entry.

 

Environment

All supported DX NetOps Performance Management releases

Cause

The script expects discovered and polled interface items. It determines the interface item count based on a count of Reachability data points from the port table for Reachability data. When it finds none it triggers the error.

Resolution

Discover interface items and allow it to poll them. Then rerun the dr-healthcheck.sh script.