i18n inserts fails

Classic Servoy
1

After importing a .servoy file into an application server the server log has a whole list of entries like:

2014-02-07 15:51:43,007 ERROR [http-8093-1] com.servoy.j2db.util.Debug - Error executing sql: insert into i18messages (message_key, message_language, message_value) values (?, ?, ?) with params: [‘ass.tool.afdrukken’ ,type: java.lang.String, ‘en’ ,type: java.lang.String, ‘To print’ ,type: java.lang.String]
java.sql.SQLException: Cannot insert the value NULL into column ‘i18messagesid’, table ‘jos_backoffice.dbo.i18messages’; column does not allow nulls. INSERT fails.

Something goes wrong here, but I cannot contral the input queries of this table. Has anyone a clue?

Servoy version 7.3.1 -releaseNumber 2022
MSSQL database

2

Hi Jos,

I had the same problem. Turns out the i18n table definitions is not automatically included in the export, so the servoy sequence for the ‘id’ field is not set causing the inserts of the i18n keys to fail. My work around is to include a dummy form that has the i18n table as the datasource so the definition will be included in the export. I had no time to report this bug yet.

3

This seems to help. Tnx Jeroen!

4

Not the only case, where a dummy form is needed.