No Historical Data for ANY Interfaces after installed NPM12.5

Question

A newly installed NPM12.5, the node status are all fine but all interfaces has no historical data, SNMPWalk is fine, but [dbo].[InterfaceTraffic] is no single record. What could be the problem?

Empty Table

Real-time Interface data is available

While no any historical data

OID reading looks fine

i_like_eggs · Answer

you could re run the SolarWinds maintenance manually and see if it clears up the errrors, still id recommend contacting SolarWinds Support with the errors you've mentioned

Start Database Maintenance in the SolarWinds Orion > Advanced Features program folder.

Click Start.

jinwu · Answer

Seems to be SQL problem? Error log says:

2019-09-10 02:15:06,779 [1] ERROR SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - Failed to execute procedure: dbm_InterfaceErrors_DetailToHourly

System.Data.SqlClient.SqlException (0x80131904): UNION ALL view 'SolarWindsOrion.dbo.InterfaceErrors_Detail' is not updatable because a partitioning column was not found.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

2019-09-10 02:15:06,795 [1] ERROR SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - Failed to execute procedure: dbm_InterfaceErrors_HourlyToDaily

System.Data.SqlClient.SqlException (0x80131904): UNION ALL view 'SolarWindsOrion.dbo.InterfaceErrors_Hourly' is not updatable because a partitioning column was not found.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

2019-09-10 02:15:07,170 [1] ERROR SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - Failed to execute procedure: dbm_InterfaceTraffic_DeleteStale

System.Data.SqlClient.SqlException (0x80131904): UNION ALL view 'SolarWindsOrion.dbo.InterfaceTraffic_Daily' is not updatable because a partitioning column was not found.

DELETE FROM dbo.[InterfaceTraffic_Daily] WHERE DateTime < '20180806'

2019-09-10 02:14:28,417 [STP DatabaseProcessing Thread #0] ERROR SolarWinds.Collector.SqlErrorHelper - CanRepeat: false. Errors:C:16 N:4436 S:12 msg:UNION ALL view 'SolarWindsOrion.dbo.InterfaceTraffic_Detail' is not updatable because a partitioning column was not found.

2019-09-10 02:14:28,417 [STP DatabaseProcessing Thread #0] ERROR SolarWinds.Collector.DBProcessing.DBProcessingWorkerWithAccess - Commit of  - SolarWinds.Interfaces.SNMP failed. System.Data.SqlClient.SqlException (0x80131904): UNION ALL view 'SolarWindsOrion.dbo.InterfaceTraffic_Detail' is not updatable because a partitioning column was not found.

jinwu · Answer

It is a new installation, Nevertheless, the platform is up and running for a few days. The polling settings are all default.