Data too long for column error during Crowd Upgrade
Crowd upgrade from 1.X to 2.X is failing with errors:
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'display_name' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
The database schema changed in Crowd 2.0. There may be some columns with excessively long values that will not fit into the new schema.
This is usually not a problem as most names are not long enough to cause this problem. Check for any extremely long data values, particularly in the column referenced in the error.