Primary key for table 'servoy_releases' is not unique

Classic Servoy
1

Hi All

I have this error when trying to import any solution into our servoy 4.1.6 server using Sybase10 on a Mac.

The server also has a Servoy 6 server on it, but that is running on different ports, and a different database (Postgres)

The full error on import is:

[error] com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -193: Primary key for table ‘servoy_releases’ is not unique

I have tried deleting and re-importing the solution (it deletes but still fails to re-import). I have also tried to update sequences for all databases from admin, but that only seems to affect databases created by me.

I’d be grateful for any ideas…

Bevil

2

Can you try in Servoy 6.0 (export and import same solution). Does it work ?

3

Hi Laurian

I am sure my solution will work in 6, however my main server is still in v.4. I think the problem is with the server / server database rather than in my export…

Is there something I can check on the server?

Thanks

Bevil

4

When you delete all solutions is there something left in table ‘servoy_releases’ ? Maybe it got corrupted somehow… (check with external sql tool)

5

Hi Laurian

I had a look but couldn’t find a useable servoy_releases table… I’ll have another look…

Bevil

6

Thunder:
Hi Laurian

I had a look but couldn’t find a useable servoy_releases table… I’ll have another look…

Bevil

it’s in the servoy_repository database