NetXMS Support Forum

Hello

Any tips how to solve following error message, i get it when trying to migrate from MSSQL to Postgresql?

Migrating table snmp_ports
SQL query failed (23505 ERROR:  duplicate key value violates unique constraint "
snmp_ports_pkey"
DETAIL:  Key (id)=(1) already exists.):
INSERT INTO snmp_ports (id,port,zone) VALUES (?,?,?)
Failed input record:
   id = "1"
   port = "161"
   zone = "0"
Database migration failed.

Hi,

looks like wrong primary key was set during PostgreSQL DB init. What NetXMS version you are using?

Best regards,
Victor

Hello

Version is latest. I got it fixed by removing records from snmp_ports tabel. There were two records, both with id 1. After migration completed i re added settings with netxms.

Egert

It was caused by a bug in DB init script (wrong primary key). We have fixed it, fix will be included into next patch release.

Best regards,
Victor