DX NetOps SNMP Refresh fails on NFA Devices

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Some devices in NetOps from the NFA data source fail to SNMP Refresh.

In the ODATA Wrapper log in D:/CA/NFA/ODATA/logs, you will see:

INFO   | jvm 1    | 2020/12/09 16:22:16 | Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'ifAlias' at row 40

Environment

Release : 20.2

Component : NQRPTA - REPORTERANALYZER

Cause

A column restriction in the reporter.interfaces tables on the ifAlias column.

Resolution

The following command should be run to increase the column size of the ifalias column of reporter db on mysql command prompt.

mysql reporter -unetqos -pnetqos -t -e "ALTER TABLE interfaces MODIFY COLUMN ifAlias VARCHAR(255);"

You should now be able to SNMP refresh.