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

Cause

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

Environment

Release : 20.2

Component : NQRPTA - REPORTERANALYZER

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 -t - e "ALTER TABLE interfaces MODIFY COLUMN ifAlias VARCHAR(255);"

You should now be able to SNMP refresh.