Database errors on importing a file

Symptoms

I was trying to import Prime Telecom app and it was displaying dialog saying can not resolve references.
I followed steps mentioned in Prime telecom primer doc for import.

VoiceObjects is throwing the following error message during import of an application: Caused by: java.sql.SQLException: Data size bigger than max size for this type: 4002

Environment

VoiceObjects
Independent of Operating System

Cause

VoiceObjects tries to write data into the database. In case the data is bigger than one cell can take, VoiceObjects will automatically build SQLs which spread the data over several rows.
In case the encoding is different between VoiceObjects and the database it can happen that VoiceObjects miscalculates the amount of data which can be written into the cell.
In this particular example we see that 4002 chars are written into a cell which holds only 4000 chars.

Resolution

Unify the encoding of VoiceObjects with the one of the database.
Usually only the change of the VoiceObjects settings will be needed.

In case you need to change the encoding of the database (in case you have set it up as ISO-8859-1 but need to have UTF-8 or vice versa) it will unfortunately be needed to set up a whole new DB with the correct encoding and re-import the VoiceObjects projects.

Examples

1. In case you have a UTF-8 database and UTF-8 is what you need in the end - but VoiceObjects is set up for ISO-8859-1 - you only need to change the settings in VoiceObjects (VOServer_Configuration.xml and VODesktop_Configuration.xml) and restart all instances.
2. In case you need to run ISO-8859-1 and your database is UTF-8 in the moment you will unfortunatly need to re-create your databases.