Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > IP Address Manager (IPAM) > 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: November 1, 2017

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

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.

 

Last modified

Tags

Classifications

Public