Share via

IPAM SQL DB update issue

Rene Paquin 36 Reputation points
2024-06-11T19:22:37.04+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 DHCP
Windows DHCP
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.DHCP: Dynamic Host Configuration Protocol (DHCP). A communications protocol that lets network administrators manage centrally and automate the assignment of Internet Protocol (IP) addresses in an organization's network.
1,039 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. OLATUNJI AYODELE ABIDEMI 0 Reputation points
    2024-06-11T19:32:50.59+00:00

    Generally, to upgrade your IPAM server and update an external SQL Server database, you would need to: 1. Backup your existing IPAM settings and data. 2. Install a new server with Windows Server 2022 and with the IPAM feature enabled. 3. Once the new server is up and running, import the IPAM settings and data you saved earlier. As for the SQL Server database, I would recommend you backup the existing database first, then restore the backup to an instance of SQL Server that supports Windows Server 2022. Please note, before starting these processes ensure you have the correct administrative rights and ensure that all the dependencies are met, such as any necessary SQL Server connectors or authentication credentials. Remember that the exact process may vary depending on your environment. Hence you might need to consult a certified Microsoft professional or the official Microsoft documentation if you encounter any issues that are specific to your configuration. Also, it's important to remember to always make a backup of your data before starting the upgrade process. I hope this information helps!

    0 comments
  2. Rene Paquin 36 Reputation points
    2024-06-13T11:40:44.3466667+00:00

    Thank you. I will give that a try.

    Rene

    0 comments
  3. Rene Paquin 36 Reputation points
    2024-06-17T17:16:17.2+00:00

    I was able to resolve the sql issues and now when attempting to update the IPAM from 6.3.0.1 to IPAM version 10.0.0.1 I get the following error. Any ideas?User's image

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.