KB0017429 – License error caused by a SQL character length constraint

KB Article # 0017429

Applies to: v4.1.x


Licensing error is being displayed caused by a SQL data truncation error in the database. The logs will look something like this:

[org.hibernate.util.JDBCExceptionReporter] – Data truncation
[org.hibernate.util.JDBCExceptionReporter] – String or binary data would be truncated.
[com.ephesoft.license.aspect.LicenseAspect] – Error occured while verifying license.
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [/* update com.ephesoft.dcma.da.domain.ServerLicenseDetails */ update ephesoft_meta_data set last_modified=?, meta_data_6=?, meta_data_1=?, meta_data_4=?, meta_data_3=?, meta_data_7=?, meta_data_2=?, meta_data_5=? where id=?]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update

Root Cause:

Some columns in the ephesoft_meta_data table have a character restriction set up to 255 characters. If Ephesoft tries to insert a longer value because of the encryption settings, SQL returns an error which in turn causes a licensing error.


Set the length of the meta_data_x columns to MAX instead of 255.

This bug will be fixed in v2019.1