Primary key errors

[mpwiedemann]

Hello all,

Using Servoy 1.2 rc9 on WinXP w/ MS-SQL2000 as repository. We keep getting PK errors such as :


java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Violation of PRIMARY KEY constraint 'PK_servoy_uuids'. Cannot insert duplicate key in object 'servoy_uuids'.

We also get the same sorts of errors in the Servoy_Elements table when attempting to add elements to a form.

Thanks in advance,
Martin

[Jan Blok]

This seems quite unlikly to us this happens out of the blue...did you do anything in the servoy_XXXX tables yourself?
When did/does this happen?

[Guest]

Only the upgrade to 1.2 rc9

[david]

I *think* something similar has happened to me. It's hard to tell because I just fixed the problem and didn't delve to deep into the reasons. But it was just after installing a new version over an older version and some of the tables in a solution with a connection to MySQL lost their primary key sequence. You'll have to search for the highest current pk value and reset your pk incrementation accordingly.

The next time I upgrade my production server, I am going to export all of my solutions, do a clean install, recreate all custom data connections, and then import the solutions.

- david

[Jan Blok]

Only the upgrade to 1.2 rc9

Seems very unlikly to us, so many upgraded there repository...

...tables in a solution with a connection to MySQL lost their primary key sequence...

Is not related to a repository update.

But is it possible for us to get a db dump/db backup of that repository?

[david]

In my case, it has been several months since it has happened so no old backups left. I did have it happen a number of times though so I'll try to be aware of the situation if it comes up again.

- david