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