Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Historical data for wireless clients and interfaces is missing

Historical data for wireless clients and interfaces is missing

Updated: December 20, 2018

Issue

In the Orion Web Console, you cannot see historical data for some wireless clients and wireless interfaces.

In logs, you can find a similar error:

Violation of PRIMARY KEY constraint 'PK_Wireless_Interfaces_DETAIL'. Cannot insert duplicate key in object 'dbo.Wireless_Interfaces_DETAIL'. The duplicate key value is (Dec 01 2018  2:02PM, 431, 1863513).

Environment

NPM 12.4

Cause

When saving historical data for wireless clients and interfaces, the saving process breaks down.

Resolution

Applying this fix might result in performance degradation of your Orion Platform deployment.

Install the fix

  1. Download the fix from the following link:
    https://downloads.solarwinds.com/solarwinds/Release/HotFix/NPM-v12.4-Missing-Historical-Wireless-Data-Fix.zip
  2. Stop the Collector service.
  3. Create a backup of the following files outside of the SolarWinds installation folder. By default, the files are located as follows:
    •    C:\Program Files (x86)\SolarWinds\Orion\Wireless\SolarWinds.Wireless.Collector.dll
    •    C:\Program Files (x86)\SolarWinds\Orion\Wireless\SolarWinds.Wireless.Pollers.dll
    •    C:\Program Files (x86)\SolarWinds\Orion\Wireless\SolarWinds.Wireless.PollersJobs.dll
  4. Extract the downloaded archive and copy the files from the archive to the Wireless folder.
  5. Unblock the files using the following procedure:

    1. In File Explorer, right-click the .dll file.

    2. Select Properties from the pop-up menu.

    3. From the General tab, click Unblock and confirm the dialog.

  6. Start the Collector service.

Uninstall the fix

1. Stop the Collector service.

2. Replace the following files with their backups:
   C:\Program Files (x86)\SolarWinds\Orion\Wireless\SolarWinds.Wireless.Collector.dll
   C:\Program Files (x86)\SolarWinds\Orion\Wireless\SolarWinds.Wireless.Pollers.dll
   C:\Program Files (x86)\SolarWinds\Orion\Wireless\SolarWinds.Wireless.PollersJobs.dll

3. Start the Collector service.
 

Last modified

Tags

This page has no custom tags.

Classifications

Public