Network Management

Clear Inventory Queue in Network Configuration Manager

This article provides steps to manually clear the Inventory Queue in Network Configuration Manager (NCM).

First published date

10/10/2018 1:56 PM

Last published date

1/13/2022 1:06 PM

Overview

To unify each of the inventory tasks NCM uses GUID which occasionally may get malformed and result in NCM not being able to work with that task. You may for example receive the below error while attempting to clear manually the Inventory Queue: 
Cirrus.InventoryQueue.Clearlnventory failed, check fault information. Guid should contain 32
digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)

It may also be necessary if the database collation is not supported.

Product section

Network Configuration Manager

Cause

  • Malformed GUID
  • Incorrect database collation

Resolution

Complete the following steps to clear the Inventory Queue in Network Configuration Manager (NCM):

  1. Create a backup of your database.
  2. Open Orion Database Manager.
  3. Connect to your Orion database.
  4. Right-click on the Orion database and select New Query
  5. Enter the following query and click Execute query
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.
DELETE FROM [dbo].[NCM_InventoryQueue]