Data too long for column error during Crowd Upgrade
Symptoms
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)
Cause
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.
Resolution
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.
Last modified on Nov 21, 2012
Powered by Confluence and Scroll Viewport.