Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Errors when managing a custom property after an upgrade

Errors when managing a custom property after an upgrade

Updated April 19, 2017

Overview

After an NPM upgrade, errors similar to the following occur when managing a custom property or when importing new values:

  • 'Category' is a system property that already exists 
  • Row 1 "Value" from spreadsheet cannot be converted to "Integer Number" format

Environment

All NPM versions

Cause 

These errors are displayed because the custom property name already exists in the list of reserved words in custom property names. These reserved words are used in other areas within Orion and creates a with custom properties. The Manage Custom Properties menu will prevent creating a new custom property that matches any word in the list.  

Resolution

Existing custom properties that were not reserved until after an Orion upgrade must be migrated to a custom property using a unique name.

  1. Export the data of the conflicted custom property to an MS Excel spreadsheet.
  2. Rename the conflicted custom property in the exported spreadsheet. For example, rename category to category1.
  3. Go to All Settings > Manage Custom Properties, and then create a new custom property using the renamed property.
  4. Import the values from the spreadsheet.
  5. Verify that the custom properties were successfully imported.

 

Last modified

Tags

Classifications

Public