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
A column restriction in the reporter.interfaces tables on the ifAlias column.
Release : 20.2
Component : NQRPTA - REPORTERANALYZER
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.