Network Management

Clear out the DPE when NCM stuck in Post-Processing

This article describes the issue when the DPE in NCM gets stuck and does not clear out when using it.

First published date

10/12/2018 5:28 PM

Last published date

5/13/2026 2:31 PM

Overview

This article describes the issue when the DPE queue in NCM gets stuck and does not clear out it is used.

Product section

Network Configuration Manager

Cause

This issue occurs when there are old tasks in the queue that are stuck or the request is not getting through.

Resolution

  1. Log in to the Orion server hosting NCM.
  2. Stop all services on Orion service Manager
  3. Run Database Manager (Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager).
  4. Add Default Server
  5. Run following command to expand (Orion database):  
    NetPerfMon (default name)
  6. Right-click on the following table and select Query Table:  
    DPE_DataProcessorQueue
  7. Overwrite query with below one: 
    -- 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.


TRUNCATE TABLE DPE_DataProcessorQueue
  8. Click Execute Query.
  9. Start all Orion services on Orion Service Manager