Error Saving New Mail Template In Crowd 1.x

Still need help?

The Atlassian Community is here for you.

Ask the community


The following error is thrown when saving a new mail template:

SQLException for SQL [update [SERVERPROPERTY] set [NAME]=?, [VALUE]=? where [ID]=?]; SQL state [01004]; error code [0]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation


The Mail Template supports a maximum of 255 characters, as the data type maps to Varchar(255).


The recent schema changes in Crowd 2.0, changed the data type to a CLOB and it's now possible to store up to 4000 characters in the column.

Upgrade to the latest Crowd release for a fix.

Last modified on Nov 21, 2012

Was this helpful?

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