Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > Interface details page takes a while to load Interface tables via DB Schemas due to old v10.7 stored packages - Orion.Interfaces.4.1.0.4.sqlpack

Interface details page takes a while to load Interface tables via DB Schemas due to old v10.7 stored packages - Orion.Interfaces.4.1.0.4.sqlpack

Created by Kevin Twomey, last modified by MindTouch on Jun 23, 2016

Views: 38 Votes: 2 Revisions: 5

Overview

This article provides brief information and steps to resolve issues with SWIS and DB tables posting upgrade from NPM 10.7 to NPM 11.5.3.

Interfaces Tables using DB Schemas due to old 10.7 stored packages - Orion.Interfaces.4.1.04.sqlpack 
Cannot open Interface Details Page will not open. Missing Table column.
 

  • Interface Details Pages fails to load with error:

Unexpect Website Error - LateCollisionsToday

  • CW fails with:

​Access to Path ‘C:\Program Files (x86\Solarwinds\Orion\Interfaces\Solarwinds.interfaces.strings.dll’ is denied.

Environment

NPM 11.5.3  SAM 6.3.2  IPAM 4.3.1  NCM 7.4.1   DPA 10.0.1  STM 5.0.1

Cause 

The following are cause the errors:

Interface Table was missing these 4 new columns

  • [LateCollisionsThisHour]
  • [CRCAlignErrorsThisHour] 
  • [LateCollisionsToday] 
  • [CRCAlignErrorsToday] 


OR

Interface Detail\Hourly\Daily Tables have new improved Table DB Structure in NPM 11.5.3, but the Orion environment is stuck on NPM 10.7 schemas.

Resolution

1. Stop IIS as it was blocking some core DLLs so Config Wizard (CW) could not run.
2. Find old NPM 10.7 schemas that needed to be removed.
3. Re-run CW.

New Interface tables are created in NPM 11.5.3 DB Structure and silent background DB Table migration should kick off. 


DB Maintenance Bug - Installer packages.

Diagrams showed different versions of the same files, there should only be one in this folder.

Instead had duplicates for interfaces but also for AssetInventory, F5, HWH and Wireless Tables:
For example Interfaces had:

  • Orion.Interfaces.6.0.5.544.sqlpack (NPM 11.5.3)
  • Orion.Interfaces.4.1.0.4.sqlpack (NPM 10.7)

 

Note: The issue occurs in other websites where the Interface Partition Tables were not being created as a result.
The SQL Stored Procedure called dbm_SlidePartitionedView tries to create new partition tables or new views, 
but not successful in creating New tables. 

 

The logs reflected the root cause. There were some upgrades and folders which contain more than one file for each package. 

The Packaging system then takes the older one and executes wrong scripts.

  • C:\Program Files (x86)\SolarWinds\Orion\Packaging\Active\Database\Prepared\ and
  • C:\Program Files (x86)\SolarWinds\Orion\Packaging\Active\Website\Prepared\ 


To fix this, purge the two folders of the older files and re-run CW with /repairpackages option. 
This fixed the website issues with charts and database.

The libraries in SolarWinds/Interfaces are fine. 
 

 

 

Last modified
22:33, 22 Jun 2016

Tags

Classifications

Public