Repository not saving 3.1.6

com.servoy.j2db.persistence.RepositoryException: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "servoy_elements_pkey"
org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "servoy_elements_pkey"

Just lost an hour’s worth of changes. Any ideas?

OK, I may have had 2 developers open and muddled up which one I was working on :frowning:

This is Servoy Repository right? So these are servoy managed sequences.
So then I guess going to the Admin pages and hitting the Update Table Sequences at the repository_server connection the would solve your problem.
Still strange that the sequence would get out of sync since this is stored in that very same repository.

Hope this helps.

Hi Robert,

Thanks for your advice. This rings echoes, we have been through this one before. Don’t think the update sequences thing works with repositories!

I vaguely remember being given a query by someone in the Servoy developer team to perform on the repository to update the offending sequence…