We auto-generate report scheduled requests for emailing.
To keep emails "unique" so Emails systems don't mark them as SPAM, we include emails specific information in the Subject.
Things like Project Code and Project Name
This often exceeds 100 characters (but not 200)
The database fields are limited to 100 characters (200 bytes in UTF-16) so we are forced to truncate.
As I don't see any formal Email restrictions preventing longer subject lines,
could the following tables be changed?
jireportjobalert and jireportjobmail (column SUBJECT) from NVARCHAR2(200) to NVARCHAR2(400)
Components | JasperReports Server, Scheduler |