Submit a ticketCall us
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: 10 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

Tags

Classifications

Public