Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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: 70 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

Tags

Classifications

Public