Symptoms

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

Cause

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

Resolution

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.