IPAM database update issue

Rene Paquin 36 Reputation points
2024-06-11T14:56:18.0766667+00:00

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,

Rene

The IPAM database schema conversion from version 6.3.0.1 to version 10.0.0.1 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
    2024-06-28T17:20:27.5566667+00:00

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