Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Network Configuration Manager (NCM) > Config Wizard failed [Error while executing script- Invalid object name 'dbo.NCM_DeviceTemplates']

Config Wizard failed [Error while executing script- Invalid object name 'dbo.NCM_DeviceTemplates']

Created by Frederick Flores, last modified by MindTouch on Jun 23, 2016

Views: 100 Votes: 2 Revisions: 5

Overview

 

The following error occurs when running Configuration Wizard during an upgrade from NCM v7.3 to v7.4:

Config Wizard failed [Error while executing script- Invalid object name 'dbo.NCM_DeviceTemplates']

 

Environment

NCM v7.3

Cause 

The NCM tables from the Orion Database have different dbo owners (schema).

Resolution

  1. Use an SA account when running the Configuration Wizard or an account that has the permissions listed in the Fix the required permission to the database issue in Configuration Wizard article.
  2. You can drop this view - NCM_Nodes and run the Configuration Wizard again to recreate that view.

Notes:

There were cases where dropping those tables with different dbo owners then running the configuration wizard worked but some cases it did not.

You may receive another error when you get past the original error in the configuration wizard of: Exception while configuring plugin SolarWinds NCM Integration Plugin Component Orion Database Update. Invalid Object Name 'NCM_Nodes' 

 

Last modified
21:04, 22 Jun 2016

Tags

Classifications

Public