Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > IP Address Manager (IPAM) > IPAM - Knowledgebase Articles > Credentials for scope scans page is empty of credentials in IPAM Settings

Credentials for scope scans page is empty of credentials in IPAM Settings

Updated January 10, 2018

Overview

When you select Settings > All Settings > IPAM Settings > Credentials for scope scans, the Manage Credentials page does not list any of the supplied credentials, and the box is a little off (as shown below):

2018-01-05_1140.png

 

In addition, when you attempt to load the page, the following error is found in the IPAM.BusinessLayer.log:

 

2018-01-05 16:38:32,709 [85] WARN  SolarWinds.Orion.Core.SharedCredentials.Utility.ReflectionHelper (null) - Missing end property 'Password' in the CredentialProperty table of the Orion database for the class SolarWinds.IPAM.Storage.Credentials.WindowsCredentialDataObject.  CrendentialID = 8
**** 2018-01-05 16:38:32,709 [85] WARN  SolarWinds.Orion.Core.SharedCredentials.Utility.ReflectionHelper (null) - Missing end property 'UserName' in the CredentialProperty table of the Orion database for the class SolarWinds.IPAM.Storage.Credentials.WindowsCredentialDataObject.  CrendentialID = 8

Environment

  • IPAM 4.6

Cause 

This issue is caused by corrupted data within the CredentialProperty table within the database. If the property information is missing or corrupted, that page is not able to properly translate the results through SQL query, resulting in nothing being displayed.

Resolution

  1. Open the IPAM database.
  2. Query the Credential table:
    Select * from Credential where CredentialOwner = 'IPAM' and ID not in (select credentialid from credentialproperty)
  3. This should find the credential with missing information in the credential property table.
  4. Run a SQL statement to remove that credential ID from the Credential table.

 

If this finds no credential, then SolarWinds recommends removing all the credentials and credential properties that have a CredentialOwner of IPAM. Then add them back in.

 

 

 

 

Last modified

Tags

Classifications

Public