IPAM database update issue

Rene Paquin 36 Reputation points

I am attempting to upgrade our IPAM server from windows 2012R2 to Windows 2022. The isssue is updfating the IPAM database that is residing on an external SQL Server. The error is below. Any help appreciated.

Thank you,


The IPAM database schema conversion from version to version failed with error: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.IPv4ADDRESS' and the index name 'IPv4ADDRESS_UQ_VALUE_COMBINATION'. The duplicate key value is (0x0a110b08, 1, 329, 341).

Could not create constraint or index. See previous errors.

The statement has been terminated.. Your IPAM installation might not work properly.'.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,569 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bruce (SqlWork.com) 60,866 Reputation points

    The error is pretty clear. You have duplicate entries in the database, which must be fixed.