Email Subject Length

[DK41]

Hi ,

I have a problem with the subject in the email notifications.The subject gets truncated in the email.

Intiially the max length of the subject was 100 in template notification and also in email logs .I have changed the max length in all the 3 places to 200 it made no change ..made it to 1000 didnt make a change , and also i have personalized style with width = 800px that didnt work and also changed it eo 1300 px ..that also didnt work.

Am I missing anything or is it some database related issue.

Please help as we have a high priority where we have this issue for more than 5 notiifixcations which has been a big issue.

Thanks for your help.

DK

[Mark Stanger]

If it is a database issue then you would see the subject truncated within the system. Is the subject truncated when you type it in the template? Is it truncated in the email log? If it isn't truncated at the email log level then it isn't being truncated by the system and you'd need to look at your local email client.

[DK41]

Yes Linda I did increase the max length of the subject field in the email log.


In the template we have given the subject as fr ex: Review Comments: ${number} Ref - Service Request: ${request_item.request} - ${request_item} - ${request_item.cat_item} and the template is on catalog task l table. which has a max length of 1000 in template as well as email log

In the email log itself the subject is Review Comments: TASK100008 Ref - Service Request: REQ100017 - RITM100014 - Contractor Extension/Te

please let me know hat can be done.

Thanks
DK

[lindac]

Hi,

Did you increase the size of the sys_email.subject field?

Linda

[domaners]

I think that this is an issue with the sys_email.subject field. I've been testing the field lengths on blank email records and while the dictionary shows that I've increased the subject field length, all records I save are truncated to 160 characters. Weirdly, I was able to increase to 1000 in one of our instances with no issues, but I'm unable to reproduce this in our Pre-Prod system. The following Wiki article states that you can contact Technical Support regarding DB field types, so I've raised an Incident on hi that I'm awaiting a response on. If they are able to fix this, I'll update.