Book a Demo

Author Topic: Duplicate key violation after project transfer  (Read 4936 times)

registered

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Duplicate key violation after project transfer
« on: January 30, 2018, 04:35:14 am »
Enterprise Architect 13.5
I transferred project from *.eap file to PostgreSQL database (need team access).
After migration, I`m unable to do anything on a project.
On any action, I'm having an error:
"duplicate key value violates unique constraint..."
It seemed that migration forget to update PostgreSQL sequences.
How do I fix it?

Nabil

  • EA User
  • **
  • Posts: 149
  • Karma: +5/-2
    • View Profile
    • View My LinkedIn Profile Here
Re: Duplicate key violation after project transfer
« Reply #1 on: January 31, 2018, 12:00:30 am »
I'm not sure will this help but try to repair the .eap file then try to transfer the model from .eap to dbms
Refer this page http://www.sparxsystems.com/enterprise_architect_user_guide/10/projects_and_teams/o389.html

Nabil
Nabil

Nizam

  • Prolab Moderator
  • EA User
  • *
  • Posts: 320
  • Karma: +15/-2
  • Model Sharing - Simplified
    • View Profile
    • Professional Model Collaboration
Re: Duplicate key violation after project transfer
« Reply #2 on: January 31, 2018, 04:06:24 am »
You can try 'Project Integrity Check'  to see if it resolves, also please check the dberror.txt in EA installation folder for more details on the Error.