IPAM SQL DB update issue

Rene Paquin 36 Reputation points
2024-06-11T19:19:34.5566667+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.'.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,317 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 106.5K Reputation points
    2024-06-11T21:04:57.4666667+00:00

    Not sure that you are asking in the right place.

    From an SQL Server perspective, the error message is crystal clear. You are trying to create a unique index, and the table has duplicate data for that index. You need to either clean up the data or reconsider the index definition.

    Now, it seems that you not have defined this index yourself, but it is part of some product IPAM (that I have never heard of before), and the IPAM vendor apparently found it a good idea to set up this unique index. And maybe the vendor had all reason to assume the columns in the index are unique, but someone locally has meddled with the data, resulting in this error. Then again, maybe the vendor is making an incorrect assumption.

    I think you need to find a support forum for IPAM, as the answer requires knowledge about that schema-conversion script.

    2 people found this answer helpful.
    0 comments No comments