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 > IPAM - Manage Subnets and IP Addresses and DHCP management views are empty after upgrade

IPAM - Manage Subnets and IP Addresses and DHCP management views are empty after upgrade

Updated: December 14, 2018

Overview

After upgrading to IPAM 4.5.2 to the latest version, Manage Subnets & IP Addresses and DHCP management views are blank. The IPAM.Attributes.Local.xml file does not contain references to the custom fields created.


Errors displayed\found:   
ERROR SolarWinds.IPAM.Client.SwisProxy.IpamInformationServiceProxy - (null)  Query Got Exception - Time : 2017-09-20 21:52:20
  Exception :RunQuery failed, check fault information.
Entity IPAM.GroupNodeAttr does not contain requested property Location_name of navigation property A.Custom
2017-09-20 21:52:20,609 [71] (97) ERROR Information - (null)  Error occurred when trying to execute SWQL statement: SELECT TOP 151 A.GroupId, A.GroupType as "t", A.FriendlyName as "text", A.Address as "a", A.AddressMask as "m", A.CIDR as "cidr", A.AvailableCount, A.UsedCount, A.ReservedCount, A.TransientCount, A.PercentUsed, A.Comments, A.StatusName, A.GroupIconPrefix, A.StatusIconPostfix, A.Role, A.Custom.Location_name, A.Custom.NetType, A.Custom.NetSubType, A.Custom.NetSecurity, A.Custom.Owner, A.Custom.Company, A.Custom.DHCP, A.Custom.Router, A.Custom.ACL, A.Custom.Remedy FROM IPAM.GroupNode A  WHERE A.GroupId = 0 ORDER BY A.GroupType ASC, A.AddressN ASC, A.FriendlyName ASC, A.CIDR ASC

Environment

  • IPAM 4.5.2
  • IPAM 4.7 Hotfix 2

Cause 

The root cause is that IPAM.Attributes.Local.xml which should contain definitions for all custom properties and can be found in c:\Program Files (x86)\SolarWinds\Orion\Information Service\3.0\Schemas\ contains no definitions at all.

 

Regardless of custom props that are available in the database, they cannot be visible to SWIS due to missing definitions in IPAM.Attributes.Local.xml.

Resolution

This problem is resolved when IPAM regenerates the scheme in the XML file.

  1. Open http://localhost/Orion/IPAM/admin/ad...bute.list.aspx.
  2. Modify any custom field on the page, for example, Description.
  3. Click Save.

After you click Save, IPAM regenerates the scheme in the XML file.

 

If you encounter this on IPAM 4.7, kindly create a ticket for our Support Engineers

 

 

 

Last modified

Tags

Classifications

Public