Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > User Device Tracker (UDT) > UDT upgrade error: Invalid column name 'IPAddressID'. Could not use view or function 'UDT_IPDNS' because of binding errors

UDT upgrade error: Invalid column name 'IPAddressID'. Could not use view or function 'UDT_IPDNS' because of binding errors

Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 5 Votes: 0 Revisions: 4

Overview

This article provides steps to resolve the following error while upgrading UDT 3.x:

Invalid column name 'IPAddressID'. Could not use view or function 'UDT_IPDNS' because of binding errors

 

Environment

UDT version 3.0 or later 

Resolution

Warning: SolarWinds strongly recommends that you create a full backup of your database. The following command will create permanent changes to your database.

1.  Run the following command for Orion DB using SQL Studio:

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UDT_IPAddress]'))
DROP VIEW [dbo].[UDT_IPAddress]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[UDT_IPAddress] 
AS
SELECT ip.EndpointID, ip.IPAddress, ip.RouterNodeID, ip.FirstSeen, NULL AS LastSeen, ip.RouterPortID, ip.ID, ip.IPAddressID
FROM [dbo].[UDT_IPAddressCurrent] ip with(nolock)
UNION ALL
SELECT ip.EndpointID, ip.IPAddress, ip.RouterNodeID, ip.FirstSeen, ip.LastSeen, ip.RouterPortID, ip.ID, ip.IPAddressID
FROM [dbo].[UDT_IPAddressHistory] ip with(nolock)
GO




IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[UDT_DNSName]'))
DROP VIEW [dbo].[UDT_DNSName]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[UDT_DNSName] 
AS
SELECT dns.IPAddress, dns.DNSName, dns.FirstSeen, NULL AS LastSeen, dns.ID, dns.IPAddressID
FROM [dbo].[UDT_DNSNameCurrent] dns with(nolock)
UNION ALL
SELECT dns.IPAddress, dns.DNSName, dns.FirstSeen, dns.LastSeen, dns.ID, dns.IPAddressID
FROM [dbo].[UDT_DNSNameHistory] dns with(nolock)
GO

 

2. Re-run the configuration wizard.

 

 

 

 

 

 

Last modified
04:01, 23 Jun 2016

Tags

Classifications

Public