Limitation on subject field size for scheduled reports

Somveer Karhan1 · ‎02-14-2017

Hello,

We have scheduled a report to send email on regular intervals with a subject which is 135 characters long. But when the mail is received in the individual mailboxes, the subject contains just first 100 characters.

I believe that must be because of some limitation set on subject. Can anyone guide me on how this limitation can be increased to 150 characters?

Thanks in advance.

Somveer Karhan1 · ‎03-07-2017

The issue has resolved now. Had to modify the width of Subject field on "sysevent_email_action" table.

Thank you Sherry for all the guidance.

View solution in original post

She Sull · ‎02-14-2017

You can try increasing the max length of the Subject field by going to the Dictionary.

Modify string field length

Somveer Karhan1 · ‎02-14-2017

Thank you Sherry. The length of Suject field is already set to 150 and I was able to enter all 135 characters in this field. Issue is that the subject in the received email is of 100 characters only.
I assume there might be some table and field for backend processing of the email where the limit is set to 100. Do you know the flow of email processing and backend tables included in that?

She Sull · ‎02-15-2017

Hi Somveer, this could be related to email rotation tables, there's a sys_email table, but then there are several shards (sys_email001, sys_email002) these may need to be updated as well. Check out Riccardo's reply, last entry in the thread:

Re: Email Subject Length

Somveer Karhan1 · ‎02-21-2017

No luck. Checked and found all the shards have a length of 160 for subject field.