Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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