Error 193 Primary key for table 'servoy_elements' not unique

Classic Servoy
1

Hello,

We are receiving the following error message:

com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -193: Primary key for table ‘servoy_elements’ is not unique

Config :

Servoy 2.0.4 trial
Windows 2000 serveur SP4
Celeron 1.8 Ghz, 512Mb Ram
Db Sybase-Servoy/UserData

What lead to the error:

We had a release (3) of our “test” solution that we suppressed, then we restarted making another third release and activated it.
We went doing some modifications on some forms.
It seems that if we do modifs on 2 or more forms and want to leave the Designer, the error message comes up. It seems that if we do modifs on only one form, we do not get that error.
We were able to reproduce that error in the case we modified more than 1 form.

Thanks for your help on this.

Nicolas

2

it looks like a sequence that is not working quite right.

Can you export the solution and if you do a clean install of 2.0.4 or 2.1b5 and then import youre solution into that one. Does it then work?

i will look if i can see why youre sequence is not working