Migrating fails
-
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 -
-
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login