cannot store new i18n keys??

Classic Servoy
1

Servoy Developer
Version 3.5.6-build 519
Java version 1.6.0_05-b13-52 (Mac OS X)
MSSQL

I cannot store new i18n keys in my existing solution!??
Of course I have created hundreds of i18n keys in the i18n table and they are listed in the editor. I have checked the solution and servoy developer settings and in both the i18n server and table is set correct.
What’s wrong??

Thomas Schnaus

2

Hi Thomas,

You get any error ? Nothing in the logs ?
Maybe your servoy-managed PK’s are out of sync on this table?

Hope this helps.

3

You get any error ? Nothing in the logs ?

That is what the log file say:
java.sql.SQLException: Violation of PRIMARY KEY constraint ‘PK__ea_i18n__515AF6DE’. Cannot insert duplicate key in object ‘ea_i18n’.

Maybe your servoy-managed PK’s are out of sync on this table?

How can I sync that?

Regards
Thomas Schnaus

4

Hi Thomas,

tgs:

Maybe your servoy-managed PK’s are out of sync on this table?

How can I sync that?

Easiest way is in the servoy-admin pages. Here you can update all the sequences per connection with 1 click.
In pre-servoy 4 you could also do it per table in the dataproviders window (in the properties dialog of the PK column)

Hope this helps.

5

Thank you Robert,

I have updated the sequences by your hint and i18n table is working again!
Perhaps the issue occurs because I restored the SQL database, or? However, next I know what to do is.

Nice weekend
Thomas Schnaus