Data too long for column error during Crowd Upgrade

Still need help?

The Atlassian Community is here for you.

Ask the community


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(
	at com.mysql.jdbc.PreparedStatement.executeBatch(
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(


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.

Last modified on Nov 21, 2012

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.