Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Archive > 2017December18 - Deletes > Unable to load some maps in the Web Console

Unable to load some maps in the Web Console

Updated September 14, 2016

Overview

Maps can fail, take a long time or time out when loading in Network Atlas. The following error occurs in 

C:\ProgramData\Solarwinds\NetworkAtlas\NetworkAtlas.log:

2256-11-15 12:12:17,218 [27] ERROR SolarWinds.InformationService.Core.InformationService - (null) Exception caught in method SolarWinds.InformationService.Core.InformationService.Query
System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered.

Environment

NPM 12 and earlier

Cause 

Some interfaces in the map have invalid values for status or statistic polling.

Resolution

1. Create a backup of the Orion database.

2. Run the following queries against the Orion database:

UPDATE [dbo].[Interfaces] SET [PollInterval]=120 WHERE [PollInterval]=0
UPDATE [dbo].[Interfaces] SET [StatCollection]=15 WHERE [StatCollection]=0

3. Verify the issue is cleared by attempting to load the affected map again.

 

 

 

Last modified

Tags

Classifications

Public