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 > 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