Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Interface details page takes a while to load Interface tables via DB Schemas due to old v10.7 stored packages - Orion.Interfaces.

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

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

Views: 1,335 Votes: 2 Revisions: 5


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.


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


The following are cause the errors:

Interface Table was missing these 4 new columns

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


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.


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. (NPM 11.5.3)
  • Orion.Interfaces. (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