Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Archive > 2017December13 - Deletes > SAM 6.2 upgarde error: sys.selective_xml_index_paths (Transact-SQL) is missing or corrupted

SAM 6.2 upgarde error: sys.selective_xml_index_paths (Transact-SQL) is missing or corrupted

Created by William Muhle, last modified by Kevin.Swinson on Dec 13, 2017

Views: 782 Votes: 0 Revisions: 4

Overview

This article provides brief information and steps to resolve the following upgrade issue of SAM 6.2 or later:

Exception while configuring plugin Orion Core Services component Orion Database. An exception occurred while executing a Transact-SQL statement or batch.  sys.selective_xml_index_paths (Transact-SQL) is missing or corrupted. 

Environment

  • SAM version 6.2 and later
  • ​SQL Server 2012

Cause 

The SQL Server installation does not have the system table required.  This table was added into SQL Server 2012 in SP1. 

Resolution

1. ​Apply SP1 to the SQL 2012 server.

2. Rerun the installation.

 

 

 

Last modified

Tags

Classifications

Public