Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Server & Application Monitor (SAM) > 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 MindTouch on Jun 23, 2016

Views: 6 Votes: 0 Revisions: 3

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
03:40, 23 Jun 2016

Tags

Classifications

Public