Error importing solution

Classic Servoy
1

When importing solutions from our development server into our testing server I’m currently getting the following error:

com.servoy.j2db.persistence.RepositoryException: com.sybase.jdbc3.jdbc.SybSQLException: ASA Error -193: Primary key for table ‘servoy_element_properties’ is not unique

This is happening no matter what solution I try and import.

2

It seems that the sequence numbering in the servoy repository tables got out-of-sync somehow.

You can try exporting all your solutions from your test server, stop developer, drop the repository tables (using a db backend, make a backup first) and start developer, it will create a new fresh set of repository tables.

Rob